# Azure SQL

Azure SQL is a family of managed, secure, and intelligent products using the SQL Server database engine in the Azure cloud.

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.

## Stop repeating yourself: integrate Azure Managed Redis with your databases

DevFeed: [Stop repeating yourself: integrate Azure Managed Redis with your databases](<https://devfeed.tech/articles/stop-repeating-yourself-integrate-azure-managed-redis-with-your-databases-140336.md>)

Original publisher: [Read original article](<https://redis.io/blog/stop-repeating-yourself-integrate-azure-managed-redis-with-your-databases/>)

Author: Purna Mehta, Rakhi Thejraj

Published: 2026-11-17T00:00:00Z

Content type: article

Language: en

Sources: [Redis Blog](<https://devfeed.tech/sources/redis-blog.md>), [Redis Blog](<https://devfeed.tech/sources/redis-blog-2.md>)

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

Tags: [architecture](<https://devfeed.tech/tags/architecture.md>), [authentication](<https://devfeed.tech/tags/authentication.md>), [azd](<https://devfeed.tech/tags/azd.md>), [azure](<https://devfeed.tech/tags/azure.md>), [cache](<https://devfeed.tech/tags/cache.md>), [caching](<https://devfeed.tech/tags/caching.md>), [code](<https://devfeed.tech/tags/code.md>), [databases](<https://devfeed.tech/tags/databases.md>), [deploy](<https://devfeed.tech/tags/deploy.md>), [deployment](<https://devfeed.tech/tags/deployment.md>), [developer](<https://devfeed.tech/tags/developer.md>), [engineering-ai](<https://devfeed.tech/tags/engineering-ai.md>), [integrate](<https://devfeed.tech/tags/integrate.md>), [redis](<https://devfeed.tech/tags/redis.md>)

### AI overview

Azure Managed Redis can serve frequently read, slowly changing data from memory, reducing repeated database work and improving latency during traffic spikes. The database remains the source of truth; applications choose what to cache and how long, and should fall back to the database if the cache is unavailable. The article describes samples for PostgreSQL, Azure SQL Database, and Azure Cosmos DB, with database-specific savings: CPU, workers, and IOPS for PostgreSQL and SQL, or Request Units for Cosmos DB. The samples cover seven of eight patterns; multi-region caching is omitted because they deploy to one region. They use Microsoft Entra ID and managed identity rather than access keys, while architecture guides add private networking. Guidance includes setting TTLs to acceptable staleness with jitter, co-locating services, tracking cache and database metrics, and removing billable resources with `azd down --purge --force` when finished.

### Source excerpt

It's 9:00 AM on the first day of a big sale. Within seconds, thousands of shoppers open the same 50 product pages on your online store. Every page view runs the same joins, the same price lookups, and the same "only 3 left" inventory check. Your datab...

## 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.

## Migrating Azure SQL Database to Nutanix Database Service with a Planned Cutover Window

DevFeed: [Migrating Azure SQL Database to Nutanix Database Service with a Planned Cutover Window](<https://devfeed.tech/articles/migrating-azure-sql-database-to-nutanix-database-service-with-a-planned-cutover-window-133356.md>)

Original publisher: [Read original article](<https://www.nutanix.com/blog/migrating-azure-sql-database-to-nutanix-database-service>)

Author: Rita Ladda; SaravanaKumar Dhamodaran

Published: 2026-11-12T08:39:36Z

Content type: tutorial

Language: en

Sources: [Nutanix](<https://devfeed.tech/sources/nutanix.md>)

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

Tags: [architecture](<https://devfeed.tech/tags/architecture.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>), [best-practices](<https://devfeed.tech/tags/best-practices.md>), [blog-category](<https://devfeed.tech/tags/blog-category.md>), [change-detection](<https://devfeed.tech/tags/change-detection.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [cloud-database](<https://devfeed.tech/tags/cloud-database.md>), [data-integrity](<https://devfeed.tech/tags/data-integrity.md>), [data-portability](<https://devfeed.tech/tags/data-portability.md>), [database](<https://devfeed.tech/tags/database.md>), [factory](<https://devfeed.tech/tags/factory.md>), [migrate](<https://devfeed.tech/tags/migrate.md>), [mof-interest](<https://devfeed.tech/tags/mof-interest.md>), [nutanix](<https://devfeed.tech/tags/nutanix.md>), [nutanix-database-service-ndb](<https://devfeed.tech/tags/nutanix-database-service-ndb.md>), [private-cloud](<https://devfeed.tech/tags/private-cloud.md>), [service](<https://devfeed.tech/tags/service.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [sync](<https://devfeed.tech/tags/sync.md>), [vmware-alternative-broadcom-compete](<https://devfeed.tech/tags/vmware-alternative-broadcom-compete.md>), [window](<https://devfeed.tech/tags/window.md>)

### AI overview

The excerpt describes migrating Azure SQL Database to SQL Server managed through Nutanix Database Service (NDB) with a planned outage. Azure SQL Data Sync supports one-way synchronization from an Azure hub to an NDB member and is suited to databases whose tables have primary keys. For larger volumes or complex schemas without uniform primary keys, Azure Data Factory (ADF) can use a self-hosted integration runtime and a documented change-detection strategy; the design must handle inserts, updates, deletes, retries, and persisted watermarks. Once replication closes the delta gap, pause inbound application transactions, run a final sync, validate data on the target, update connection strings, and restore traffic. The actual downtime depends on remaining changes, transaction rate, network capacity, sync latency, and pipeline performance, so the excerpt recommends measuring it in rehearsal. It presents NDB as a managed target but does not include the promised prerequisite details or verification commands.

### Source excerpt

Migrate Azure SQL Database to SQL Server on Nutanix Database Service (NDB) using Azure SQL Data Sync or Azure Data Factory, with a planned cutover and data-integrity checks.

## 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.

## SQL Server 2016 end of support: how to choose your upgrade path

DevFeed: [SQL Server 2016 end of support: how to choose your upgrade path](<https://devfeed.tech/articles/sql-server-2016-end-of-support-how-to-choose-your-upgrade-path-97511.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/cloud/sql-server-2016-end-of-support-upgrade-options/>)

Author: Greg Low

Published: 2026-10-23T12:00:00Z

Content type: article

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

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

Tags: [2016](<https://devfeed.tech/tags/2016.md>), [2022](<https://devfeed.tech/tags/2022.md>), [2025](<https://devfeed.tech/tags/2025.md>), [azure](<https://devfeed.tech/tags/azure.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [compare](<https://devfeed.tech/tags/compare.md>), [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [databases](<https://devfeed.tech/tags/databases.md>), [end-of-support](<https://devfeed.tech/tags/end-of-support.md>), [featured](<https://devfeed.tech/tags/featured.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [support](<https://devfeed.tech/tags/support.md>), [upgrade](<https://devfeed.tech/tags/upgrade.md>)

### AI overview

SQL Server 2016 reached the end of extended support in July 2026. The article generally recommends a side-by-side migration to SQL Server 2025 for production systems, subject to application vendor certification, OS requirements, and feature compatibility. SQL Server 2025 has support through January 2036, three years beyond SQL Server 2022; 2022 may suit systems that depend on removed components such as MDS or DQS, or lack 2025 certification. Side-by-side migrations allow independent building and testing, and log shipping is recommended for large databases. In-place upgrades are simpler but require downtime and can make rollback difficult; a direct in-place path to 2025 is supported from SQL Server 2016 SP3 if edition and OS requirements are met. ESUs offer critical security updates through July 2029 at additional cost, without new features or routine bug fixes. The article also compares Azure options and advises checking full costs, testing compatibility, preserving the current compatibility level initially, validating backups, rehearsing cutover, and planning rollback because database upgrades are usually one-way.

### Source excerpt

SQL Server 2016 support has ended. Compare SQL Server 2022 vs 2025, in-place vs side-by-side upgrades, Azure and ESUs, with a pre-upgrade checklist.... The post SQL Server 2016 end of support: how to choose your upgrade path appeared first on Simple Talk.

## AI Agents: Meet the Azure Cosmos DB vNext Emulator

DevFeed: [AI Agents: Meet the Azure Cosmos DB vNext Emulator](<https://devfeed.tech/articles/ai-agents-meet-the-azure-cosmos-db-vnext-emulator-87726.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/cosmosdb/ai-agents-meet-the-azure-cosmos-db-vnext-emulator/>)

Author: Theo van Kraay

Published: 2026-10-15T13:38:16Z

Content type: article

Language: en

Sources: [Azure Cosmos DB Blog](<https://devfeed.tech/sources/azure-cosmos-db-blog.md>)

Topics: [Loop Engineering](<https://devfeed.tech/topics/loop-engineering.md>), [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>), [Test automation](<https://devfeed.tech/topics/test-automation.md>)

Tags: [agents](<https://devfeed.tech/tags/agents.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-agents](<https://devfeed.tech/tags/ai-agents.md>), [azure-cosmos-db](<https://devfeed.tech/tags/azure-cosmos-db.md>), [azure-cosmos-db-tools](<https://devfeed.tech/tags/azure-cosmos-db-tools.md>), [container](<https://devfeed.tech/tags/container.md>), [database](<https://devfeed.tech/tags/database.md>), [emulator](<https://devfeed.tech/tags/emulator.md>)

### AI overview

The article describes how the Azure Cosmos DB vNext emulator supports coding-agent workflows, including portable database setup, fixture creation, diagnostics, protocol testing, and retrieval testing. It notes that the emulator runs in Linux containers across Windows, macOS, and Linux hosts, and that it does not reproduce every cloud capability. It also explains how to run and compare the emulator in integration tests, while warning that authentication is not enforced and local testing does not replace Azure validation.

### Source excerpt

Over a typical 2 day window, we record 10 times as many emulator sessions lasting more than 30 minutes for vNext as for the legacy emulator. Our bet is that agentic development is helping drive the difference! The appeal is straightforward: coding agents need a database they can run anywhere. They also need a database [...] The post AI Agents: Meet the Azure Cosmos DB vNext Emulator appeared first on Azure Cosmos DB Blog.

## Deploy on Azure: keep your Lovable apps in your own subscription

DevFeed: [Deploy on Azure: keep your Lovable apps in your own subscription](<https://devfeed.tech/articles/deploy-on-azure-keep-your-lovable-apps-in-your-own-subscription-88081.md>)

Original publisher: [Read original article](<https://lovable.dev/blog/deploy-on-azure>)

Author: Malavika Balachandran Tadeusz & Rohan Ranjan

Published: 2026-10-15T12:45:00Z

Content type: article

Language: en

Sources: [Lovable](<https://devfeed.tech/sources/lovable.md>)

Topics: [Azure](<https://devfeed.tech/topics/azure.md>), [Azure Kubernetes Service](<https://devfeed.tech/topics/azure-kubernetes-service.md>), [azure functions](<https://devfeed.tech/topics/azure-functions.md>), [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>), [Microsoft](<https://devfeed.tech/topics/microsoft.md>), [Azure OpenAI](<https://devfeed.tech/topics/azure-openai.md>)

Tags: [aks](<https://devfeed.tech/tags/aks.md>), [announcements](<https://devfeed.tech/tags/announcements.md>), [azure](<https://devfeed.tech/tags/azure.md>), [azure-functions](<https://devfeed.tech/tags/azure-functions.md>), [build](<https://devfeed.tech/tags/build.md>), [business](<https://devfeed.tech/tags/business.md>), [deploy](<https://devfeed.tech/tags/deploy.md>), [encryption](<https://devfeed.tech/tags/encryption.md>), [enterprise](<https://devfeed.tech/tags/enterprise.md>), [entra-id](<https://devfeed.tech/tags/entra-id.md>)

### AI overview

Lovable's Deploy on Azure option is in private preview for select Enterprise customers. It runs apps and their data in a customer's Azure subscription, with infrastructure including an AKS cluster, Azure Functions, Azure Database for PostgreSQL, and Blob Storage. Lovable continues to host the editor and AI-assisted building service, while customers manage the Azure footprint and apply their security controls.

### Source excerpt

Deploy on Azure is now in private preview, so your apps and their data can run in your own Azure subscription. Here's every way to build with Lovable on Microsoft today, from fully inside your Microsoft environment to fully managed by Lovable.

## 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.

## Count Unique Visitors Without Cookies Using Daily Salted Hashes in Express

DevFeed: [Count Unique Visitors Without Cookies Using Daily Salted Hashes in Express](<https://devfeed.tech/articles/count-unique-visitors-without-cookies-using-daily-salted-hashes-in-express-85992.md>)

Original publisher: [Read original article](<https://www.sitepoint.com/count-unique-visitors-without-cookies-tutorial/>)

Author: SitePoint Team

Published: 2026-10-13T15:43:00Z

Content type: tutorial

Language: en

Sources: [SitePoint](<https://devfeed.tech/sources/sitepoint.md>)

Topics: [Back end](<https://devfeed.tech/topics/backend.md>), [Express](<https://devfeed.tech/topics/express.md>), [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>), [sha256](<https://devfeed.tech/topics/sha256.md>)

Tags: [databases](<https://devfeed.tech/tags/databases.md>), [express](<https://devfeed.tech/tags/express.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [programming](<https://devfeed.tech/tags/programming.md>), [server](<https://devfeed.tech/tags/server.md>), [sha-256](<https://devfeed.tech/tags/sha-256.md>), [web](<https://devfeed.tech/tags/web.md>)

### AI overview

This tutorial shows how to build a server-side, cookieless unique visitor counter with Express, PostgreSQL, and Node.js crypto. It uses a daily rotating salt and truncated SHA-256 hashes to deduplicate visits, and explains trade-offs such as shared-IP undercounting, midnight boundary overcounting, hash collisions, and possible privacy obligations.

### Source excerpt

Build a server-side visitor counter in Express and PostgreSQL using daily-salted SHA-256 hashes, and examine failure modes including CGNAT collisions, midnight-UTC splits, and 64-bit hash collision risks. Continue reading Count Unique Visitors Without Cookies Using Daily Salted Hashes in Express on SitePoint.

## Introducing the Native Confluent Cloud Connector Experience in Azure Cosmos DB!

DevFeed: [Introducing the Native Confluent Cloud Connector Experience in Azure Cosmos DB!](<https://devfeed.tech/articles/introducing-the-native-confluent-cloud-connector-experience-in-azure-cosmos-db-84022.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/cosmosdb/introducing-the-native-confluent-cloud-connector-experience-in-azure-cosmos-db/>)

Author: Theo van Kraay

Published: 2026-10-09T07:00:28Z

Content type: release

Language: en

Sources: [Azure Cosmos DB Blog](<https://devfeed.tech/sources/azure-cosmos-db-blog.md>)

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

Tags: [apache-kafka](<https://devfeed.tech/tags/apache-kafka.md>), [azure-cosmos-db-for-nosql](<https://devfeed.tech/tags/azure-cosmos-db-for-nosql.md>), [confluent-cloud](<https://devfeed.tech/tags/confluent-cloud.md>), [cosmos](<https://devfeed.tech/tags/cosmos.md>), [data-movement](<https://devfeed.tech/tags/data-movement.md>), [event-streams](<https://devfeed.tech/tags/event-streams.md>), [java-sdk](<https://devfeed.tech/tags/java-sdk.md>), [kafka-connectors](<https://devfeed.tech/tags/kafka-connectors.md>)

### AI overview

Azure Cosmos DB and Confluent Cloud now have a native Azure portal workflow for discovering, creating, and configuring the fully managed V2 Kafka connector. It supports sending Cosmos DB change feed updates to Kafka for downstream processing and writing Kafka events into Cosmos DB to create application-ready views.

### Source excerpt

Co-authored with Praveen Raja P Azure Cosmos DB already includes a powerful event foundation: change feed provides a durable, ordered record of item changes within each logical partition. It is ideal for reacting to operational data as it changes, building projections, and driving workflows directly from the database. Confluent Cloud adds a complementary event layer [...] The post Introducing the Native Confluent Cloud Connector Experience in Azure Cosmos DB! appeared first on Azure Cosmos DB Blog.

## Translating an Elasticsearch Search Request to Azure Cosmos DB

DevFeed: [Translating an Elasticsearch Search Request to Azure Cosmos DB](<https://devfeed.tech/articles/translating-an-elasticsearch-search-request-to-azure-cosmos-db-63868.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/cosmosdb/translating-an-elasticsearch-search-request-to-azure-cosmos-db/>)

Author: Madeline Egan

Published: 2026-10-02T07:00:14Z

Content type: tutorial

Language: en

Sources: [Azure Cosmos DB Blog](<https://devfeed.tech/sources/azure-cosmos-db-blog.md>)

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

Tags: [azure-cosmos-db](<https://devfeed.tech/tags/azure-cosmos-db.md>), [azure-cosmos-db-for-nosql](<https://devfeed.tech/tags/azure-cosmos-db-for-nosql.md>), [bm25](<https://devfeed.tech/tags/bm25.md>), [elasticsearch](<https://devfeed.tech/tags/elasticsearch.md>), [full-text-search](<https://devfeed.tech/tags/full-text-search.md>), [search](<https://devfeed.tech/tags/search.md>)

### AI overview

The tutorial explains how to translate Elasticsearch search requests into Azure Cosmos DB query patterns. It covers ranked full-text results, separate aggregate queries for facets, derived rating and price buckets, and client-side handling of highlighting. The translation does not preserve Elasticsearch field boosts, and the tutorial recommends validating ranking, facet counts, request units, and latency with representative data.

### Source excerpt

This tutorial shows how common Elasticsearch search requests can be expressed using Azure Cosmos DB query patterns. Some Elasticsearch capabilities map directly to Cosmos DB full-text search functions, while others require separate queries or application-layer handling. Each step shows the closest Cosmos DB pattern and explains what changes in the process. In Elasticsearch, one search [...] The post Translating an Elasticsearch Search Request to Azure Cosmos DB appeared first on Azure Cosmos DB Blog.

## Azure Cosmos DB Shell is now available in the Azure portal

DevFeed: [Azure Cosmos DB Shell is now available in the Azure portal](<https://devfeed.tech/articles/azure-cosmos-db-shell-is-now-available-in-the-azure-portal-63193.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/cosmosdb/azure-cosmos-db-shell-is-now-available-in-the-azure-portal/>)

Author: Sajeetharan Sinnathurai

Published: 2026-10-01T15:21:32Z

Content type: release

Language: en

Sources: [Azure Cosmos DB Blog](<https://devfeed.tech/sources/azure-cosmos-db-blog.md>)

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

Tags: [agentic](<https://devfeed.tech/tags/agentic.md>), [ai](<https://devfeed.tech/tags/ai.md>), [azure-cosmos-db](<https://devfeed.tech/tags/azure-cosmos-db.md>), [azure-cosmos-db-shell](<https://devfeed.tech/tags/azure-cosmos-db-shell.md>), [azurecosmosdb](<https://devfeed.tech/tags/azurecosmosdb.md>), [commands](<https://devfeed.tech/tags/commands.md>), [cosmosdbshell](<https://devfeed.tech/tags/cosmosdbshell.md>), [databases](<https://devfeed.tech/tags/databases.md>), [explorer](<https://devfeed.tech/tags/explorer.md>), [inspect](<https://devfeed.tech/tags/inspect.md>), [location](<https://devfeed.tech/tags/location.md>), [nosql](<https://devfeed.tech/tags/nosql.md>), [queries](<https://devfeed.tech/tags/queries.md>), [shell](<https://devfeed.tech/tags/shell.md>), [terminal](<https://devfeed.tech/tags/terminal.md>)

### AI overview

Azure Cosmos DB Shell can now be opened from the Azure portal's Data Explorer, where it connects to the selected account. The preview shell supports database and container navigation, NoSQL queries, resource inspection, data updates, and repeatable scripts and workflows.

### Source excerpt

You can now open Azure Cosmos DB Shell directly from Data Explorer in the Azure portal. The shell gives you a terminal-style way to work with Azure Cosmos DB. You can move through databases and containers as you would through folders, run NoSQL queries, inspect resources, and update data. When you launch it from Data [...] The post Azure Cosmos DB Shell is now available in the Azure portal appeared first on Azure Cosmos DB Blog.

## SQL Server on Azure Local is now generally available

DevFeed: [SQL Server on Azure Local is now generally available](<https://devfeed.tech/articles/sql-server-on-azure-local-is-now-generally-available-63046.md>)

Original publisher: [Read original article](<https://www.microsoft.com/en-us/sql-server/blog/2026/09/28/sql-server-on-azure-local-is-now-generally-available/>)

Author: Raj Pochiraju

Published: 2026-09-29T16:40:06Z

Content type: release

Language: en

Sources: [Microsoft Azure](<https://devfeed.tech/sources/microsoft-azure-blog.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>), [Azure Arc](<https://devfeed.tech/topics/azure-arc.md>), [Azure](<https://devfeed.tech/topics/azure.md>), [clean energy data centers](<https://devfeed.tech/topics/clean-energy-data-centers.md>)

Tags: [azure](<https://devfeed.tech/tags/azure.md>), [azure-arc](<https://devfeed.tech/tags/azure-arc.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [compute](<https://devfeed.tech/tags/compute.md>), [databases](<https://devfeed.tech/tags/databases.md>), [deployment](<https://devfeed.tech/tags/deployment.md>), [edge](<https://devfeed.tech/tags/edge.md>), [hybrid-plus-multicloud](<https://devfeed.tech/tags/hybrid-plus-multicloud.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>)

### AI overview

SQL Server on Azure Local is generally available for connected and disconnected deployments in datacenters and edge locations. Organizations can run SQL Server on customer infrastructure, manage connected deployments through Azure Arc, or continue operating locally when external connectivity is limited. Foundry Local can bring AI inference to Azure Local alongside SQL Server, but it is in preview. Licensing options depend on deployment type and eligibility.

### Source excerpt

With SQL Server on Azure Local, customers can modernize where their data resides while maintaining control over infrastructure, connectivity, and data placement. The post SQL Server on Azure Local is now generally available appeared first on Microsoft Azure Blog.

## 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.

[Next page](<https://devfeed.tech/topics/azure-sql.md?cursor=WyIyMDI2LTA5LTI5VDA3OjA1OjE2KzAwOjAwIiwgIjYxOWMwZjIwLWRkZjYtNGQ5NS04NzZjLWFlYmRiNWI4ZWY3NiJd>)