Table partitioning for Azure SQL Databases
Duration: 60 minutes
Track: Database Administration
The newest version of Azure SQL Database 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.
No material found.