Episode 181 - The new SSMS is still blue

About this episode

Guy and Eitan discuss the new preview version of SSMS, application locks, and issues with TempDB shrinkage.

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

People in this episode

Hosts: Guy Glantser, Eitan Blumin

Topics covered

• SQL Server Management Studio
• application locks
• TempDB shrinkage
• preview version
• database management

Keywords

• SSMS
• SQL Server
• application locks
• TempDB
• database shrinkage
• preview version
• Microsoft

Mentioned in this episode

Organizations: Microsoft Community Hub, Microsoft Learn, microsoft-dbas-club

Products: SQL Server Management Studio 22 Preview 3, SQL Server Management Studio 22 Preview 4

Books & works: sp_getapplock (Transact-SQL)

More episodes of SQL Server Radio

• Episode 188 - Virtualization pitfalls and best practices with SQL Server · June 8, 2026 · 30 min
• Episode 187 - Transactional Replication Between Availability Groups · May 13, 2026 · 30 min
• Episode 186 - Automatic Index Compaction and New DB DevOps Tooling · April 13, 2026 · 31 min
• Episode 185 - The Liar's Dividend · March 9, 2026 · 36 min
• Episode 184 - The Role of the DBA is Dead (Again) · February 9, 2026 · 36 min
• Episode 183 - Azure SQL Managed Instance Next Gen · January 12, 2026 · 36 min