Uploaded September 2026 | Updated November 2026, 2 hours ago
Automatic index compaction (currently in public preview across Azure SQL DB, MI, and SQL database in Fabric) is a game changer for index maintenance. Learn how.
β Chapters:
0:00 intro
0:30 what's the problem - index maintenance
2:00 intro to automatic index compaction
2:40 why it might be the end of index maintenance
3:15 demo
5:20 details on automatic index compaction
6:30 tips and tricks
βοΈ Resources:
learn.microsoft.com/sql/relational-databases/indexes/automatic-index-compaction
Demo: github.com/microsoft/bobsql/tree/master/demos/auto_index_compaction
π Let's connect:
Twitter - Bob Ward, twitter.com/bobwardms
Twitter - Anna Hoffman, twitter.com/AnalyticAnna
Twitter - AzureSQL, https://aka.ms/azuresqltw
π΄ Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt
π Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: https://aka.ms/msazuresqlyt
Microsoft SQL Server: https://aka.ms/mssqlserveryt
Microsoft Developer: https://aka.ms/microsoftdeveloperyt
#AzureSQL #SQL #LearnSQL
Automatic index compaction (currently in public preview across Azure SQL DB, MI, and SQL database in Fabric) is a game changer for index maintenance. Learn how.
β Chapters:
0:00 intro
0:30 what's the problem - index maintenance
2:00 intro to automatic index compaction
2:40 why it might be the end of index maintenance
3:15 demo
5:20 details on automatic index compaction
6:30 tips and tricks
βοΈ Resources:
learn.microsoft.com/sql/relational-databases/indexes/automatic-index-compaction
Demo: github.com/microsoft/bobsql/tree/master/demos/auto_index_compaction
π Let's connect:
Twitter - Bob Ward, twitter.com/bobwardms
Twitter - Anna Hoffman, twitter.com/AnalyticAnna
Twitter - AzureSQL, https://aka.ms/azuresqltw
π΄ Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt
π Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: https://aka.ms/msazuresqlyt
Microsoft SQL Server: https://aka.ms/mssqlserveryt
Microsoft Developer: https://aka.ms/microsoftdeveloperyt
#AzureSQL #SQL #LearnSQL










