Select Page
wlp-disabled.png

Improving concurrency of asynchronous statistics update

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
S Q L logo in a blue cloud

Save money and improve agility and scale by modernizing your SQL Server to Azure SQL

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
Monitoring screenshot.png

Monitoring options available for Azure SQL Managed Instance

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

Backup storage consumption on Managed Instance explained

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

Fine tuning backup storage costs on Managed Instance

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
Last1.png

Azure AD pass-through and password hash authentication support for SQL DB, DW and Managed Instance

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

Migrate SQL workloads to the cloud with confidence

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

Azure SQL Database managed instance vs. SQL Server

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
2020-03-21_11-02-35.png

Dynamic Monitoring with Azure Monitor Workbooks and Resource Tags

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

Tips to select the best Azure SQL deployment option

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