Episode 135 - Announcing SQL Server 2022

Guy and Eitan talk about the interesting new features announced in SQL Server 2022, a new sp_whoisactive version, and a bunch of Microsoft blog posts on Tech Community.

Relevant links:

• SQL Server 2022:
  • Announcing SQL Server 2022 preview: Azure-enabled with continued performance and security innovation
  • Introducing SQL Server 2022 | Bob Ward
  • Announcing the SQL Server 2022 Early Adoption Program
  • SQL Server 2022 | Official Microsoft
• The new version of sp_whoisactive - v12.00
• Extended Events to the Rescue - by Guy Glantser on SQLFriday
• New Microsoft support troubleshooting articles:
  • SQL Server CE: Multiple single-column statistics
  • SQL Server CE: Multiple single-column statistics connected by OR
  • Update Stats Sample Rate does not work
  • Use Orca.exe Tool to Verify Corrupted MSI/MSP file in Failed SQL Patching
  • Use Trace Flag 902 (TF902) to Bring Up Your SQL Service in Failed Post Upgrade Script
  • Prevent SQL Server Dump Generation in Hot Cases: Common Ways & Scenarios
  • Recover TDE Databases in Disaster : Recover Steps for 3 Common Scenarios