I got an interesting request for consulting, and I’m going to paraphrase it:
We were using Azure SQL DB with automatic index tuning enabled for months. Things were going great, but… we just deployed a new version of our code. Our deployment tool made the database schema match our source control, which… dropped the indexes Azure had created. How do we get them back?
Read on for Brent’s answer.