I am enthusiastic about presenting to the Hartford SQL Server User Group on February 10, 2015.
The meeting venue has changed since the last time I visited to the following:
www.marketgrillct.com
110 Buckland Hills Drive
Manchester , CT 06032
Of course, I am looking forward to seeing my friends John Flannery and Dennis Perlot. However, I love to chat to local user groups about any SQL server topic that I am passionate about.
Here is the details of the presentation that I will be covering tomorrow night. I might even through in what is new with Azure Table Partitioning if we have a good internet connection.
Topic:
Effective Data Warehouse Storage Patterns
Abstract:
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.
Coverage:
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?
Table partitioning in Azure SQL v12.
