# Azure SQL Dev Corner

Voices from the Azure SQL PM Team, focusing on development and developers

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## MSSQL Extension for VS Code: Local Azure SQL Database Provisioning, Query Performance Dashboard, and more

DevFeed: [MSSQL Extension for VS Code: Local Azure SQL Database Provisioning, Query Performance Dashboard, and more](<https://devfeed.tech/articles/mssql-extension-for-vs-code-local-azure-sql-database-provisioning-query-performance-dashboard-and-more-140691.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/vscode-mssql-november2026/>)

Author: Yo-Lei Chen

Published: 2026-11-17T22:03:17Z

Content type: release

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>), [sql-database](<https://devfeed.tech/topics/sql-database.md>), [database-optimization](<https://devfeed.tech/topics/database-optimization.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [database monitoring](<https://devfeed.tech/topics/database-monitoring.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [Azure](<https://devfeed.tech/topics/azure.md>), [VS Code Extension](<https://devfeed.tech/topics/vscode-extension.md>)

Tags: [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [azure-sql-database](<https://devfeed.tech/tags/azure-sql-database.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [container](<https://devfeed.tech/tags/container.md>), [dashboard](<https://devfeed.tech/tags/dashboard.md>), [data-api-builder](<https://devfeed.tech/tags/data-api-builder.md>), [database](<https://devfeed.tech/tags/database.md>), [deployment](<https://devfeed.tech/tags/deployment.md>), [dev](<https://devfeed.tech/tags/dev.md>), [development](<https://devfeed.tech/tags/development.md>), [extension](<https://devfeed.tech/tags/extension.md>), [github-copilot](<https://devfeed.tech/tags/github-copilot.md>), [local](<https://devfeed.tech/tags/local.md>), [mssql](<https://devfeed.tech/tags/mssql.md>), [net](<https://devfeed.tech/tags/net.md>), [performance](<https://devfeed.tech/tags/performance.md>), [provisioning](<https://devfeed.tech/tags/provisioning.md>), [query](<https://devfeed.tech/tags/query.md>), [sql](<https://devfeed.tech/tags/sql.md>), [visual-studio-code](<https://devfeed.tech/tags/visual-studio-code.md>), [vs-code](<https://devfeed.tech/tags/vs-code.md>), [vscode-mssql](<https://devfeed.tech/tags/vscode-mssql.md>), [wizard](<https://devfeed.tech/tags/wizard.md>), [workflow](<https://devfeed.tech/tags/workflow.md>)

### AI overview

MSSQL extension for VS Code v1.48 adds three public previews: local Azure SQL Database containers, a local-to-cloud deployment wizard, and a Query Performance Dashboard. The container runs the Azure SQL engine locally without an Azure subscription, supports Docker, Podman, nerdctl, and WSL containers, and can be managed from VS Code; cloud-specific behavior still needs testing against Azure SQL Database. The deployment wizard checks compatibility and copies schema only or schema and data to a new Azure SQL Database, but requires a running local database and an Azure subscription with resource-creation permissions. The dashboard surfaces Query Store query costs, history, waits, and plans; Query Store must be enabled with captured workload data, and users need read permission. The release also previews multi-results grids and live query statistics, adds nested connection groups, and improves Data API builder redeployment and local CLI workflows, including Microsoft Entra database authentication.

### Source excerpt

A local database is a useful starting point, but deploying it and understanding how queries behave should fit into the same development workflow. The MSSQL extension for VS Code v1.48 brings three new public previews: Azure SQL Database local container provisioning, a local-to-cloud deployment wizard, and the Query Performance Dashboard. This November release also expands [...] The post MSSQL Extension for VS Code: Local Azure SQL Database Provisioning, Query Performance Dashboard, and more appeared first on Azure SQL Dev Corner.

## Fuzzy string matching is now generally available across Microsoft SQL

DevFeed: [Fuzzy string matching is now generally available across Microsoft SQL](<https://devfeed.tech/articles/fuzzy-string-matching-is-now-generally-available-across-microsoft-sql-140689.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/fuzzy-string-matching-is-now-generally-available-across-microsoft-sql/>)

Author: Abhiman Tiwari

Published: 2026-11-17T20:54:16Z

Content type: article

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Entity resolution](<https://devfeed.tech/topics/entity-resolution.md>), [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>)

Tags: [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [azure-sql-database](<https://devfeed.tech/tags/azure-sql-database.md>), [azure-sql-managed-instance](<https://devfeed.tech/tags/azure-sql-managed-instance.md>), [edit-distance](<https://devfeed.tech/tags/edit-distance.md>), [fabric-sql-database](<https://devfeed.tech/tags/fabric-sql-database.md>), [fuzzy-string-matching](<https://devfeed.tech/tags/fuzzy-string-matching.md>), [managed-instance](<https://devfeed.tech/tags/managed-instance.md>), [microsoft](<https://devfeed.tech/tags/microsoft.md>), [microsoft-sql](<https://devfeed.tech/tags/microsoft-sql.md>), [native](<https://devfeed.tech/tags/native.md>), [similarity](<https://devfeed.tech/tags/similarity.md>), [sql-database-in-fabric](<https://devfeed.tech/tags/sql-database-in-fabric.md>), [sql-server-2025](<https://devfeed.tech/tags/sql-server-2025.md>), [string-matching](<https://devfeed.tech/tags/string-matching.md>), [t-sql](<https://devfeed.tech/tags/t-sql.md>)

### AI overview

Microsoft SQL now offers four native T-SQL fuzzy matching functions across Azure SQL Database, Azure SQL Managed Instance, SQL database in Microsoft Fabric, and SQL Server 2025 CU11 or later. `EDIT_DISTANCE` uses restricted Damerau-Levenshtein (Optimal String Alignment) to count insertions, deletions, substitutions, and transpositions; its optional distance limit returns the actual count within the limit and limit + 1 when exceeded. `EDIT_DISTANCE_SIMILARITY` normalizes that count. Jaro-Winkler functions score character resemblance, including a fixed shared-prefix preference, so they can rank names but may score distinct organizations highly. These scores indicate resemblance, not identity or probability. The article recommends narrowing candidates with trusted attributes before comparing, validating cutoffs on labeled data, and confirming likely matches with independent evidence. Inputs require supported Windows or binary collations, bounded character types, and return NULL for NULL inputs; `varchar(max)` and `nvarchar(max)` are unsupported.

### Source excerpt

Four native T-SQL functions that tell you how close two strings are, not just whether they're equal. MICROSFT isn't MICROSOFT. MARHTA isn't MARTHA. INV-1O08 isn't INV-1008. To an equality check, each pair is simply different. To your business, each is a near miss worth catching. Today, fuzzy string matching is generally available in Microsoft SQL. EDIT_DISTANCE tells you MICROSFT is one edit from MICROSOFT. JARO_WINKLER_SIMILARITY scores MARTHA and MARHTA at 96 out of 100. [...] The post Fuzzy string matching is now generally available across Microsoft SQL appeared first on Azure SQL Dev Corner.

## SqlPackage Deployment History and Fast Comparison Preview

DevFeed: [SqlPackage Deployment History and Fast Comparison Preview](<https://devfeed.tech/articles/sqlpackage-deployment-history-and-fast-comparison-preview-137794.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/sqlpackage-deployment-history-and-fast-comparison-preview/>)

Author: Matt Hyon

Published: 2026-11-17T03:11:04Z

Content type: tutorial

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [Deployment](<https://devfeed.tech/topics/deployment.md>), [CI/CD](<https://devfeed.tech/topics/cicd.md>)

Tags: [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [build](<https://devfeed.tech/tags/build.md>), [comparison](<https://devfeed.tech/tags/comparison.md>), [deployment](<https://devfeed.tech/tags/deployment.md>), [devops](<https://devfeed.tech/tags/devops.md>), [fast](<https://devfeed.tech/tags/fast.md>), [history](<https://devfeed.tech/tags/history.md>), [preview](<https://devfeed.tech/tags/preview.md>), [sql-database-projects](<https://devfeed.tech/tags/sql-database-projects.md>)

### AI overview

SqlPackage 170.6 preview adds `LogDeployment` to record deployments and opt-in `EnableFastComparison` to skip full schema comparison when a compatible history record matches the model checksum and deployment options. New targets and changed or incompatible models use normal comparison; fast comparison is not a live drift check, and its match skips pre- and post-deployment scripts. Deployment history supports traceability and project-version conditions in scripts, but does not enforce version order or provide rollback. The walkthrough also warns against combining this workflow with DAC registration and recommends normal comparison when checking the live schema matters. The described behavior is preview-specific and may change.

### Source excerpt

Database deployments should be repeatable. A SQL database project describes the desired schema, its build produces a .dacpac, and SqlPackage compares that model with a target database to work out the changes to apply. But what happens when a pipeline publishes the same database model again? Even when nothing needs to change, determining that can [...] The post SqlPackage Deployment History and Fast Comparison Preview appeared first on Azure SQL Dev Corner.

## What's new across Microsoft SQL at Microsoft Ignite 2026

DevFeed: [What's new across Microsoft SQL at Microsoft Ignite 2026](<https://devfeed.tech/articles/what-s-new-across-microsoft-sql-at-microsoft-ignite-2026-140692.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/whats-new-across-microsoft-sql-at-microsoft-ignite-2026/>)

Author: Anna Hoffman

Published: 2026-11-16T23:40:42Z

Content type: release

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>), [Visual Studio Code](<https://devfeed.tech/topics/visual-studio-code.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Microsoft](<https://devfeed.tech/topics/microsoft.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [agent-skills](<https://devfeed.tech/tags/agent-skills.md>), [agentic](<https://devfeed.tech/tags/agentic.md>), [agents](<https://devfeed.tech/tags/agents.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-agents](<https://devfeed.tech/tags/ai-agents.md>), [ai-developer](<https://devfeed.tech/tags/ai-developer.md>), [ai-powered](<https://devfeed.tech/tags/ai-powered.md>), [alerts](<https://devfeed.tech/tags/alerts.md>), [announcements](<https://devfeed.tech/tags/announcements.md>), [applications](<https://devfeed.tech/tags/applications.md>), [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [dev](<https://devfeed.tech/tags/dev.md>), [ignite](<https://devfeed.tech/tags/ignite.md>), [microsoft](<https://devfeed.tech/tags/microsoft.md>), [microsoft-ignite](<https://devfeed.tech/tags/microsoft-ignite.md>), [microsoft-ignite-2026](<https://devfeed.tech/tags/microsoft-ignite-2026.md>), [microsoft-sql](<https://devfeed.tech/tags/microsoft-sql.md>), [sql](<https://devfeed.tech/tags/sql.md>), [what-s-new](<https://devfeed.tech/tags/what-s-new.md>)

### AI overview

Microsoft's Ignite 2026 SQL announcements emphasize modernization to Azure SQL Database Hyperscale, local development, and database operations. Hyperscale cross-database queries are in preview to reduce rewrites for applications with database dependencies; other updates include GA fuzzy matching, regex-based masking, and AES customer-managed TDE keys, plus preview per-database managed identities. Modernize CLI assesses application and database dependencies together, while Database Hub adds estate-wide views and preview agent-assisted assessments, investigations, recommendations, and alerts. Developers can use a public-preview local Azure SQL container and a preview VS Code wizard for deployment to Azure SQL Database. The excerpt also lists updates for Managed Instance, SQL database in Fabric, SQL Server, Azure tooling, and SSMS; availability varies by feature, with many items explicitly marked preview or GA.

### Source excerpt

From Microsoft Ignite I'm here in San Francisco enjoying specialty lattes, fall-ish weather (I guess?), and all the excitement around Microsoft announcements at Ignite 2026. It's a cool energy to be surrounded by so many people at organizations that are trying to innovate with AI for the era of AI. These applications are the apps [...] The post What's new across Microsoft SQL at Microsoft Ignite 2026 appeared first on Azure SQL Dev Corner.

## Resources for the SQL AI Developer

DevFeed: [Resources for the SQL AI Developer](<https://devfeed.tech/articles/resources-for-the-sql-ai-developer-130905.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/dp-800-sql-ai-certification/>)

Author: Jerry Nixon

Published: 2026-11-11T22:48:44Z

Content type: article

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>), [Learning](<https://devfeed.tech/topics/learning.md>), [AI Chat](<https://devfeed.tech/topics/ai-chat.md>), [Bluetooth](<https://devfeed.tech/topics/bluetooth.md>), [Microsoft](<https://devfeed.tech/topics/microsoft.md>), [developer-relations](<https://devfeed.tech/topics/developer-relations.md>)

Tags: [agentic](<https://devfeed.tech/tags/agentic.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-developer](<https://devfeed.tech/tags/ai-developer.md>), [azure](<https://devfeed.tech/tags/azure.md>), [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [capabilities](<https://devfeed.tech/tags/capabilities.md>), [data-api-builder](<https://devfeed.tech/tags/data-api-builder.md>), [developer](<https://devfeed.tech/tags/developer.md>), [learn](<https://devfeed.tech/tags/learn.md>), [resources](<https://devfeed.tech/tags/resources.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-mcp-server](<https://devfeed.tech/tags/sql-mcp-server.md>), [vector-search](<https://devfeed.tech/tags/vector-search.md>), [vectors](<https://devfeed.tech/tags/vectors.md>)

### AI overview

The article frames SQL's AI capabilities around three areas: agent-assisted database estate investigation through Microsoft Fabric's Database Hub (in preview); controlled agent access to operational data through a self-hosted SQL MCP Server built on Data API builder, with configured objects and permissions; and RAG using SQL vector and hybrid search to retrieve context. DP-800 connects these skills into application development, covering database design, security, optimization, deployment, and AI workflows from model selection and chunking through embeddings, search, prompt preparation, and response processing. The learning paths also cover T-SQL, JSON, indexing, access controls, SQL Database Projects, pipelines, and Data API builder. The excerpt recommends using the official study guide and practice resources; it notes Data Days: AI @ Work runs November 2-December 15, 2026, with DP-800 preparation and community sessions.

### Source excerpt

I see three agentic stories shaping SQL's future. Here's how DP-800 connects the pieces and helps you build the skills to put SQL's AI capabilities to work. The post Resources for the SQL AI Developer appeared first on Azure SQL Dev Corner.

## How do you run a query against data the database can't read?

DevFeed: [How do you run a query against data the database can't read?](<https://devfeed.tech/articles/how-do-you-run-a-query-against-data-the-database-can-t-read-124116.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/how-do-you-run-a-query-against-data-the-database-cant-read/>)

Author: Anna Hoffman

Published: 2026-11-09T11:56:57Z

Content type: article

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Database](<https://devfeed.tech/topics/database.md>), [enterprise data protection](<https://devfeed.tech/topics/enterprise-data-protection.md>), [database-optimization](<https://devfeed.tech/topics/database-optimization.md>)

Tags: [adversary](<https://devfeed.tech/tags/adversary.md>), [aes](<https://devfeed.tech/tags/aes.md>), [application](<https://devfeed.tech/tags/application.md>), [attestation](<https://devfeed.tech/tags/attestation.md>), [azure](<https://devfeed.tech/tags/azure.md>), [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [azure-sql-database](<https://devfeed.tech/tags/azure-sql-database.md>), [b-tree](<https://devfeed.tech/tags/b-tree.md>), [b-tree-index](<https://devfeed.tech/tags/b-tree-index.md>), [benchmarking](<https://devfeed.tech/tags/benchmarking.md>), [client](<https://devfeed.tech/tags/client.md>), [client-driver](<https://devfeed.tech/tags/client-driver.md>), [confidential-computing](<https://devfeed.tech/tags/confidential-computing.md>), [encryption](<https://devfeed.tech/tags/encryption.md>), [encryption-at-rest](<https://devfeed.tech/tags/encryption-at-rest.md>), [has](<https://devfeed.tech/tags/has.md>), [hyperscale](<https://devfeed.tech/tags/hyperscale.md>), [microsoft](<https://devfeed.tech/tags/microsoft.md>), [microsoft-sql](<https://devfeed.tech/tags/microsoft-sql.md>), [query](<https://devfeed.tech/tags/query.md>), [research](<https://devfeed.tech/tags/research.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

Always Encrypted lets Azure SQL run queries over data whose keys remain outside the database server. A client driver encrypts parameters and decrypts results using a column encryption key (CEK), itself protected by a customer-controlled column master key (CMK). Deterministic encryption supports equality comparisons and ordinary B-tree indexes but leaks value frequency; randomized encryption avoids that leakage but requires secure enclaves for comparisons, ranges, BETWEEN, and LIKE. Enclaves decrypt and evaluate data in protected memory, with attestation required before clients share keys. The article says leakage remains: deterministic comparisons reveal frequency, while enclave range and indexed LIKE queries can reveal ordering and proximity. VBS enclaves are available across Azure SQL Database offerings but currently lack attestation, so they do not match the paper's stronger threat model; Intel SGX with Azure Attestation remains stronger. SQL Server 2022 added enclave JOIN, GROUP BY, and ORDER BY. The paper's 2020 TPC-C results show overhead, and the article advises benchmarking current workloads.

### Source excerpt

Under the Hood: The Research Behind Microsoft SQL, part 3 Encryption at rest solves one threat. It stops someone who walks off with the disk. It does nothing about someone with administrative access to the running server, because the database decrypts data into memory to do anything useful with it. For a lot of workloads [...] The post How do you run a query against data the database can't read? appeared first on Azure SQL Dev Corner.

## My Favorite Undocumented Feature in SQL MCP Server

DevFeed: [My Favorite Undocumented Feature in SQL MCP Server](<https://devfeed.tech/articles/my-favorite-undocumented-feature-in-sql-mcp-server-115915.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/sql-mcp-server-hidden-feature-default-configuration/>)

Author: Jerry Nixon

Published: 2026-11-03T21:29:25Z

Content type: article

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Undocumented feature](<https://devfeed.tech/topics/undocumented-feature.md>)

Tags: [aca](<https://devfeed.tech/tags/aca.md>), [aci](<https://devfeed.tech/tags/aci.md>), [agentic](<https://devfeed.tech/tags/agentic.md>), [agents](<https://devfeed.tech/tags/agents.md>), [aks](<https://devfeed.tech/tags/aks.md>), [azure](<https://devfeed.tech/tags/azure.md>), [azure-container-apps](<https://devfeed.tech/tags/azure-container-apps.md>), [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [configuration](<https://devfeed.tech/tags/configuration.md>), [container](<https://devfeed.tech/tags/container.md>), [container-apps](<https://devfeed.tech/tags/container-apps.md>), [data-api-builder](<https://devfeed.tech/tags/data-api-builder.md>), [deploy](<https://devfeed.tech/tags/deploy.md>), [deployment](<https://devfeed.tech/tags/deployment.md>), [docker](<https://devfeed.tech/tags/docker.md>), [feature](<https://devfeed.tech/tags/feature.md>), [mcp](<https://devfeed.tech/tags/mcp.md>), [mcp-server](<https://devfeed.tech/tags/mcp-server.md>), [microsoft](<https://devfeed.tech/tags/microsoft.md>), [server](<https://devfeed.tech/tags/server.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-mcp-server](<https://devfeed.tech/tags/sql-mcp-server.md>)

### AI overview

The Data API builder 2.0 container image includes a default configuration that exposes tables through `autoentities`; setting `DAB_CONNSTRING` supplies or overrides its database connection string, enabling a quick MCP proof of concept without a custom configuration file or image. The excerpt gives deployment examples for Docker, Azure Container Apps Express (in preview), regular Container Apps, ACI, and AKS. The default configuration is intended for development: it enables Swagger and Nitro, allows anonymous health endpoint access, and grants anonymous users all CRUD operations, including mutations. The author cautions against using it in production without changing those settings.

### Source excerpt

Deploy Microsoft's SQL MCP Server in minutes without a configuration file. Learn how DAB_CONNSTRING enables fast deployment using Docker, Azure Container Apps, ACI, or AKS. The post My Favorite Undocumented Feature in SQL MCP Server appeared first on Azure SQL Dev Corner.

## How Microsoft SQL learned to recover without undoing everything first

DevFeed: [How Microsoft SQL learned to recover without undoing everything first](<https://devfeed.tech/articles/how-microsoft-sql-learned-to-recover-without-undoing-everything-first-113097.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/your-server-wasnt-slow-it-was-waiting-we-fixed-it-with-constant-time-recovery/>)

Author: Anna Hoffman

Published: 2026-11-02T11:49:03Z

Content type: article

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>), [database-optimization](<https://devfeed.tech/topics/database-optimization.md>)

Tags: [2019](<https://devfeed.tech/tags/2019.md>), [2022](<https://devfeed.tech/tags/2022.md>), [2025](<https://devfeed.tech/tags/2025.md>), [algorithm](<https://devfeed.tech/tags/algorithm.md>), [analysis](<https://devfeed.tech/tags/analysis.md>), [availability](<https://devfeed.tech/tags/availability.md>), [azure](<https://devfeed.tech/tags/azure.md>), [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [azure-sql-database](<https://devfeed.tech/tags/azure-sql-database.md>), [background](<https://devfeed.tech/tags/background.md>), [benefit](<https://devfeed.tech/tags/benefit.md>), [blog](<https://devfeed.tech/tags/blog.md>), [bulk-load](<https://devfeed.tech/tags/bulk-load.md>), [cleanup](<https://devfeed.tech/tags/cleanup.md>), [hyperscale](<https://devfeed.tech/tags/hyperscale.md>), [microsoft](<https://devfeed.tech/tags/microsoft.md>), [microsoft-sql](<https://devfeed.tech/tags/microsoft-sql.md>), [recover](<https://devfeed.tech/tags/recover.md>), [research](<https://devfeed.tech/tags/research.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [sql-server-2025](<https://devfeed.tech/tags/sql-server-2025.md>), [transaction](<https://devfeed.tech/tags/transaction.md>)

### AI overview

Accelerated Database Recovery (ADR), based on Constant Time Recovery, makes rollback and crash recovery largely independent of the amount of work in an uncommitted transaction. It uses a durable Persistent Version Store (PVS) to retain row versions; logical revert marks a transaction aborted so queries skip its versions and read earlier ones, while cleanup runs in the background. Operations that cannot be versioned use a small secondary log, the SLog. The article reports that Azure SQL Database recovery at the 99.999th percentile fell from over an hour to three minutes, and a 50-million-row delete's log use fell from 38 GB to 147 MB. The tradeoff included throughput reductions of 13.8% on TPC-C with in-row versioning and 2.4% on TPC-E. ADR is always on in Azure SQL Database; in SQL Server it is available since 2019 and off by default. The excerpt also describes later version-store cleanup improvements and ADR's role as a prerequisite for optimized locking.

### Source excerpt

Under the Hood: The Research Behind Microsoft SQL, part 2 Here's a scenario that used to be genuinely frightening: you kick off a bulk load of a few hundred million rows in a single transaction. Somewhere in the middle, the server goes down. Not because of your load, just an unlucky reboot. When SQL Server [...] The post How Microsoft SQL learned to recover without undoing everything first appeared first on Azure SQL Dev Corner.

## Is Azure SQL Database Hyperscale "distributed SQL"?

DevFeed: [Is Azure SQL Database Hyperscale "distributed SQL"?](<https://devfeed.tech/articles/is-azure-sql-database-hyperscale-distributed-sql-109694.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/is-azure-sql-database-hyperscale-distributed-sql/>)

Author: Anna Hoffman

Published: 2026-10-30T16:52:56Z

Content type: article

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>), [sql-database](<https://devfeed.tech/topics/sql-database.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [consistency](<https://devfeed.tech/topics/consistency.md>), [Transactions](<https://devfeed.tech/topics/transactions.md>), [read-replica](<https://devfeed.tech/topics/read-replica.md>), [SQL](<https://devfeed.tech/topics/sql.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [ai-workloads](<https://devfeed.tech/tags/ai-workloads.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [aws](<https://devfeed.tech/tags/aws.md>), [azure](<https://devfeed.tech/tags/azure.md>), [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [azure-sql-database](<https://devfeed.tech/tags/azure-sql-database.md>), [backup](<https://devfeed.tech/tags/backup.md>), [backups](<https://devfeed.tech/tags/backups.md>), [benchmark](<https://devfeed.tech/tags/benchmark.md>), [capacity](<https://devfeed.tech/tags/capacity.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [commit](<https://devfeed.tech/tags/commit.md>), [database](<https://devfeed.tech/tags/database.md>), [distributed](<https://devfeed.tech/tags/distributed.md>), [distributed-sql](<https://devfeed.tech/tags/distributed-sql.md>), [hyperscale](<https://devfeed.tech/tags/hyperscale.md>), [sql](<https://devfeed.tech/tags/sql.md>), [t-sql](<https://devfeed.tech/tags/t-sql.md>)

### AI overview

Azure SQL Database Hyperscale is a distributed architecture with a single-writer SQL engine. Compute replicas process queries, a log service handles durability and distributes log records, page servers hold data slices, and Azure Storage keeps the long-term copy and snapshots. This design supports automatic storage growth up to 128 TB, near-instant snapshot backups, restores largely independent of database size, and replicas that can be added without copying data. It retains SQL Server transaction semantics and T-SQL compatibility, but only one primary accepts writes; workloads requiring multiple writers face a different trade-off. In a Microsoft-commissioned comparison using HammerDB TPROC-C on a 2.3 TB database, Hyperscale Premium-series at 16 vCores delivered up to 52% higher performance and up to 51% better performance per dollar than Aurora PostgreSQL I/O-Optimized, leading at each tested concurrency level. The author cautions that benchmark results may not predict an individual workload and recommends testing it.

### Source excerpt

In my last post, I broke down the Socrates paper, the research that became Azure SQL Database Hyperscale. Writing it made me want to tackle a question I think trips a lot of people up when they're choosing a database: is Azure SQL Database Hyperscale "distributed SQL"? It's a fair question. "Distributed SQL" has become [...] The post Is Azure SQL Database Hyperscale "distributed SQL"? appeared first on Azure SQL Dev Corner.

## PostgreSQL to SQL Field Notes: Operational Statistics

DevFeed: [PostgreSQL to SQL Field Notes: Operational Statistics](<https://devfeed.tech/articles/postgresql-to-sql-field-notes-operational-statistics-105871.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/pg-to-sql-statistics/>)

Author: Jerry Nixon

Published: 2026-10-28T18:47:53Z

Content type: comparison

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [SQL](<https://devfeed.tech/topics/sql.md>)

Tags: [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [azure-sql-database](<https://devfeed.tech/tags/azure-sql-database.md>), [operational](<https://devfeed.tech/tags/operational.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-server-2025](<https://devfeed.tech/tags/sql-server-2025.md>), [statistics](<https://devfeed.tech/tags/statistics.md>)

### AI overview

The article's main distinction is that both PostgreSQL and Azure SQL expose useful operational statistics, but Azure SQL has a broader set of execution and resource diagnostics built into the engine. In Azure SQL, `sys.dm_exec_requests` and `sys.dm_exec_query_statistics_xml` can show operator-level progress for a running query; `sys.dm_exec_query_plan_stats` can retrieve a cached query's last actual plan when enabled. DMVs also expose current and accumulated waits and query memory grants, while Extended Events can capture events such as deadlocks. These capabilities have limits: cached plans can be evicted, wait totals need comparison over time, and missing-index suggestions are estimates that require evaluation. PostgreSQL offers mature statistics, `EXPLAIN`, spill diagnostics, and extensions such as `auto_explain` and `pg_wait_sampling`; deeper diagnostics may require advance configuration and instrumentation. Self-managed PostgreSQL can also offer OS-level profiling access that Azure SQL Database restricts.

### Source excerpt

Welcome to SQL First, welcome to SQL! You're going to like this. I've said this before, but it's still true: moving from PostgreSQL is real work, and depending on your old database, this process will vary widely in complexity. I am confident that you're going to love the mindful and modern features of SQL. Take [...] The post PostgreSQL to SQL Field Notes: Operational Statistics appeared first on Azure SQL Dev Corner.

## The paper that split the database in four: inside Azure SQL Database Hyperscale, aka Socrates

DevFeed: [The paper that split the database in four: inside Azure SQL Database Hyperscale, aka Socrates](<https://devfeed.tech/articles/the-paper-that-split-the-database-in-four-inside-azure-sql-database-hyperscale-aka-socrates-101493.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/the-paper-that-split-the-database-in-four-inside-azure-sql-database-hyperscale-aka-socrates/>)

Author: Anna Hoffman

Published: 2026-10-25T11:23:29Z

Content type: article

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>), [transaction-log](<https://devfeed.tech/topics/transaction-log.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [read-replica](<https://devfeed.tech/topics/read-replica.md>), [database-optimization](<https://devfeed.tech/topics/database-optimization.md>), [sql-database](<https://devfeed.tech/topics/sql-database.md>), [consistency](<https://devfeed.tech/topics/consistency.md>), [Azure](<https://devfeed.tech/topics/azure.md>)

Tags: [also](<https://devfeed.tech/tags/also.md>), [azure](<https://devfeed.tech/tags/azure.md>), [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [azure-sql-database](<https://devfeed.tech/tags/azure-sql-database.md>), [brand](<https://devfeed.tech/tags/brand.md>), [but](<https://devfeed.tech/tags/but.md>), [database](<https://devfeed.tech/tags/database.md>), [engineering](<https://devfeed.tech/tags/engineering.md>), [first](<https://devfeed.tech/tags/first.md>), [hood](<https://devfeed.tech/tags/hood.md>), [hyperscale](<https://devfeed.tech/tags/hyperscale.md>), [inside](<https://devfeed.tech/tags/inside.md>), [microsoft](<https://devfeed.tech/tags/microsoft.md>), [microsoft-research](<https://devfeed.tech/tags/microsoft-research.md>), [microsoft-sql](<https://devfeed.tech/tags/microsoft-sql.md>), [paper](<https://devfeed.tech/tags/paper.md>), [partners](<https://devfeed.tech/tags/partners.md>), [split](<https://devfeed.tech/tags/split.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-database](<https://devfeed.tech/tags/sql-database.md>)

### AI overview

Azure SQL Database Hyperscale, codenamed Socrates, avoids the full-replica architecture's data-sized limits by splitting query processing, transaction logging, data pages, and durable storage across compute nodes, XLOG, page servers, and XStore. Compute nodes cache pages in memory and RBPEX; on a cache miss, GetPage@LSN asks a page server for a page current to a specified log position. XLOG distributes committed log records, while XStore snapshots support backups. This design removes full data copying when adding compute or replicas and makes backup and restore less dependent on database size. The text reports scale operations changing from O(data) to O(1), about half the storage overhead, and higher update-heavy log throughput than the full-replica design. It also cites skewed workloads where small caches served a larger share of reads. Hyperscale retains T-SQL compatibility, with tradeoffs involving remote page fetches and reliance on caching; the excerpt gives no detailed operational comparison of those effects.

### Source excerpt

Under the Hood: The Research Behind Microsoft SQL, part 1 The Microsoft SQL team is always innovating. They do this in day-to-day efforts, but there are also brand new efforts that are constantly being explored, investigated, tested, and researched. Our engineering team partners closely with MSR (Microsoft Research) on some of these efforts. The team [...] The post The paper that split the database in four: inside Azure SQL Database Hyperscale, aka Socrates appeared first on Azure SQL Dev Corner.

## Canada's 2026 time zone updates: guidance for Microsoft SQL

DevFeed: [Canada's 2026 time zone updates: guidance for Microsoft SQL](<https://devfeed.tech/articles/canada-s-2026-time-zone-updates-guidance-for-microsoft-sql-87322.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/canadas-2026-time-zone-updates-guidance-for-microsoft-sql/>)

Author: Umachandar Jayachandran (UC)

Published: 2026-10-15T05:21:10Z

Content type: tutorial

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [timezone](<https://devfeed.tech/topics/timezone.md>), [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [azure-sql-database](<https://devfeed.tech/tags/azure-sql-database.md>), [azure-sql-managed-instance](<https://devfeed.tech/tags/azure-sql-managed-instance.md>), [canada](<https://devfeed.tech/tags/canada.md>), [fabric-sql](<https://devfeed.tech/tags/fabric-sql.md>), [fabric-sql-database](<https://devfeed.tech/tags/fabric-sql-database.md>), [managed-instance](<https://devfeed.tech/tags/managed-instance.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [t-sql](<https://devfeed.tech/tags/t-sql.md>), [time](<https://devfeed.tech/tags/time.md>)

### AI overview

Microsoft outlines interim time zone guidance for SQL Server on Windows and Linux, Azure SQL Database, and Azure SQL Managed Instance ahead of Canada's November 2026 changes. It explains regional offsets, temporary identifiers and workarounds, configuration scope, and migration considerations when final regional zones are unavailable.

### Source excerpt

Affected locations in British Columbia, Alberta, and Manitoba will not turn their clocks back at 02:00 local time on November 1, 2026. They will remain at UTC−07:00, UTC−06:00, and UTC−05:00, respectively. Microsoft's interim guidance for British Columbia, Alberta, and Manitoba describes the new Windows time zones and temporary workarounds. SQL Server on Windows requires the [...] The post Canada's 2026 time zone updates: guidance for Microsoft SQL appeared first on Azure SQL Dev Corner.

## Try SqlClient's new connection pool for faster parallel connections

DevFeed: [Try SqlClient's new connection pool for faster parallel connections](<https://devfeed.tech/articles/try-sqlclient-s-new-connection-pool-for-faster-parallel-connections-66412.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/try-sqlclients-new-connection-pool-for-faster-parallel-connections/>)

Author: Malcolm Daigle

Published: 2026-10-06T22:42:12Z

Content type: article

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [connection pool](<https://devfeed.tech/topics/connection-pool.md>), [Latency](<https://devfeed.tech/topics/latency.md>), [Python Driver for Azure SQL](<https://devfeed.tech/topics/python-driver-for-azure-sql.md>)

Tags: [2025](<https://devfeed.tech/tags/2025.md>), [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [concurrency](<https://devfeed.tech/tags/concurrency.md>), [drivers](<https://devfeed.tech/tags/drivers.md>), [net](<https://devfeed.tech/tags/net.md>), [net-9](<https://devfeed.tech/tags/net-9.md>), [sqlclient](<https://devfeed.tech/tags/sqlclient.md>)

### AI overview

Microsoft.Data.SqlClient 7.1.0 introduces an optional connection pool that opens connections concurrently. In cold-start benchmarks with 100 concurrent callers on Linux, it reduced mean completion time from 630.1 ms to 117.5 ms for synchronous opens and from 604.1 ms to 92.0 ms for asynchronous opens. The article cautions that asynchronous opens still use managed thread-pool threads for synchronous network calls, which can create pressure on high-latency connections.

### Source excerpt

You told us that applications using Microsoft.Data.SqlClient can take too long to establish the database connections they need. When many requests need connections at the same time, waiting for the connection pool to grow can delay application readiness and increase latency. This can happen even in common situations like querying several pieces of metadata during [...] The post Try SqlClient's new connection pool for faster parallel connections appeared first on Azure SQL Dev Corner.

## Upcoming SQL and AI Events to Put on Your Calendar

DevFeed: [Upcoming SQL and AI Events to Put on Your Calendar](<https://devfeed.tech/articles/upcoming-sql-and-ai-events-to-put-on-your-calendar-66411.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/sql-calendar-2027q4/>)

Author: Jerry Nixon

Published: 2026-10-06T20:50:48Z

Content type: article

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [Developer Events](<https://devfeed.tech/topics/developer-events.md>), [sql-database](<https://devfeed.tech/topics/sql-database.md>), [Artificial Intelligence](<https://devfeed.tech/topics/ai.md>), [AI Chat](<https://devfeed.tech/topics/ai-chat.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [ai-integration](<https://devfeed.tech/tags/ai-integration.md>), [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [azure-sql-database](<https://devfeed.tech/tags/azure-sql-database.md>), [developers](<https://devfeed.tech/tags/developers.md>), [events](<https://devfeed.tech/tags/events.md>), [sql](<https://devfeed.tech/tags/sql.md>), [workshop](<https://devfeed.tech/tags/workshop.md>)

### AI overview

The article lists SQL and AI events for developers, data professionals, and technology decision makers in fall 2027. It highlights a full-day workshop on building AI-powered applications with SQL, including vector search, retrieval-augmented generation, and existing security and governance controls.

### Source excerpt

Developers, database administrators, data professionals, architects and technology decision makers have several opportunities to connect, learn and gain hands-on experience this fall. 2027 Q4 SQL Events Date Event City & region Registration Fri, Oct 16, 2026 💻 SQL AI App in a Day workshop Sanford, Florida Workshop Sat, Oct 17, 2026 🤝 Orlando's 19th Annual [...] The post Upcoming SQL and AI Events to Put on Your Calendar appeared first on Azure SQL Dev Corner.

## PostgreSQL to SQL Field Notes: Connections

DevFeed: [PostgreSQL to SQL Field Notes: Connections](<https://devfeed.tech/articles/postgresql-to-sql-field-notes-connections-65477.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/pg-to-sql-connections/>)

Author: Jerry Nixon

Published: 2026-10-06T16:39:17Z

Content type: article

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [connection pool](<https://devfeed.tech/topics/connection-pool.md>), [connection draining](<https://devfeed.tech/topics/connection-draining.md>), [locking](<https://devfeed.tech/topics/locking.md>)

Tags: [antipattern](<https://devfeed.tech/tags/antipattern.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [c-sharp](<https://devfeed.tech/tags/c-sharp.md>), [concurrent](<https://devfeed.tech/tags/concurrent.md>), [connect](<https://devfeed.tech/tags/connect.md>), [connection-pool](<https://devfeed.tech/tags/connection-pool.md>), [connection-pooling](<https://devfeed.tech/tags/connection-pooling.md>), [cost](<https://devfeed.tech/tags/cost.md>), [database](<https://devfeed.tech/tags/database.md>), [microsoft-sql](<https://devfeed.tech/tags/microsoft-sql.md>), [modernize](<https://devfeed.tech/tags/modernize.md>), [net](<https://devfeed.tech/tags/net.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-server-2025](<https://devfeed.tech/tags/sql-server-2025.md>), [t-sql](<https://devfeed.tech/tags/t-sql.md>)

### AI overview

The article compares PostgreSQL and Microsoft SQL connection models. PostgreSQL assigns a dedicated operating-system process to each connection, so developers commonly limit concurrent connections and manage pooling. Microsoft SQL uses workers on demand and typically relies on ADO.NET connection pooling, making idle connections less resource intensive. The article recommends letting the database and client pool manage most connection scenarios.

### Source excerpt

Welcome to SQL First, welcome to SQL! You're going to like this. Upgrading from PostgreSQL is real work, and depending on your old database, this process will vary widely in complexity. I am confident that you're going to love the mindful and modern features of SQL. Take your time, make the most of the resources [...] The post PostgreSQL to SQL Field Notes: Connections appeared first on Azure SQL Dev Corner.

## Data API builder 2.1.5: JSON and Vector Data Type Support, and More

DevFeed: [Data API builder 2.1.5: JSON and Vector Data Type Support, and More](<https://devfeed.tech/articles/data-api-builder-2-1-5-json-and-vector-data-type-support-and-more-63631.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/data-api-builder-2-1-5-json-and-vector-data-type-support-and-more/>)

Author: Carlos Robles, Aniruddh Munde, Matt Hyon

Published: 2026-10-02T01:10:52Z

Content type: release

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [API](<https://devfeed.tech/topics/api.md>), [JSON](<https://devfeed.tech/topics/json.md>), [vector embeddings in AI](<https://devfeed.tech/topics/vector-embeddings-in-ai.md>), [Cryptography](<https://devfeed.tech/topics/cryptography.md>), [REST API](<https://devfeed.tech/topics/rest-api.md>)

Tags: [agent](<https://devfeed.tech/tags/agent.md>), [api](<https://devfeed.tech/tags/api.md>), [authorization](<https://devfeed.tech/tags/authorization.md>), [azure](<https://devfeed.tech/tags/azure.md>), [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [azure-sql-database](<https://devfeed.tech/tags/azure-sql-database.md>), [dab](<https://devfeed.tech/tags/dab.md>), [data-api-builder](<https://devfeed.tech/tags/data-api-builder.md>), [graphql](<https://devfeed.tech/tags/graphql.md>), [json](<https://devfeed.tech/tags/json.md>), [net](<https://devfeed.tech/tags/net.md>), [net-10](<https://devfeed.tech/tags/net-10.md>), [release](<https://devfeed.tech/tags/release.md>), [rest](<https://devfeed.tech/tags/rest.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-json](<https://devfeed.tech/tags/sql-json.md>), [vector](<https://devfeed.tech/tags/vector.md>), [vs-code](<https://devfeed.tech/tags/vs-code.md>), [vscode-mssql](<https://devfeed.tech/tags/vscode-mssql.md>)

### AI overview

Data API builder 2.1.5 adds REST and GraphQL support for SQL Server `json` and `vector` columns, and introduces an embeddable .NET NuGet library. The release also hardens its MCP endpoint with origin controls and permission checks, updates the engine to .NET 10, and includes security, reliability, and platform improvements.

### Source excerpt

Data API builder (DAB) 2.1.5 is now available as a stable release, and it is about meeting modern data where it lives: documents next to rows, embeddings next to both. This release brings native support for the SQL json and vector data types to the REST and GraphQL endpoints, so the same entities that serve [...] The post Data API builder 2.1.5: JSON and Vector Data Type Support, and More appeared first on Azure SQL Dev Corner.

## DiskANN Vector Index and Vector Search Are Now Generally Available in Azure SQL

DevFeed: [DiskANN Vector Index and Vector Search Are Now Generally Available in Azure SQL](<https://devfeed.tech/articles/diskann-vector-index-and-vector-search-are-now-generally-available-in-azure-sql-61741.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/diskann-vector-index-search-are-now-generally-available-in-azure-sql/>)

Author: Pooja Kamath

Published: 2026-09-29T15:00:22Z

Content type: release

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>), [sql-database](<https://devfeed.tech/topics/sql-database.md>), [cosine similarity search](<https://devfeed.tech/topics/cosine-similarity-search.md>), [ann](<https://devfeed.tech/topics/ann.md>), [vectorization techniques](<https://devfeed.tech/topics/vectorization-techniques.md>), [SQL](<https://devfeed.tech/topics/sql.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [approximate-nearest-neighbor-search](<https://devfeed.tech/tags/approximate-nearest-neighbor-search.md>), [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [azure-sql-database](<https://devfeed.tech/tags/azure-sql-database.md>), [diskann](<https://devfeed.tech/tags/diskann.md>), [embeddings](<https://devfeed.tech/tags/embeddings.md>), [fabric-sql-database](<https://devfeed.tech/tags/fabric-sql-database.md>), [hyperscale](<https://devfeed.tech/tags/hyperscale.md>), [similarity](<https://devfeed.tech/tags/similarity.md>), [sql](<https://devfeed.tech/tags/sql.md>), [t-sql](<https://devfeed.tech/tags/t-sql.md>), [vector-index](<https://devfeed.tech/tags/vector-index.md>), [vector-search](<https://devfeed.tech/tags/vector-search.md>), [vectors](<https://devfeed.tech/tags/vectors.md>)

### AI overview

DiskANN vector indexing and search are now generally available in Azure SQL Database, Azure SQL Managed Instance with the always-up-to-date update policy, and SQL database in Microsoft Fabric. The index uses approximate nearest-neighbor search to find similar vectors efficiently as datasets grow, and can use SSD-backed storage to limit reliance on RAM. Applications can combine vector similarity search with relational data, filters, joins, security policies, and transactions.

### Source excerpt

Today, we are announcing the general availability of DiskANN Vector Index & Search across Azure SQL Database, Azure SQL Managed Instance with the always-up-to-date update policy, and SQL database in Microsoft Fabric. DiskANN brings scalable approximate nearest-neighbor search directly to the SQL engine. Developers can store vectors alongside relational data and combine vector similarity with [...] The post DiskANN Vector Index and Vector Search Are Now Generally Available in Azure SQL appeared first on Azure SQL Dev Corner.

## What's new across Microsoft SQL at SQLCon/FabCon Europe 2026

DevFeed: [What's new across Microsoft SQL at SQLCon/FabCon Europe 2026](<https://devfeed.tech/articles/what-s-new-across-microsoft-sql-at-sqlcon-fabcon-europe-2026-61742.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/whats-new-across-microsoft-sql-at-sqlcon-fabcon-europe-2026/>)

Author: Anna Hoffman

Published: 2026-09-29T07:30:04Z

Content type: news

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>), [Azure](<https://devfeed.tech/topics/azure.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [ai](<https://devfeed.tech/tags/ai.md>), [azure](<https://devfeed.tech/tags/azure.md>), [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [data-api-builder](<https://devfeed.tech/tags/data-api-builder.md>), [drivers](<https://devfeed.tech/tags/drivers.md>), [fabric-sql-database](<https://devfeed.tech/tags/fabric-sql-database.md>), [hyperscale](<https://devfeed.tech/tags/hyperscale.md>), [microsoft](<https://devfeed.tech/tags/microsoft.md>), [microsoft-sql](<https://devfeed.tech/tags/microsoft-sql.md>), [sql-database-in-fabric](<https://devfeed.tech/tags/sql-database-in-fabric.md>), [sql-database-projects](<https://devfeed.tech/tags/sql-database-projects.md>), [sql-mcp-server](<https://devfeed.tech/tags/sql-mcp-server.md>), [sql-server-2025](<https://devfeed.tech/tags/sql-server-2025.md>), [t-sql](<https://devfeed.tech/tags/t-sql.md>), [vector-search](<https://devfeed.tech/tags/vector-search.md>), [vectors](<https://devfeed.tech/tags/vectors.md>), [visual-studio-code](<https://devfeed.tech/tags/visual-studio-code.md>), [vs-code](<https://devfeed.tech/tags/vs-code.md>)

### AI overview

Microsoft highlights SQL Server and Azure SQL updates announced at SQLCon and FabCon Europe 2026, including disconnected Azure Local availability, expanded Azure Arc regions, sovereign cloud support, VM provisioning changes, Linux updates, and preview migration tools.

### Source excerpt

Live From Barcelona Woo! I'm posting this live from the first ever European SQLCon (joint conference with FabCon EU), and the second ever SQLCon. The energy here is great, as the community comes together in Barcelona and as we prepare to go on the keynote stage and share what's new! A heartfelt nod to the [...] The post What's new across Microsoft SQL at SQLCon/FabCon Europe 2026 appeared first on Azure SQL Dev Corner.

## How to build an app on Azure SQL with an AI coding agent

DevFeed: [How to build an app on Azure SQL with an AI coding agent](<https://devfeed.tech/articles/how-to-build-an-app-on-azure-sql-with-an-ai-coding-agent-61740.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/build-app-azure-sql-ai-coding-agent/>)

Author: Iqra Shaikh

Published: 2026-09-29T07:05:16Z

Content type: tutorial

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>), [Agent Skills](<https://devfeed.tech/topics/agent-skills.md>), [GitHub Copilot](<https://devfeed.tech/topics/github-copilot.md>)

Tags: [agent](<https://devfeed.tech/tags/agent.md>), [agent-skills](<https://devfeed.tech/tags/agent-skills.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-coding-agent](<https://devfeed.tech/tags/ai-coding-agent.md>), [azure](<https://devfeed.tech/tags/azure.md>), [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [azure-sql-database](<https://devfeed.tech/tags/azure-sql-database.md>), [azuresql](<https://devfeed.tech/tags/azuresql.md>), [developers](<https://devfeed.tech/tags/developers.md>), [github-copilot](<https://devfeed.tech/tags/github-copilot.md>), [node-js](<https://devfeed.tech/tags/node-js.md>), [python](<https://devfeed.tech/tags/python.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-mcp-server](<https://devfeed.tech/tags/sql-mcp-server.md>), [vs-code](<https://devfeed.tech/tags/vs-code.md>)

### AI overview

Microsoft introduces open-source SQL Agent Skills and the Azure SQL Developer Hub, which provide coding agents with Azure SQL guidance, a free database, and prompts for building applications. The tutorial demonstrates creating a task-tracking app and describes setup requirements and checks.

### Source excerpt

Developers have trusted SQL for decades, since long before AI existed. Now coding agents help choose the database, and they favor the one they can get running in the first few minutes. So today we're shipping two things for that moment. Microsoft SQL Agent Skills teach your coding agent how Azure SQL actually works, so [...] The post How to build an app on Azure SQL with an AI coding agent appeared first on Azure SQL Dev Corner.

## MSSQL Extension for VS Code: New Getting Started Page, Agent skills, SQL Formatter, and more

DevFeed: [MSSQL Extension for VS Code: New Getting Started Page, Agent skills, SQL Formatter, and more](<https://devfeed.tech/articles/mssql-extension-for-vs-code-new-getting-started-page-agent-skills-sql-formatter-and-more-61033.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/vscode-mssql-september2026/>)

Author: Yo-Lei Chen

Published: 2026-09-28T17:27:53Z

Content type: release

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [AI for SQL query generation](<https://devfeed.tech/topics/ai-for-sql-query-generation.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Visual Studio Code](<https://devfeed.tech/topics/visual-studio-code.md>), [GitHub Copilot](<https://devfeed.tech/topics/github-copilot.md>), [Microsoft](<https://devfeed.tech/topics/microsoft.md>)

Tags: [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [copilot](<https://devfeed.tech/tags/copilot.md>), [data-api-builder](<https://devfeed.tech/tags/data-api-builder.md>), [features](<https://devfeed.tech/tags/features.md>), [github-copilot](<https://devfeed.tech/tags/github-copilot.md>), [release](<https://devfeed.tech/tags/release.md>), [templates](<https://devfeed.tech/tags/templates.md>), [visual-studio-code](<https://devfeed.tech/tags/visual-studio-code.md>), [vs-code](<https://devfeed.tech/tags/vs-code.md>), [vscode-mssql](<https://devfeed.tech/tags/vscode-mssql.md>)

### AI overview

The MSSQL extension for VS Code v1.46 adds a Getting Started experience in public preview with quick actions, guided workflows, development container templates, and installation of Microsoft SQL agent skills for GitHub Copilot. The release also makes the SQL Formatter generally available with additional T-SQL style controls, adds reusable Object Explorer filters, and expands Data API builder support for database objects and data types with more granular permissions.

### Source excerpt

Get started faster with common SQL workflows and resources in one place. The MSSQL extension for VS Code v1.46 introduces a new Getting Started page experience in Public Preview with quick actions, guided walkthroughs, dev container templates, and one-click installation of the latest Microsoft SQL agent skills for GitHub Copilot. Available to all customers starting with this release, the [...] The post MSSQL Extension for VS Code: New Getting Started Page, Agent skills, SQL Formatter, and more appeared first on Azure SQL Dev Corner.

## SQLAlchemy 2.1 brings built-in support for mssql-python

DevFeed: [SQLAlchemy 2.1 brings built-in support for mssql-python](<https://devfeed.tech/articles/sqlalchemy-2-1-brings-built-in-support-for-mssql-python-61032.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/sqlalchemy-2-1-brings-built-in-support-for-mssql-python/>)

Author: Matt Hyon, David Levy

Published: 2026-09-28T16:02:00Z

Content type: release

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [SQLAlchemy](<https://devfeed.tech/topics/sqlalchemy.md>), [Python Driver for SQL Server](<https://devfeed.tech/topics/python-driver-for-sql-server.md>), [Python Driver for Azure SQL](<https://devfeed.tech/topics/python-driver-for-azure-sql.md>)

Tags: [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [drivers](<https://devfeed.tech/tags/drivers.md>), [python](<https://devfeed.tech/tags/python.md>), [python-driver-for-sql-server](<https://devfeed.tech/tags/python-driver-for-sql-server.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [sql-server-2025](<https://devfeed.tech/tags/sql-server-2025.md>), [sqlalchemy](<https://devfeed.tech/tags/sqlalchemy.md>)

### AI overview

SQLAlchemy 2.1 is generally available with a built-in first-party dialect for Microsoft's mssql-python driver. It supports SQL Server and Azure SQL through SQLAlchemy's ORM and Core APIs, with simpler driver setup, Microsoft Entra authentication options, and continued use of Alembic for schema migrations.

### Source excerpt

We're pleased to share that SQLAlchemy 2.1.0 is now generally available, with built-in support for mssql-python, Microsoft's Python driver for SQL Server. You can now use it with SQLAlchemy's ORM and Core APIs through the first-party mssql+mssqlpython dialect. If SQLAlchemy is already part of how you build, we want this to feel like a natural [...] The post SQLAlchemy 2.1 brings built-in support for mssql-python appeared first on Azure SQL Dev Corner.

## Announcing the Public Preview of Local Time Zone Support in Azure SQL Database

DevFeed: [Announcing the Public Preview of Local Time Zone Support in Azure SQL Database](<https://devfeed.tech/articles/announcing-the-public-preview-of-local-time-zone-support-in-azure-sql-database-61031.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/announcing-the-public-preview-of-local-time-zone-support-in-azure-sql-database/>)

Author: Umachandar Jayachandran (UC)

Published: 2026-09-28T15:00:17Z

Content type: release

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [timezone](<https://devfeed.tech/topics/timezone.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [Oracle Database](<https://devfeed.tech/topics/oracle-database.md>)

Tags: [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [azure-sql-database](<https://devfeed.tech/tags/azure-sql-database.md>), [database](<https://devfeed.tech/tags/database.md>), [sql](<https://devfeed.tech/tags/sql.md>), [t-sql](<https://devfeed.tech/tags/t-sql.md>), [time](<https://devfeed.tech/tags/time.md>)

### AI overview

Azure SQL Database now offers a public preview of configurable time zones at the database or session level using T-SQL. The database setting persists across connections and can be changed after creation; a session setting overrides it for one connection. Secondary replica databases inherit the primary replica's setting.

### Source excerpt

We are thrilled to announce the public preview of local time zone support in Azure SQL Database. Starting today, you can configure the time zone directly at the database or session level -- all from T-SQL, without changing any infrastructure settings. This feature addresses one of the most consistently requested capabilities from the Azure SQL [...] The post Announcing the Public Preview of Local Time Zone Support in Azure SQL Database appeared first on Azure SQL Dev Corner.

## PostgreSQL to SQL Field Notes: Date & Time

DevFeed: [PostgreSQL to SQL Field Notes: Date & Time](<https://devfeed.tech/articles/postgresql-to-sql-field-notes-date-time-57680.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/pg-to-sql-date-time/>)

Author: Jerry Nixon

Published: 2026-09-21T22:44:58Z

Content type: tutorial

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [DateTime](<https://devfeed.tech/topics/datetime.md>), [SQL](<https://devfeed.tech/topics/sql.md>)

Tags: [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [dev](<https://devfeed.tech/tags/dev.md>), [developer](<https://devfeed.tech/tags/developer.md>), [microsoft-sql](<https://devfeed.tech/tags/microsoft-sql.md>), [modernize](<https://devfeed.tech/tags/modernize.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [precision](<https://devfeed.tech/tags/precision.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [sql-server-2025](<https://devfeed.tech/tags/sql-server-2025.md>), [t-sql](<https://devfeed.tech/tags/t-sql.md>), [time](<https://devfeed.tech/tags/time.md>)

### AI overview

This tutorial explains date and time differences developers should understand when moving from PostgreSQL to SQL Server, including timestamp types, time-zone handling, offsets, fractional-second precision, and storage behavior.

### Source excerpt

Moving from PostgreSQL to SQL Server? Learn the key differences between timestamp, timestamptz, datetime2, and datetimeoffset, including precision, time zones, offsets, and storage. The post PostgreSQL to SQL Field Notes: Date & Time appeared first on Azure SQL Dev Corner.

## Coding agents are picking Azure SQL Database

DevFeed: [Coding agents are picking Azure SQL Database](<https://devfeed.tech/articles/coding-agents-are-picking-azure-sql-database-50572.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/coding-agents-are-picking-azure-sql-database/>)

Author: Anna Hoffman

Published: 2026-09-15T12:55:05Z

Content type: opinion

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>), [AI-assisted coding](<https://devfeed.tech/topics/ai-assisted-coding.md>), [Benchmark](<https://devfeed.tech/topics/benchmark.md>), [Code](<https://devfeed.tech/topics/code.md>), [Claude Code](<https://devfeed.tech/topics/claude-code.md>), [codex](<https://devfeed.tech/topics/codex.md>), [cursor](<https://devfeed.tech/topics/cursor.md>)

Tags: [agents](<https://devfeed.tech/tags/agents.md>), [ai](<https://devfeed.tech/tags/ai.md>), [api](<https://devfeed.tech/tags/api.md>), [auditability](<https://devfeed.tech/tags/auditability.md>), [azure-openai](<https://devfeed.tech/tags/azure-openai.md>), [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [benchmark](<https://devfeed.tech/tags/benchmark.md>), [bicep](<https://devfeed.tech/tags/bicep.md>), [claude-code](<https://devfeed.tech/tags/claude-code.md>), [code](<https://devfeed.tech/tags/code.md>), [codex](<https://devfeed.tech/tags/codex.md>), [coding](<https://devfeed.tech/tags/coding.md>), [coding-agents](<https://devfeed.tech/tags/coding-agents.md>), [cursor](<https://devfeed.tech/tags/cursor.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [github-copilot](<https://devfeed.tech/tags/github-copilot.md>), [microsoft-sql](<https://devfeed.tech/tags/microsoft-sql.md>)

### AI overview

The article examines a benchmark in which coding agents selected databases for realistic repositories and then implemented solutions. Azure SQL Database ranked second overall, with all of its wins coming from senior-engineer scenarios involving requirements such as relational integrity, temporal auditing, and Azure integration.

### Source excerpt

I went looking for Azure SQL Database in a recent coding agent benchmark, honestly unsure whether Microsoft SQL would show up. Armature ran a study where real coding agent CLIs (Claude Code, Codex, Cursor) were dropped into six synthetic-but-realistic repositories and asked to pick a database, then actually build with it. 356 runs were completed across [...] The post Coding agents are picking Azure SQL Database appeared first on Azure SQL Dev Corner.

[Next page](<https://devfeed.tech/sources/azure-sql-dev-corner.md?cursor=WyIyMDI2LTA5LTE1VDEyOjU1OjA1KzAwOjAwIiwgIjI2NzIzYThiLTc1YzEtNDBlNy1hOWI3LTVjNDEyMzI1ZjAyMCJd>)