I am excited about the opportunity to present at SQL Saturday #294 in Philadelphia.
It will be a good time to meet old friends and make new ones.
I hope you have time to attend this awesome free event on June 7th 2014 at the Microsoft Building, 45 Liberty Blvd – Suite 210, Malvern, PA 19355. It only costs $10 if you want a lunch.
Below are the details for my presentation.
Effective Data Warehouse Storage Patterns
Many companies start off with a simple data mart for reporting. As the company grows, users become dependent on the data mart for monitoring and making decisions on Key Performance Indicators (KPI).
Unexpected information growth in your data mart may lead to a performance impacted reporting system. In short, your users will be lining up at your cube for their daily reports.
How do you reduce the size of your data mart and speed up data retrieval?
This presentation will review the following techniques to fix your woes.
1 – What is horizontal partitioning?
2 – Database sharding for daily information.
3 – Working with files and file groups.
3 – Partitioned views for performance.
4 – Table and Index partitions.
5 – Row Data Compression.
6 – Page Data Compression.
7 – Programming a sliding window.
8 – What are Federations in Azure SQL?
Cloud TagsALTER TABLE ALTER TRIGGER BEGIN CREATE DATABASE create function create procedure CREATE TABLE create trigger create view database administrator database developer DATEPART date time functions DDL DECLARE DELETE DROP TRIGGER DROP VIEW EXISTS FORMAT free code IF INSERT ISNULL John F. Miner III math function PASS Presentation PRINT REPLACE SELECT sp_help sp_helptext SQL Server SQL Server Management Studio SSMS. string function sys.objects TRIGGERS TRUNCATE TABLE TSQL UPDATE User Group vb script while