I am traveling to the city of saints to present at SQL Saturday #748 in Montreal, Canada. It will be a good time to meet old friends, make new ones and learn something new.

I am really glad that my friend Dennis has decided to go on the road trip with me. It is really boring driving 375+ miles by yourself! I hope you have time to attend this awesome free event on June 2, 2018. I will be talking in a morning session on the following topic.



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 is different in Azure SQL database?


presentation bundle

database backup


Related posts

Leave a Comment