SQL Server

News and technical articles about Microsoft’s SQL Server

MSSQL Extension for VS Code: SQL Formatter, Azure SQL Database Provisioning, and More

Writing and maintaining SQL is easier when you can eliminate repetitive steps and keep your scripts cleanly formatted. With the MSSQL extension for VS Code v1.45, we’re introducing the Public Preview of the SQL Formatter alongside the General Availability of Azure SQL Database Provisioning and Shortcuts Configuration. You can now apply consistent T-SQL formatting across […]

MSSQL Extension for VS Code: SQL Formatter, Azure SQL Database Provisioning, and More Continue Reading

The Two Hybrid Searches in Microsoft SQL

Hybrid search is usually described as combining keyword search with vector search. Microsoft SQL does that, for sure, but we do quite a bit more right out of the box. SQL dynamically evaluates queries and switches between kNN and ANN vector search based on cost and selectivity. These two types of hybrid search, work together,

The Two Hybrid Searches in Microsoft SQL Continue Reading

Beyond Vector Indexes: Azure SQL Brings Optimizer Intelligence to Vector Search

Why production AI retrieval depends on more than vector index performance.  It’s easy to think of AI retrieval as a vector search problem. For many developers, the first conversation starts with vector index benchmarks: How many queries per second can it handle? What’s the latency? What’s the recall? How well does it scale? Those metrics

Beyond Vector Indexes: Azure SQL Brings Optimizer Intelligence to Vector Search Continue Reading

Your best friend: BlockOnPossibleDataLoss=True

Let’s start with an admission: developers all hate BlockOnPossibleDataLoss. It is the bane of a smooth development workflow, as significant schema changes can block deployment because of BlockOnPossibleDataLoss. Having said that, there’s more to life than the developer’s local loop. In fact, it’s arguable that the local loop, while important to you and me, is

Your best friend: BlockOnPossibleDataLoss=True Continue Reading

Build Locally, Ship to Cloud for $0: Azure SQL for Modern App Developers

As app developers, our primary focus is building great user experiences, designing APIs, and shipping features quickly. What we don’t want is database friction—wasting hours configuring local DB instances, writing verbose migration scripts by hand, or worrying about unexpected cloud bills while prototyping. Today, we are making database development fast, intelligent, and completely free. By

Build Locally, Ship to Cloud for $0: Azure SQL for Modern App Developers Continue Reading

Lessons Learned #551: Azure SQL Connection Timeouts: Three Things to Check

An application starts reporting intermittent timeouts when connecting to Azure SQL Database. Some requests succeed, others fail, and a test from a developer’s laptop works perfectly. The database appears online, no recent deployment seems related, and the natural reaction is to ask: Is Azure SQL unavailable? Is the firewall blocking the connection? Should we increase

Lessons Learned #551: Azure SQL Connection Timeouts: Three Things to Check Continue Reading

Understanding Azure SQL Long-Term Retention Immutability Configuration with Terraform and AzAPI

Executive Summary Organizations using Azure SQL Database Long-Term Retention (LTR) backup policies may encounter failures when attempting to disable backup immutability while also specifying an immutability mode in the same request. In the investigated scenario, the customer observed that the operation succeeded when performed through ARM templates but failed when executed through Terraform using AzAPI-based

Understanding Azure SQL Long-Term Retention Immutability Configuration with Terraform and AzAPI Continue Reading

Troubleshooting SQL Authentication Failures on Azure SQL Database Geo-Secondary Replicas

Scenario Background During a recent investigation, a customer reported that SQL Authentication was failing when connecting to an Azure SQL Database geo-secondary replica. The customer confirmed the following: SQL Authentication worked successfully against the primary replica. The geo-secondary database was healthy and synchronized. The replicated database user existed in the secondary database. Microsoft Entra authentication

Troubleshooting SQL Authentication Failures on Azure SQL Database Geo-Secondary Replicas Continue Reading

Lessons Learned #550: From a Support Case to Reusable Knowledge

Reaching Lessons Learned #550 is an important milestone for me. However, the value of this series is not only the number of articles published. Each article started with a technical question, an unexpected behavior, a support investigation, or a scenario that required additional testing and analysis. Some cases resulted in a configuration change. Others required

Lessons Learned #550: From a Support Case to Reusable Knowledge Continue Reading

Lessons Learned #549: Reproduce, Challenge, and Validate – Testing Technical Assumptions

During an Azure SQL investigation, the available evidence may point to a technically reasonable explanation. For example: A network change may appear to explain a connectivity issue. High CPU may appear to explain a performance degradation. A query plan change may appear to explain a longer execution time. A failover may appear to explain why

Lessons Learned #549: Reproduce, Challenge, and Validate – Testing Technical Assumptions Continue Reading