<\/p>\n
<\/p>\n
I am enthusiastic about presenting to the Hartford SQL Server User Group on February 10, 2015. <\/p>\n
The meeting venue has changed since the last time I visited to the following:<\/p>\n
<\/p>\n
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.<\/p>\n
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.<\/p>\n
Topic:<\/span><\/p>\n Effective Data Warehouse Storage Patterns<\/p>\n Abstract:<\/span><\/p>\n 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).<\/p>\n 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.<\/p>\n How do you reduce the size of your data mart and speed up data retrieval?<\/span><\/p>\n This presentation will review the following techniques to fix your woes.<\/p>\n Coverage:<\/span><\/p>\n 1 – What is horizontal partitioning?
\n2 – Database sharding for daily information.
\n3 – Working with files and file groups.
\n3 – Partitioned views for performance.
\n4 – Table and Index partitions.
\n5 – Row Data Compression.
\n6 – Page Data Compression.
\n7 – Programming a sliding window.
\n8 – What are Federations in Azure SQL?<\/strike>
\n Table partitioning in Azure SQL v12.<\/p>\n