I am thrilled about presenting to the Southern New England SQL Server User Group (SNESSUG) on June 12, 2013. <\/p>\n
I always love the home team advantage by knowing the audience very well. It makes for a relaxing environment to teach and attendees to learn.<\/p>\n
Here is the gritty details of the presentation that I will be exploring during the 90 minute talk.<\/p>\n
<\/p>\n
<\/p>\n
<\/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?<\/p>\n