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