Deploy SQL MCP Server without a configuration file using DAB_CONNSTRING. Get started quickly with Docker, Azure Container Apps, ACI, or AKS.

An overview of database watcher for Azure SQL, a managed monitoring solution for database services in the Azure SQL family.

Create a transactionally consistent copy of an existing database in Azure SQL Database on either the same logical server or a different logical server.

Today we're announcing the retirement of database watcher for Azure SQL Database and Azure SQL Managed Instance. This includes monitoring for databases in...

Today we're announcing the retirement of database watcher for Azure SQL Database and Azure SQL Managed Instance. This includes monitoring for databases in...

Learn about default PITR backup immutability and how to permanently lock immutability to the configured retention period in Azure SQL Database and Azure SQL Managed Instance.

In this article, you create an Azure SQL Database server and database using Terraform.

In this article, you create an Azure SQL Database server and database using Terraform.

Automatic index compaction (currently in public preview across Azure SQL DB, MI, and SQL database in Fabric) is a game changer for index maintenance. Learn how. ✅ Chapters: 0:00 intro 0:30 what's the problem - index maintenance 2:00 intro to automatic index compaction 2:40 why it might be the end of index maintenance 3:15 demo 5:20 details on automatic index compaction 6:30 tips and tricks ✔️ Resources: https://learn.microsoft.com/sql/relational-databases/indexes/automatic-index-compaction 📌 Let's connect: Twitter - Bob Ward, https://twitter.com/bobwardms Twitter - Anna Hoffman, https://twitter.com/AnalyticAnna Twitter - AzureSQL, https://aka.ms/azuresqltw 🔴 Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #SQL #LearnSQL

My previous post on load testing Azure SQL covered the General Purpose Edition, let's move it up to the Business Critical Tier The Business Critical tier comes in two flavours: General and confidential compute. For my testing, I've stuck with the General SKU. I haven't seen confidential compute with customers, and it has very specific use cases: you want to protect your threads on the processor itself.

You told us that applications using Microsoft.Data.SqlClient can take too long to establish the database connections they need. When many requests need

This article introduces pattern-based masking with examples and limitation. Ite was last updated by Microsoft Learn with disclosed AI involvement in March 2026.#databases #Azure #AzureSQL #AzureSQLDatabase #AzureSQLDB #DatabaseSecurity #DataProtection #DataSecurity #Cybersecurity #TSQL #SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-regex?view=azuresql&wt.mc_id=DP-MVP-4015656

Use REGEXP_REPLACE in Azure SQL Database dynamic data masking to define pattern-driven masks for emails, phone numbers, and other structured string data.

Developers, database administrators, data professionals, architects and technology decision makers have several opportunities to connect, learn and gain

SQL query and management tools for SQL Server, Azure SQL (Azure SQL database, Azure SQL managed instance, SQL virtual machines), and Azure Synapse Analytics.

My previous post on load testing Azure SQL covered the Premium Edition; today I'm moving to the General Purpose Tier. The GP tier comes in two flavours: regular and serverless. Serverless has only one hardware tier: Gen5. With provisioned, you can also select memory-optimised or confidential compute. In earlier tests, I never found significant differences between serverless and provisioned, so I skipped testing both SKUs.

Explore Index Maintenance and Automatic Compaction to rethink your SQL Server administration routine for better performance.

We're excited to announce the public preview of performance monitoring for Azure SQL in Database Hub in Fabric. Performance monitoring brings the health and...

We're pleased to announce the general availability of Query Editor for Azure SQL Database. The updated experience brings a multi-tab query workspace, easier...

My previous post on load testing Azure SQL covered the Standard Edition; today I'm moving to the Premium Edition, which is Business Critical in DTU shape. Again, the calculation mixes CPU, Memory, and disk I/O. The main difference between Standard and Premium is cost. Premium is more expensive and aimed at mission-critical workloads. It has faster storage and built-in replication options.

Learn about system assigned and user assigned managed identities in Microsoft Entra for Azure SQL Database and Azure SQL Managed Instance.

What’s changing We’re introducing a new script-based deployment experience for provisioning SQL Server on Linux Azure Virtual Machines (VMs). This...

This series of posts is much overdue, but with good reason. When I started hammering Azure SQL again, I had a set of scripts to run and tried to figure out what was happening. For most databases, I could explain the results, but some didn't make sense. I'll get back to that later in this series. A few years ago, I did a similar performance-testing series, where I created the data on the database itself using SqlStress to run a massive load of queries and see what happened.