SQL Server Radio

Episode 185 - The Liar's Dividend

Guy and Eitan talk about Erik Darling's new monitoring app, which reminds us of similar tools we had experience with long ago. And, again, it's time to talk about AI. Specifically, a side-effect of it called "The Liar's Dividend". Relevant links for more information: Free SQL Server Performance Monitor App by Erik Darling - Brent Ozar Unlimited® Free SQL Server Performance Monitoring | Darling Data The Liar's Dividend - When Nothing Is True, Everything Is Permitted - Eitan Blumin's blog Dear Copilot, can you help me with SQL? - Azure SQL Dev Corner Public Preview - Data Virtualization for Azure SQL Database | Microsoft Community Hub

Episode 184 - The Role of the DBA is Dead (Again)

Looks like it's that time of the year again, to face the impending death of the DBA role! Or... Is it? Guy and Eitan discuss the topic and raise several interesting points you should listen to. Relevant links: sqlfingers.com: Death of the DBA (Again) (Reddit thread)  

Episode 183 - Azure SQL Managed Instance Next Gen

In this year's first episode of the new year, Guy and Eitan discuss the new Next-gen General Purpose tier of Azure SQL Managed Instance, which is now GA. They also discuss a few interesting customer stories, how they were resolved, and how they're not actually SQL Server's fault. Relevant links: Generally Available: Azure SQL Managed Instance Next-gen General Purpose | Microsoft Community Hub The Bitmap Index query plan operator SQL Server on VMware best practices guide How to Save Money on Your SQL Server Hardware

Episode 182 - Matan Yungman's Show-and-Tell of Rapido

Matan Yungman is our special host for today, who came especially to talk about his special project called "Rapido", which is capable of automatically tuning SQL queries at scale. Perhaps there is some inspiration in it for us? Relevant links: Matan Yungman | LinkedIn Matan Yungman (@MatanYungman) / X SQL Server 2025 is Now Generally Available | Microsoft Community Hub Intelligent Query Processing - SQL Server | Microsoft Learn  

Episode 181 - The new SSMS is still blue

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