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 186 - Automatic Index Compaction and New DB DevOps Tooling
- Episode 185 - The Liar's Dividend
- Episode 184 - The Role of the DBA is Dead (Again)
- Episode 183 - Azure SQL Managed Instance Next Gen
- Episode 182 - Matan Yungman's Show-and-Tell of Rapido
- Episode 180 - Computed Columns with PERSISTED and Indexed Expressions
Explore listener stats, chart rankings, contacts and more on the SQL Server Radio podcast page.