Details

Table partitioning for Azure SQL Databases

Speaker: John Miner

Duration: 60 minutes

Track: Database Administration

Abstract:
   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?


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.

Accompanying Material

No material found.


Back to Top
cage-aids
cage-aids
cage-aids
cage-aids