Episode 186 - Automatic Index Compaction and New DB DevOps Tooling

Guy and Eitan discuss several very interesting new features recently announced by Microsoft. Relevant links for more info: Stop defragmenting and start living: introducing auto index compaction | Microsoft Community Hub Automatic Index Compaction - SQL Server | Microsoft Learn Database DevOps (preview) in SSMS 22.4.1 | Microsoft Community Hub Manage SQL database schemas in VS Code: Publish dialog and item templates - Azure SQL Dev Corner Publish SQL Database Projects from Visual Studio Code - SQL Server | Microsoft Learn SQL code analysis in VS Code: Configure rules without editing your project file - Azure SQL Dev Corner SQL Projects Roadmap - DacFx Wiki Author Custom Code Analysis Rules - SQL Server | Microsoft Learn

You can listen to Episode 186 - Automatic Index Compaction and New DB DevOps Tooling online on Radio and Podcast. Open the player on this page to stream the available audio.

Episode 186 - Automatic Index Compaction and New DB DevOps Tooling is an episode from SQL Server Radio by Guy Glantser.

This episode is 31:16 long.

This episode was published on Apr 13, 2026.

Yes. Use the heart button on the episode page to add it to your favorite episodes list.

Yes. This page shows related episodes from SQL Server Radio when more episodes are available from the podcast feed.