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