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.
If that is not enough excitement, the 119th Boston Marathon is gearing up for Monday’s race and the Red Sox are playing the Orioles until Monday.
I hope you have time to stop by bean town and have some fun.
Topic:
Table partitioning for Azure SQL Databases
Abstract:
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?
Coverage:
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.
Hi John,
Other than the limitation of having to use the primary file group in SQL Azure databases do you see any additional features that are not supported inside of Azure DB in regards to partitioning compared to On-Prem?
Regards,
John
The Azure table partition works just like regular partitioning. The only draw back is you have no control or insight into what the database engine is doing. Then again, it is a Software As A Service (SAAS) platform.