Providence – SQL Saturday #213

I want to thank the SNESSUG SQL Saturday committee for their hard work in organizing the SQL Saturday #213 event. I know it will be a hit like last year.

I will be the master of ceremonies for this event. There is an awesome line up of speakers this day. It should be a good time to network with other professionals in the field and learn some new things about the product. I hope you have time to attend cool event on September 21st, 2013.

Below are the details of my presentation.

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?

Details:

presentation bundle

Related posts

Leave a Comment