Partitioning from the trenches

Partitioning manipulates billions of rows instantly and is an essential skill for higher level (higher paid) DBA roles. A simple concept to grasp but it changes familiar concepts - even clustered indexes - so be prepared for surprises! Peel back the curtain in this accessible but deep dive session and go beyond the concepts to tricky real world problems at multi-terabyte scale - understand these and you'll gain an essential new marketable skill. Partitioning is no longer Enterprise-only and is available in the cheapest Azure SQL SKUs - this session is up to date with the latest versions. If inserting or deleting a LOT of data is slow for you and think there's a better way - then this session is for you. Delivered by two speakers who designed and implemented multi-terabyte internet-scale databases systems ever since partitioning was introduced all the way back in SQL 2005.