“Oops, I Lost My Indexes in Azure SQL DB.”

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?

Quickstart: Connect SQL Server machines to Azure Arc

Get started with Azure Arc-enabled SQL Server to manage and govern your Windows and Linux SQL Server instances hosted across on-premises, edge, and multicloud environments.

Exploring Parameter Sensitive Plan Optimization in SQL Server 2022

PSPO (Parameter Sensitive Plan Optimization) is a SQL Server feature that improves query performance by accepting varied data sizes based on the runtime parameter value(s) specified by the customer. It deals with the situation in which a single cached plan for a parameterized query isn't the best option for all potential incoming parameter values. Non-uniform data distributions exhibit this phenomenon. When using PSPO, SQL Server keeps several execution plans for a single query, each one customized for a particular parameter value. With the help of this feature, numerous execution plans for a parameterized query are generated, each of which is tailored for a certain range of parameter values.

Creating an Azure SQL Database Using Azure Cloud Shell

This article will show how to use the Azure Cloud Shell and PowerShell to set up a new Azure SQL Database.

Cloud Diagrams

Creating AAD Users in Azure SQL Database

Azure SQL Database Differential Backup Frequency

Full Azure SQL Database Backup Frequency

Azure SQL Database Backups

Creating Azure SQL Databases