• Azure - SQLServer

    Azure SQL Database- Automatic Index Management

    As I begin my education in SQL Server 2017, as well as Azure SQL Database, my attention was caught by the optimizer improvements and especially automatic tuning. Often referred to with features starting with the naming convention of “dynamic” in Oracle, many automatic features either thrill or frustrate DBAs, no matter what the platform.  The frustration enters with the features introduction and often decreases as the feature matures and becomes more stable.  With the introduction of the Automatic Tuning from Microsoft, there’s a sense of concern, but also some very promising ways Microsoft is introducing these features. With Automatic Tuning,…