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.

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

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

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.

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.

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.

Learn how to secure Azure SQL Managed Instance with best practices for protecting data, managing access, and defending against common threats.

Implement Hybrid Search with SQL Server and Azure SQL using RRF with fulltext search the modern vector similarity search

We are excited to announce the general availability (GA) of the latest improvements in the Azure SQL Database conversion process to Hyperscale. These...

We are pleased to announce the public preview of a new query hint, ABORT_QUERY_EXECUTION. The hint is intended to be used as a Query Store hint to let...

Discover how to efficiently vectorize content in your Azure SQL database. Learn best practices for generating and updating embeddings.

I’ve been working in technology for entirely too long—but one of the first, and most important lessons I learned was try to identify the correct error message, in the right log file, and then it ca…

Discover what’s new in the MSSQL Extension for VS Code v1.29, including UI updates, performance fixes, and key improvements. Plus, get a sneak peek at upcoming features in our open roadmap!

We are thrilled to announce the public preview of three powerful T-SQL features that will elevate your SQL queries: Regular Expressions (Regex) support, Fuzzy string-matching, and bigint support in DA...

Welcome to an exciting, new workshop where we blend the power of AI with the versatility of GraphQL and SQL databases in Microsoft Fabric. This guide will walk you through creating a set of GraphQL RA...

Data is at the heart of every AI application, and efficient data ingestion is critical for success. With over 1,400 enterprise connectors, Logic Apps offers unmatched access to a diverse range of syst...

LangChain Integration for Vector Support for Azure SQL and SQL database in Microsoft Fabric Microsoft SQL now supports native vector search capabilities in Azure SQL and SQL database in Microsoft Fabr...

Boost SQL development with the MSSQL Extension for VS Code. Enjoy a new UI, query tools, and efficient database management. Try it now!