Executive summary In Azure SQL Database and Azure SQL Managed Instance, the background process that updates statistics asynchronously can now wait for the schema modification lock on a low priority queue. This improves concurrency for workloads with frequent query plan ... continue reading

We’re all adapting to uncertain times. As employees shift to more remote ways of working and consumer behavior changes to meet the new normal, businesses are faced with a challenging choice: slow down operations to operate more cost-effectively, lean into ... continue reading

For production workloads running on your Azure SQL Managed Instance it is very important to continuously understand the resource consumption and any potential performance issues such that you can react in time and have your business running smoothly. There exist ... continue reading

Automated backups on Managed Instance Database backups are an essential part of any business continuity and disaster recovery strategy because they protect your data from accidental corruption or deletion. Azure SQL Managed Instance automatically creates the database backups that are ... continue reading

In the previous article, we have explained how automated backups on Managed Instance work, how are backups piling up, how you can cause backup pile up and associated costs for excess backup storage. In this article you will learn how ... continue reading

We are announcing support for Azure AD pass-through and password hash authentication for Azure SQL DB (single database and database pools), Managed Instance, and Azure Synapse (formerly SQL DW). Azure AD password hash authentication is the simplest way to enable ... continue reading

Wouldn't it be great if you could see how a workload will perform in a new environment before migrating a database to the cloud? Then you could fix any queries that have compatibility errors or move forward with the migration ... continue reading

As organizations face increasing pressure to modernize their applications and infrastructure, the benefits of the cloud have become impossible to ignore. Fortunately, Azure SQL Database managed instance makes it easy to move your SQL Server workloads to the cloud. Nearly ... continue reading

Azure Resource Tags are a powerful tool to help organize your Azure Resources. You may have seen Microsoft's Thomas Mauer recent post on resource tagging, or fellow MVP Tao Yang's post on using Azure Policy to apply tags. Those are ... continue reading

When it comes time to migrate your SQL workloads to Azure, you have a choice of two main deployment options: SQL Server on Azure Virtual Machines and Microsoft Azure SQL Database. Each offers its own benefits, so how do you ... continue reading