Episode 186 - Automatic Index Compaction and New DB DevOps Tooling

About this episode

Guy and Eitan discuss several new features recently announced by Microsoft, including automatic index compaction and new database 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

People in this episode

Hosts: Guy Glantser, Eitan Blumin

Topics covered

• Automatic Index Compaction
• Database DevOps
• SQL Server features
• Microsoft announcements
• SQL database management

Keywords

• index compaction
• database DevOps
• SQL Server
• Microsoft features
• Visual Studio Code

Mentioned in this episode

Organizations: Microsoft, Microsoft Community Hub, SQL Server, Azure SQL Dev Corner, DacFx Wiki

Products: SSMS 22.4.1, Visual Studio Code

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 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
• Episode 182 - Matan Yungman's Show-and-Tell of Rapido · December 8, 2025 · 41 min