A little road trip to bean town is planned this weekend.
I am really honored to have the opportunity to present at SQL Saturday #364 in Boston. It will be a good time to meet old friends and make new ones.
This year’s event has an all star line up of MVP’s who are talking at this free event on April 18th, 2015.
I hope you have time to stop by bean town and have some fun.
Table partitioning for Azure SQL Databases
The newest version of Azure SQL Database V12 is currently in preview.
Table partitioning has been added to this offering to replace Azure federations.
Do you know how to effectively leverage this new feature for data warehousing?
1 – Various editions of Azure SQL database.
2 – How Service objective relates to performance.
3 – Difference between horizontal and vertical partitioning.
3 – Table / Index partitioning in Azure SQL database.
4 – A review of MERGE, SPLIT and SWITCH statements.
5 – Implementing a sliding window.
6 – Introduction to data compression.
7 – Difference between ROW and PAGE compression.
8 – Adding compression to partitions to reduce space.
9 – Review findings from performance tests.
Here is a place holder for the slide deck. I will update later after the event.