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 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
• Episode 181 - The new SSMS is still blue · November 10, 2025 · 33 min
• Episode 180 - Computed Columns with PERSISTED and Indexed Expressions · October 13, 2025 · 38 min

Explore listener stats, chart rankings, contacts and more on the SQL Server Radio podcast page.