Post: Managing Drift in Automated Deployments to SQL Server Databases

LitKnd / littlekendracomments

1 stars 0 forks source link

Post: Managing Drift in Automated Deployments to SQL Server Databases #30

Open LitKnd opened 3 years ago

LitKnd commented 3 years ago

Comments entered here will automatically appear on https://www.littlekendra.com/2021/06/04/managing-drift-automated-deployments-sql-server/

Dann-DBA commented 2 years ago

Curious to hear your thoughts on how to manage drift introduced by enabling Automatic Index Tuning in Azure SQL. It seems to be a recommended practice to enable Automatic Index Tuning, but little guidance in how to best manage propagating successful index suggestions back through development and staging environments.