The End of Index Maintenance? | Data Exposed

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:
https://learn.microsoft.com/sql/relational-databases/indexes/automatic-index-compaction

📌 Let's connect:
Twitter - Bob Ward, https://twitter.com/bobwardms
Twitter - Anna Hoffman, https://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