SQL Server Radio

<p>Guy and Eitan discuss a few new things in the latest SSMS update, and Eitan tells about a very peculiar use case involving transactional replication and AlwaysOn Availability Groups, and Guy talks about a use case...

<p>Guy and Eitan discuss several very interesting new features recently announced by Microsoft.</p> <p>Relevant links for more info:</p> Stop defragmenting and start living: introducing auto index compaction | Microsoft...

<p>Guy and Eitan talk about Erik Darling's new monitoring app, which reminds us of similar tools we had experience with long ago.</p> <p>And, again, it's time to talk about AI. Specifically, a side-effect of it called...

<p>Looks like it's that time of the year again, to face the impending death of the DBA role!</p> <p>Or... Is it?</p> <p>Guy and Eitan discuss the topic and raise several interesting points you should listen to.</p>...

<p>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...

<p>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.</p> <p>Perhaps there is some...

<p>Guy and Eitan talk about the new preview version of SSMS, application locks, and stupid troubles with TempDB shrinkage.</p> <p>Relevant links:</p> Announcing the Release of SQL Server Management Studio 22 Preview 3 |...

<p>We let a dice roll decide today's topic, and the winner ended up being: Computed Columns with PERSISTED and Indexed Expressions. We give our thoughts about it, best practices, pit falls, and tips.</p> <p>Relevant...

<p>Guy and Eitan discuss several interesting announcements and updates from Microsoft related to SQL Server and VS Code. And also Eitan talks about a weird issue he encountered involving page latch time-outs during DBCC...

<p>Guy and Eitan discuss security-related best practice scripts, and several interesting AI topics.</p> <p>Relevant links:</p> microsoft-dbas-club/Security and Compliance/Check_Passwords_SQL_Server_Generated.sql...

<p>Guy and Eitan discuss Stephen Planck's blog post "Five SQL Server 2025 Enhancements DBAs Will Notice", and add some of their own insights.</p> <p>Relevant links:</p> Five SQL Server 2025 Enhancements DBAs Will Notice...

<p>Many announcements and interesting releases came out this past month, so we got a lot to talk about in this episode!</p> <p>Relevant links:</p> What's New in SQL Server 2025 - SQL Server | Microsoft Learn SQL Server...

<p>Guy talks about a recent migration project he was working on to move an on-prem SQL Server to AWS RDS.</p> <p>Eitan talks about a new AI-related feature in Azure SQL Databases.</p> <p>And we also discuss the new...

<p>Guy and Eitan worry about the decline in SQL Server feature quality. But maybe there's something else behind it?</p> <p>Relevant links:</p> Improving Azure SQL Database reliability with accelerated database recovery...

<p>Guy and Eitan discuss a few interesting topics. Including a fun new game called "SQL Noir", how to implement statistical clustering model in SQL, about surrogate and natural keys, and the recently announced...