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