The End of Index Maintenance? | Data Exposed

Microsoft Developer covers automatic index compaction (public preview) and how it can reduce or eliminate traditional index maintenance work for Azure SQL Database, Azure SQL Managed Instance, and SQL database in Microsoft Fabric.

Overview

The video explains the problem space around traditional index maintenance and introduces automatic index compaction, a feature currently in public preview across:

• Azure SQL Database
• Azure SQL Managed Instance (MI)
• SQL database in Microsoft Fabric

It also includes a demo and practical guidance on how to approach the feature.

What the episode covers

• Why index maintenance is a recurring operational problem
• What automatic index compaction is
• Why this feature could significantly reduce manual index maintenance tasks
• A demo of the capability
• Additional details, plus tips and tricks for using it effectively

Resources

• Automatic index compaction documentation: https://learn.microsoft.com/sql/relational-databases/indexes/automatic-index-compaction