SQL Server 2022 and the Wheel of Power

on YouTube ↗51m

" summary

SQL Server 2022 ships cloud connectivity and on‑prem tools: Azure Arc enabled SQL Server installs a connected machine agent, monitoring agent and SQL extension to provide free inventory, KQL queries via Azure Resource Graph, pay‑as‑you‑go per‑hour‑per‑core licensing, Synapse Link and managed instance DR using distributed availability groups. Query engine adds dop feedback (DB compat 160) that staircases MaxDOP down (example 32→12), persists decisions in Query Store, never below 2, plus parameter‑sensitive plans and CE feedback. Data virtualization reads Parquet/Delta via PolyBase REST, CETAS, OPENROWSET and external statistics.

AI-written summary · about

" chapters (8)

1. 0:00Start
2. 3:17SQL Server 2022 capabilities
3. 6:54Link feature for Managed Instance
4. 10:20Offline Disaster Recovery with SQL Server 2022
5. 12:33Azure Arc-enabled SQL Server
6. 21:54Intelligent Query Processing (IQP) NextGen
7. 26:20The pain of MAXDOP
8. 43:43Data virtualization in SQL Server 2022

" related talks

• 48mThe Kingdom of AdventureWorks Calls for AidBob Ward, Buck Woody, Sanjay Mishra, Asad Khan · SQLBits 2022
• 01h 02mNot your Father's SQL Server: Developer Innovations in Data StorageJerry Nixon · Visual Studio Live! @ Microsoft HQ 2025
• 49mSQL Server and Windows Server Better together on AzureBob Ward, Dilip Ramachandran · SQLBits 2024
• 50mSQL Server 2022 Performance EnhancementsOla Hallengren · SQLBits 2024
• 22mFlight of Innovation: Enhancing On-Prem and Multi-Cloud SQL Instances with a Cloud CockpitBen Weissman · SQLBits 2019
• 50mSQL Server 2022 Performance EnhancementsOla Hallengren · SQLBits 2022
• 49mOperational insights in your hybrid-cloud multi-cloud SQL inventory outside azure using Arc SQL ServDhananjay Mahajan · SQLBits 2024
• 22mFlight of Innovation: Enhancing On-Prem and Multi-Cloud SQL Instances with a Cloud CockpitBen Weissman · SQLBits 2022