Guy and Eitan talk about the new preview version of SSMS, application locks, and stupid troubles with TempDB shrinkage.
Relevant links:
- Announcing the Release of SQL Server Management Studio 22 Preview 3 | Microsoft Community Hub
- Release Notes for SQL Server Management Studio (SSMS) 22 Preview 3
- Get Started - GitHub Copilot in SQL Server Management Studio (Preview) | Microsoft Learn
- Overview of the Query Hint Recommendation Tool (Preview) - SQL Server Management Studio | Microsoft Learn
- Announcing the Release of SSMS 22 Preview 4 | Microsoft Community Hub
- sp_getapplock (Transact-SQL) - SQL Server | Microsoft Learn
- microsoft-dbas-club/Utility Scripts/Shrink_Database_File_in_Specified_Increments.sql
- microsoft-dbas-club/TempDB/TempDB_Sizing_Check_and_Remediation.sql
- microsoft-dbas-club/TempDB/TempDB Space Utilization Check.sql