# sql-server

Microsoft SQL Server is a relational database management system whose applications and tools communicate using Transact-SQL (T-SQL).

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.

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

## Killing a tempdb killer - Part 1

DevFeed: [Killing a tempdb killer - Part 1](<https://devfeed.tech/articles/killing-a-tempdb-killer-part-1-135973.md>)

Original publisher: [Read original article](<https://sqlperformance.com/2026/11/tempdb/killing-a-tempdb-killer-part-1>)

Author: Aaron Bertrand

Published: 2026-11-16T06:00:28Z

Content type: article

Language: en

Sources: [SQLPerformance.com](<https://devfeed.tech/sources/sqlperformance-com.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [database monitoring](<https://devfeed.tech/topics/database-monitoring.md>), [observability](<https://devfeed.tech/topics/observability.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>)

Tags: [monitoring](<https://devfeed.tech/tags/monitoring.md>), [rca](<https://devfeed.tech/tags/rca.md>), [risks](<https://devfeed.tech/tags/risks.md>), [sessions](<https://devfeed.tech/tags/sessions.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [tempdb](<https://devfeed.tech/tags/tempdb.md>)

### AI overview

The excerpt describes a self-contained SQL Server tempdb monitoring system designed to detect capacity risks early and preserve evidence for root-cause analysis. A view reports data and log usage, drive headroom, whether the next autogrowth can fit, and configuration warnings. A collector, intended to run about every ten seconds, stores lightweight snapshots and starts detailed session and growth capture when data or log free space falls below a configurable threshold (50% by default). It alerts at configured pressure levels and can terminate selected user sessions only when rule-specific checks and safeguards pass; log-related termination is observation-only unless enabled, and some log reuse candidates remain diagnostic when session attribution is ambiguous. The design uses the default trace for growth evidence when available, so that capture depends on the trace being enabled. It also retains monitoring history with cleanup rules, preserving significant session details and kill decisions longer for RCA.

### Source excerpt

Aaron Bertrand presents a practical SQL Server tempdb monitoring system that flags risks, captures pressure, preserves RCA evidence, and can safely stop runaway sessions. The post Killing a tempdb killer - Part 1 appeared first on SQLPerformance.com.

## Using AWS Backup to resynchronize a SQL Server AlwaysOn Availability Group

DevFeed: [Using AWS Backup to resynchronize a SQL Server AlwaysOn Availability Group](<https://devfeed.tech/articles/using-aws-backup-to-resynchronize-a-sql-server-alwayson-availability-group-131175.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/using-aws-backup-to-resynchronize-a-sql-server-alwayson-availability-group/>)

Author: Gabriel Pereira

Published: 2026-11-12T18:37:14Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [backups](<https://devfeed.tech/topics/backups.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [Amazon EC2](<https://devfeed.tech/topics/amazon-ec2.md>), [Amazon Elastic Block Store (Amazon EBS)](<https://devfeed.tech/topics/amazon-elastic-block-store-amazon-ebs.md>), [AWS IAM](<https://devfeed.tech/topics/aws-iam.md>), [database monitoring](<https://devfeed.tech/topics/database-monitoring.md>), [Amazon EventBridge](<https://devfeed.tech/topics/amazon-eventbridge.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [alwayson](<https://devfeed.tech/tags/alwayson.md>), [amazon-cloudwatch](<https://devfeed.tech/tags/amazon-cloudwatch.md>), [amazon-ec2](<https://devfeed.tech/tags/amazon-ec2.md>), [amazon-elastic-block-store-amazon-ebs](<https://devfeed.tech/tags/amazon-elastic-block-store-amazon-ebs.md>), [amazon-elastic-compute-cloud-amazon-ec2](<https://devfeed.tech/tags/amazon-elastic-compute-cloud-amazon-ec2.md>), [amazon-eventbridge](<https://devfeed.tech/tags/amazon-eventbridge.md>), [availability](<https://devfeed.tech/tags/availability.md>), [aws](<https://devfeed.tech/tags/aws.md>), [aws-backup](<https://devfeed.tech/tags/aws-backup.md>), [backup](<https://devfeed.tech/tags/backup.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [rebuild](<https://devfeed.tech/tags/rebuild.md>), [recovery](<https://devfeed.tech/tags/recovery.md>), [reduce](<https://devfeed.tech/tags/reduce.md>), [replica](<https://devfeed.tech/tags/replica.md>), [restore](<https://devfeed.tech/tags/restore.md>), [snapshot](<https://devfeed.tech/tags/snapshot.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>)

### AI overview

AWS Backup can rebuild a failed SQL Server AlwaysOn secondary by restoring an application-consistent, VSS-enabled EC2 snapshot, then reconfiguring the node and rejoining it to the Availability Group. This EC2-level restore avoids streaming data from the primary as automatic seeding does and avoids the manual full backup, shipping, and restore cycle. The SQL Server VSS restore runbook cannot restore a secondary; it is limited to standalone databases or AG primaries. After restore, secondary IP addresses must be assigned manually. If VSS prerequisites are missing, resolve any cluster split-brain before rejoining. A broken LSN chain--such as when a primary log backup truncates records while the secondary is offline--requires per-database differential and log backups restored on the secondary with NORECOVERY before rejoining. The text reports about 10 minutes for one 100 GB lab restore and 6m13s to copy backup files in its broken-chain scenario; actual timing depends on volume size, file size, network throughput, and storage performance.

### Source excerpt

Learn how to use AWS Backup to rebuild a failed secondary replica in a SQL Server AlwaysOn Availability Group on Amazon EC2. We walk through capturing an application-consistent snapshot, restoring the EC2 instance, rejoining the Availability Group, and handling a broken LSN chain to reduce recovery time compared to a manual backup and restore.

## AI-driven database investigation using MCP, Agent Skills, and AWS DevOps Agent

DevFeed: [AI-driven database investigation using MCP, Agent Skills, and AWS DevOps Agent](<https://devfeed.tech/articles/ai-driven-database-investigation-using-mcp-agent-skills-and-aws-devops-agent-131174.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/integrate-mcp-tools-agent-skills-and-aws-devops-agent-for-ai-driven-database-investigation/>)

Author: Sudhir Amin

Published: 2026-11-12T18:34:07Z

Content type: article

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [Agent Skills](<https://devfeed.tech/topics/agent-skills.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [RDS for SQL Server](<https://devfeed.tech/topics/rds-for-sql-server.md>), [AI Agent](<https://devfeed.tech/topics/ai-agent.md>), [Amazon Bedrock AgentCore](<https://devfeed.tech/topics/amazon-bedrock-agentcore.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>), [AWS IAM](<https://devfeed.tech/topics/aws-iam.md>), [Amazon Bedrock](<https://devfeed.tech/topics/amazon-bedrock.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [DevOps](<https://devfeed.tech/topics/devops.md>), [MSP MCP](<https://devfeed.tech/topics/msp-mcp.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [agent](<https://devfeed.tech/tags/agent.md>), [agent-skills](<https://devfeed.tech/tags/agent-skills.md>), [agentcore](<https://devfeed.tech/tags/agentcore.md>), [ai](<https://devfeed.tech/tags/ai.md>), [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-bedrock](<https://devfeed.tech/tags/amazon-bedrock.md>), [amazon-bedrock-agentcore](<https://devfeed.tech/tags/amazon-bedrock-agentcore.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [autonomous](<https://devfeed.tech/tags/autonomous.md>), [aws](<https://devfeed.tech/tags/aws.md>), [aws-lambda](<https://devfeed.tech/tags/aws-lambda.md>), [connect](<https://devfeed.tech/tags/connect.md>), [database](<https://devfeed.tech/tags/database.md>), [dba](<https://devfeed.tech/tags/dba.md>), [devops](<https://devfeed.tech/tags/devops.md>), [devops-agent](<https://devfeed.tech/tags/devops-agent.md>), [diagnostic](<https://devfeed.tech/tags/diagnostic.md>), [investigation](<https://devfeed.tech/tags/investigation.md>), [mcp](<https://devfeed.tech/tags/mcp.md>), [rds-for-sql-server](<https://devfeed.tech/tags/rds-for-sql-server.md>), [skills](<https://devfeed.tech/tags/skills.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>)

### AI overview

AWS DevOps Agent can investigate RDS for SQL Server incidents by combining CloudWatch and Database Insights telemetry with SQL-specific MCP tools hosted in Lambda and exposed through Amazon Bedrock AgentCore Gateway. A Markdown skill defines triage thresholds, diagnostic steps, and report format; built-in telemetry identifies the problem type, while Gateway tools retrieve session, query, plan, and index details. In the example, an alarm led the agent to identify a head blocker holding a lock on dbo.Orders, with about 14 sessions waiting. It linked recurring spikes to a five-minute transaction pattern, noted it could not identify the client process, and recommended removing the delay, bounding client timeouts, and raising the alarm threshold. Access is constrained through SigV4, an allowlist, Secrets Manager credential retrieval by Lambda, and a read-only SQL login. The sample requires Database Insights, suitable database permissions, private VPC access, and supported AWS services and region.

### Source excerpt

Learn how to connect Amazon RDS for SQL Server diagnostic tools to AWS DevOps Agent through Amazon Bedrock AgentCore Gateway. MCP tools run in AWS Lambda behind a governed Gateway endpoint, and an investigation skill encodes your DBA team's method so the agent can triage alarms and run autonomous, auditable database investigations.

## Microsoft: Recent Windows updates cause SQL Server performance issues

DevFeed: [Microsoft: Recent Windows updates cause SQL Server performance issues](<https://devfeed.tech/articles/microsoft-recent-windows-updates-cause-sql-server-performance-issues-130293.md>)

Original publisher: [Read original article](<https://www.bleepingcomputer.com/news/microsoft/microsoft-recent-windows-updates-cause-sql-server-performance-issues/>)

Author: Sergiu Gatlan

Published: 2026-11-12T12:11:11Z

Content type: news

Language: en

Sources: [BleepingComputer](<https://devfeed.tech/sources/bleepingcomputer.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [Windows](<https://devfeed.tech/topics/windows.md>), [patches](<https://devfeed.tech/topics/patches.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [bug](<https://devfeed.tech/tags/bug.md>), [cause](<https://devfeed.tech/tags/cause.md>), [computer-help](<https://devfeed.tech/tags/computer-help.md>), [computers](<https://devfeed.tech/tags/computers.md>), [linux](<https://devfeed.tech/tags/linux.md>), [mac](<https://devfeed.tech/tags/mac.md>), [malware](<https://devfeed.tech/tags/malware.md>), [malware-removal](<https://devfeed.tech/tags/malware-removal.md>), [microsoft](<https://devfeed.tech/tags/microsoft.md>), [mitigation](<https://devfeed.tech/tags/mitigation.md>), [november-2026](<https://devfeed.tech/tags/november-2026.md>), [october](<https://devfeed.tech/tags/october.md>), [october-2026](<https://devfeed.tech/tags/october-2026.md>), [oracle](<https://devfeed.tech/tags/oracle.md>), [patch-tuesday](<https://devfeed.tech/tags/patch-tuesday.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [security](<https://devfeed.tech/tags/security.md>), [server](<https://devfeed.tech/tags/server.md>), [spyware](<https://devfeed.tech/tags/spyware.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [support](<https://devfeed.tech/tags/support.md>), [tech-support](<https://devfeed.tech/tags/tech-support.md>), [technical-support](<https://devfeed.tech/tags/technical-support.md>), [updates](<https://devfeed.tech/tags/updates.md>), [virus](<https://devfeed.tech/tags/virus.md>), [virus-removal](<https://devfeed.tech/tags/virus-removal.md>), [windows](<https://devfeed.tech/tags/windows.md>), [windows-10](<https://devfeed.tech/tags/windows-10.md>), [windows-11](<https://devfeed.tech/tags/windows-11.md>), [windows-server](<https://devfeed.tech/tags/windows-server.md>), [windows-update](<https://devfeed.tech/tags/windows-update.md>), [windows-updates](<https://devfeed.tech/tags/windows-updates.md>)

### AI overview

Microsoft says Windows updates released since the October 2026 Patch Tuesday can leave SQL Server linked-server connections open after queries finish, causing connections to accumulate and degrading performance or stability. The issue affects OLE DB connections to external databases, including known Oracle and PostgreSQL connections, on Windows 10 and 11 clients and Windows Server 2012 and later. Administrators may manually close lingering connections or restart the SQL service, but either can interrupt active queries and the problem may return. Microsoft says an out-of-band Windows update is expected within days; business support can provide a temporary mitigation.

### Source excerpt

Microsoft has confirmed that Windows updates released since the October 2026 Patch Tuesday are causing SQL Server performance and stability issues. [...]

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

## Offline assessment and conversion with AI agents in AWS DMS

DevFeed: [Offline assessment and conversion with AI agents in AWS DMS](<https://devfeed.tech/articles/offline-assessment-and-conversion-with-ai-agents-in-aws-dms-129588.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/offline-assessment-and-conversion-with-ai-agents-in-aws-dms/>)

Author: Nelly Susanto

Published: 2026-11-11T18:56:08Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [AWS Database Migration Service](<https://devfeed.tech/topics/aws-database-migration-service.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [agents](<https://devfeed.tech/tags/agents.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-agents](<https://devfeed.tech/tags/ai-agents.md>), [aws](<https://devfeed.tech/tags/aws.md>), [aws-database-migration-service](<https://devfeed.tech/tags/aws-database-migration-service.md>), [conversion](<https://devfeed.tech/tags/conversion.md>), [dms](<https://devfeed.tech/tags/dms.md>), [dms-schema-conversion](<https://devfeed.tech/tags/dms-schema-conversion.md>), [offline](<https://devfeed.tech/tags/offline.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>)

### AI overview

AWS DMS Schema Conversion can assess and convert schemas before either database is reachable by importing exported SQL Server DDL from S3 as an offline source and using a virtual target. An MCP-enabled AI agent with the DMS Schema Conversion skill can create the virtual data providers and migration project, run assessment and conversion, and export reports and SQL for review. The workflow requires properly formatted, separate Unicode .sql files, an S3 bucket and DMS access role, plus AWS credentials with permissions for DMS, Secrets Manager, S3, and RDS. In the SalesDB-to-Aurora PostgreSQL example, about 99% of 792 SQL syntax elements converted automatically; one stored procedure needed manual changes for transaction control and @@TRANCOUNT. When ready, users can apply reviewed SQL themselves or switch the target provider to a live connection and have DMS apply it. Turning off Virtual Mode cannot be undone.

### Source excerpt

Learn how to use an AI agent with AWS DMS Schema Conversion to assess and convert SQL Server database schemas from exported DDL scripts in Amazon S3, using offline source and virtual target mode. You can start migration planning before you have source database connectivity or a provisioned target.

## Migrate SQL Server Always Encrypted CMK to AWS Secrets Manager with .NET

DevFeed: [Migrate SQL Server Always Encrypted CMK to AWS Secrets Manager with .NET](<https://devfeed.tech/articles/migrate-sql-server-always-encrypted-cmk-to-aws-secrets-manager-with-net-128934.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/dotnet/migrate-sql-server-always-encrypted-cmk-to-aws-secrets-manager-with-net/>)

Author: Akber Rizwan Shaik

Published: 2026-11-10T12:32:30Z

Content type: tutorial

Language: en

Sources: [.NET on AWS Blog](<https://devfeed.tech/sources/net-on-aws-blog.md>)

Topics: [Secrets Management](<https://devfeed.tech/topics/secrets-management.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [.NET](<https://devfeed.tech/topics/net.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [NuGet](<https://devfeed.tech/topics/nuget.md>), [C#](<https://devfeed.tech/topics/csharp.md>), [ASP.NET Core](<https://devfeed.tech/topics/asp-net-core.md>)

Tags: [amazon-elastic-container-service](<https://devfeed.tech/tags/amazon-elastic-container-service.md>), [amazon-elastic-kubernetes-service](<https://devfeed.tech/tags/amazon-elastic-kubernetes-service.md>), [asp-net](<https://devfeed.tech/tags/asp-net.md>), [asp-net-core](<https://devfeed.tech/tags/asp-net-core.md>), [aws](<https://devfeed.tech/tags/aws.md>), [aws-cli](<https://devfeed.tech/tags/aws-cli.md>), [aws-identity-and-access-management-iam](<https://devfeed.tech/tags/aws-identity-and-access-management-iam.md>), [aws-key-management-service](<https://devfeed.tech/tags/aws-key-management-service.md>), [aws-key-management-service-aws-kms](<https://devfeed.tech/tags/aws-key-management-service-aws-kms.md>), [aws-lambda](<https://devfeed.tech/tags/aws-lambda.md>), [aws-secrets-manager](<https://devfeed.tech/tags/aws-secrets-manager.md>), [certificate](<https://devfeed.tech/tags/certificate.md>), [encrypted](<https://devfeed.tech/tags/encrypted.md>), [key](<https://devfeed.tech/tags/key.md>), [migrate](<https://devfeed.tech/tags/migrate.md>), [net](<https://devfeed.tech/tags/net.md>), [net-10](<https://devfeed.tech/tags/net-10.md>), [secrets-manager](<https://devfeed.tech/tags/secrets-manager.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [windows](<https://devfeed.tech/tags/windows.md>)

### AI overview

The excerpt describes moving SQL Server Always Encrypted's column master key from the Windows Certificate Store to AWS Secrets Manager so a .NET application can run on Linux. Export the certificate and private key as a PFX, store it and its password as separate secrets, then implement and register a custom SqlColumnEncryptionKeyStoreProvider. A Windows migration utility unwraps each existing column encryption key (CEK) with the old provider and re-wraps it with the new one; the CEK and encrypted table data stay unchanged. Keep both wrapped values until queries validate, then optionally remove the old values and CMK. The one-time migration utility still requires Windows access to the certificate store, while the application can run cross-platform afterward. Dropping the old CMK can prevent SSMS and other clients without the custom provider from decrypting columns. The excerpt also notes that the sample decryption code omits signature verification and suggests adding it if the threat model requires it.

### Source excerpt

Introduction By migrating the SQL Server Always Encrypted column master key (CMK) from the Windows Certificate Store to AWS Secrets Manager, you can remove a Windows-only platform dependency from your .NET application. The default CMK store provider, MSSQL_CERTIFICATE_STORE, relies on the Windows Certificate Store. The CMK must move to a platform-agnostic store like AWS Secrets [...]

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

## 5 common SQL Server transaction problems (and how to solve them)

DevFeed: [5 common SQL Server transaction problems (and how to solve them)](<https://devfeed.tech/articles/5-common-sql-server-transaction-problems-and-how-to-solve-them-121149.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/databases/sql-server/5-common-sql-server-transaction-problems-and-how-to-solve-them/>)

Author: Sergey Gigoyan

Published: 2026-11-06T12: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>), [SQL](<https://devfeed.tech/topics/sql.md>), [audit trail](<https://devfeed.tech/topics/audit-trail.md>)

Tags: [audit](<https://devfeed.tech/tags/audit.md>), [authentication](<https://devfeed.tech/tags/authentication.md>), [blocks](<https://devfeed.tech/tags/blocks.md>), [commit](<https://devfeed.tech/tags/commit.md>), [concurrent](<https://devfeed.tech/tags/concurrent.md>), [count](<https://devfeed.tech/tags/count.md>), [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [databases](<https://devfeed.tech/tags/databases.md>), [featured](<https://devfeed.tech/tags/featured.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [insert](<https://devfeed.tech/tags/insert.md>), [nested](<https://devfeed.tech/tags/nested.md>), [phantom](<https://devfeed.tech/tags/phantom.md>), [problems](<https://devfeed.tech/tags/problems.md>), [rollback](<https://devfeed.tech/tags/rollback.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [transaction](<https://devfeed.tech/tags/transaction.md>), [transactions](<https://devfeed.tech/tags/transactions.md>)

### AI overview

The excerpt presents five SQL Server transaction pitfalls and fixes. Under default READ COMMITTED, a count query waits for an open writer; NOLOCK or READ UNCOMMITTED avoids the wait by allowing dirty, potentially inaccurate reads. REPEATABLE READ holds shared locks on rows read so later statements in the transaction cannot see those rows changed. SERIALIZABLE prevents inserts into a read range, keeping repeated counts stable. A table variable retains audit data after rollback, allowing it to be written to the audit table afterward. Nested transactions do not make a plain ROLLBACK partial: it undoes the outer transaction too. SAVE TRANSACTION and rollback to its savepoint can preserve earlier audit work while undoing later work, though some errors leave the transaction uncommittable and prevent rollback to a savepoint. The excerpt cautions that authentication and audit design require care in real systems.

### Source excerpt

Five practical SQL Server transaction problems -- dirty reads, non-repeatable reads, phantom reads, rollback behavior, and nested transactions -- with fixes.... The post 5 common SQL Server transaction problems (and how to solve them) appeared first on Simple Talk.

## CodeSOD: Only Create Me if I Exist

DevFeed: [CodeSOD: Only Create Me if I Exist](<https://devfeed.tech/articles/codesod-only-create-me-if-i-exist-119673.md>)

Original publisher: [Read original article](<https://thedailywtf.com/articles/only-create-me-if-i-exist>)

Author: Remy Porter

Published: 2026-11-05T06:30:00Z

Content type: article

Language: en

Sources: [The Daily WTF](<https://devfeed.tech/sources/the-daily-wtf.md>)

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

Tags: [codesod](<https://devfeed.tech/tags/codesod.md>), [constraint](<https://devfeed.tech/tags/constraint.md>), [database](<https://devfeed.tech/tags/database.md>), [foreign-keys](<https://devfeed.tech/tags/foreign-keys.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [table](<https://devfeed.tech/tags/table.md>)

### AI overview

The excerpt shows a SQL Server constraint that makes `ListingDetails.Id` a foreign key to the same table's `Id`. Unlike a typical self-reference between different rows, each record satisfies this constraint with its own ID, so the author says it appears to work as a no-op. The author notes they have not tested it personally and bases that conclusion on cursory searching.

### Source excerpt

Foreign keys are an important part of making sure the entities in our relational database can be connected back together and queried correctly. It's part of proper data normalization. This isn't shocking, of course: the order line table has a foreign key over to the products table, so that every line item points to a product we sell. That's database 101. Database 201, you'd also think about the times where you have a hierarchy of records, where say, every Employee has a ManagerId, which is a foreign key back to the Employee table itself (and in database 301, you'll understand why having a ManagerId field is a terrible choice, but that's neither here nor there). The important thing here is that foreign keys are very common, and foreign keys pointing back to the same table are also very common. But it can still go very wrong. Roman sends us this foreign key definition in a database they maintain. ALTER TABLE [dbo].[ListingDetails] WITH CHECK ADD CONSTRAINT [FK_Listings_Listings] FOREIGN KEY([Id]) REFERENCES [dbo].[ListingDetails] ([Id]) This ensures that the ListingDetails table's Id field is a foreign key over to the ListingDetails table's Id field. A field is a foreign key back to itself. Roman writes: "I can't believe SQL Server even allows this..." I can. While I haven't personally tried this out, a bit of cursory searching implies that this does actually work- the record satisfies its own constraint, so you can still add it to the database. It's basically a no-op, which isn't great, but it's not SQL Server's job to ensure you keep all your toes because they've removed all the footguns. [Advertisement] Utilize BuildMaster to release your software with confidence, at the pace your business demands. Download today!

## ReinDB: read-only performance monitoring for PostgreSQL, first database free

DevFeed: [ReinDB: read-only performance monitoring for PostgreSQL, first database free](<https://devfeed.tech/articles/reindb-read-only-performance-monitoring-for-postgresql-first-database-free-119626.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/reindb-read-only-performance-monitoring-for-postgresql-first-database-free-3432/>)

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

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [database monitoring](<https://devfeed.tech/topics/database-monitoring.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [RDS for PostgreSQL](<https://devfeed.tech/topics/rds-for-postgresql.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>)

Tags: [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [aws](<https://devfeed.tech/tags/aws.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [database](<https://devfeed.tech/tags/database.md>), [first](<https://devfeed.tech/tags/first.md>), [free](<https://devfeed.tech/tags/free.md>), [google-cloud](<https://devfeed.tech/tags/google-cloud.md>), [linux](<https://devfeed.tech/tags/linux.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [oracle](<https://devfeed.tech/tags/oracle.md>), [performance](<https://devfeed.tech/tags/performance.md>), [performance-monitoring](<https://devfeed.tech/tags/performance-monitoring.md>), [pg-stat-statements](<https://devfeed.tech/tags/pg-stat-statements.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [windows](<https://devfeed.tech/tags/windows.md>)

### AI overview

ReinDB monitors PostgreSQL performance by learning each database's and statement's hour-by-hour baseline from pg_stat_statements, then flagging deviations ranked by the extra database time they cost. Flags include supporting evidence such as plan history and a testable fix script with an undo for each step. It requires one read-only login and installs nothing in the database. It can run hosted, onsite on Linux or Windows, or in the customer's AWS or Google Cloud account; MySQL, SQL Server, and Oracle are also supported. The first database is free for one person with no time limit or card requirement.

### Source excerpt

Bandlei has released ReinDB, read-only performance monitoring for PostgreSQL, self-managed or on Amazon RDS and Aurora. ReinDB learns what normal looks like for each database and statement, hour by hour, using pg_stat_statements, and flags what drifts from it, ranked by the extra database time each change costs. Each flag shows the evidence, including plan history, and a fix script your DBA can test, with an undo for each step. ReinDB installs nothing in your database and needs one read-only login. It runs hosted, onsite on Linux or Windows, or in your own AWS or Google Cloud account. MySQL, SQL Server and Oracle are also supported. The first database is free for one person, with no time limit and no card. A free 109-page guide, Rein In Your Database, covers the tuning method behind it. More at reindb.com.

## How SQL Server Uses File Storage

DevFeed: [How SQL Server Uses File Storage](<https://devfeed.tech/articles/how-sql-server-uses-file-storage-116291.md>)

Original publisher: [Read original article](<https://blog.everpuredata.com/purely-educational/how-sql-server-uses-file-storage/>)

Author: Everpure

Published: 2026-11-03T21:47:03Z

Content type: article

Language: en

Sources: [Everpure](<https://devfeed.tech/sources/everpure.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [file](<https://devfeed.tech/topics/file.md>), [systems](<https://devfeed.tech/topics/systems.md>), [NVMe](<https://devfeed.tech/topics/nvme.md>), [Cache](<https://devfeed.tech/topics/cache.md>)

Tags: [access-controls](<https://devfeed.tech/tags/access-controls.md>), [alternatives](<https://devfeed.tech/tags/alternatives.md>), [api](<https://devfeed.tech/tags/api.md>), [application](<https://devfeed.tech/tags/application.md>), [applications](<https://devfeed.tech/tags/applications.md>), [apply](<https://devfeed.tech/tags/apply.md>), [approach](<https://devfeed.tech/tags/approach.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [availability](<https://devfeed.tech/tags/availability.md>), [availability-groups](<https://devfeed.tech/tags/availability-groups.md>), [backup](<https://devfeed.tech/tags/backup.md>), [backup-and-recovery](<https://devfeed.tech/tags/backup-and-recovery.md>), [backups](<https://devfeed.tech/tags/backups.md>), [consistency](<https://devfeed.tech/tags/consistency.md>), [constraint](<https://devfeed.tech/tags/constraint.md>), [educational](<https://devfeed.tech/tags/educational.md>), [evergreen-one](<https://devfeed.tech/tags/evergreen-one.md>), [file](<https://devfeed.tech/tags/file.md>), [file-storage](<https://devfeed.tech/tags/file-storage.md>), [flasharray](<https://devfeed.tech/tags/flasharray.md>), [flasharray-xl](<https://devfeed.tech/tags/flasharray-xl.md>), [microsoft-solutions](<https://devfeed.tech/tags/microsoft-solutions.md>), [performance](<https://devfeed.tech/tags/performance.md>), [purity](<https://devfeed.tech/tags/purity.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [storage](<https://devfeed.tech/tags/storage.md>)

### AI overview

SQL Server's file storage choice depends on object size, access pattern, and how tightly files must stay consistent with database rows. In-database varbinary(max) BLOBs are simple and transactional, and are often suitable below Microsoft's roughly 1 MB guideline, but add to database size, backups, restores, and buffer-pool use. FILESTREAM stores managed varbinary(max) data on NTFS or ReFS, avoids the 2 GB value limit, and uses the Windows system cache; it is Windows-only and does not support encryption. FileTable builds on FILESTREAM to expose files through a Windows share, though share operations are non-transactional. External file or object storage can scale independently and keep database backups smaller, but requires separate handling for consistency, security, backups, replication, and deletion. In every approach, underlying storage capacity, latency, and throughput still affect performance.

### Source excerpt

How SQL Server Uses File Storage by Everpure Blog Managing large objects in SQL Server requires choosing the right storage strategy. Learn how BLOBs, FILESTREAM, and FileTable differ and how the storage layer underneath plays a role in performance. The post How SQL Server Uses File Storage appeared first on Everpure Blog.

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

## Devart Updates Its Entire Delphi Line

DevFeed: [Devart Updates Its Entire Delphi Line](<https://devfeed.tech/articles/devart-updates-its-entire-delphi-line-115624.md>)

Original publisher: [Read original article](<https://sdtimes.com/devart-updates-its-entire-delphi-line/>)

Author: SD Times Newswire

Published: 2026-11-03T20:44:42Z

Content type: release

Language: en

Sources: [SD Times](<https://devfeed.tech/sources/sd-times.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [version](<https://devfeed.tech/topics/version.md>), [des](<https://devfeed.tech/topics/des.md>)

Tags: [2026-2](<https://devfeed.tech/tags/2026-2.md>), [client-side-encryption](<https://devfeed.tech/tags/client-side-encryption.md>), [data-access-components](<https://devfeed.tech/tags/data-access-components.md>), [delphi](<https://devfeed.tech/tags/delphi.md>), [microsoft-sql-server](<https://devfeed.tech/tags/microsoft-sql-server.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [newswire](<https://devfeed.tech/tags/newswire.md>), [odac](<https://devfeed.tech/tags/odac.md>), [sql-server-2025](<https://devfeed.tech/tags/sql-server-2025.md>), [updates](<https://devfeed.tech/tags/updates.md>)

### AI overview

Devart's 2026.2 Delphi update adds compatibility with RAD Studio 13 Florence Release 2, Lazarus 4.8, SQL Server 2025, and MySQL 9.7, alongside database-specific connectivity and transaction improvements. SDAC and UniDAC add Always Encrypted support for client-side encryption: full read/write support requires the Direct provider in the Professional edition, while the OLE DB provider can read encrypted data. Other listed changes include LDAP SASL/GSSAPI authentication for MySQL; PostgreSQL read-only connections and SSL SNI; transaction controls for InterBase, Firebird, Oracle, and NexusDB; and resumable SFTP uploads in SecureBridge. These are features identified in the supplied excerpt, which does not show the full article.

### Source excerpt

Devart has updated its entire Delphi product line with support for RAD Studio 13 Florence Release 2, Microsoft SQL Server 2025, and MySQL 9.7. The update, dubbed 2026.2, also introduces client-side encryption for sensitive SQL Server data. Overall, the update spans eight Data Access Components, the dbExpress driver family, the EntityDAC ORM framework, and the... ... continue reading The post Devart Updates Its Entire Delphi Line appeared first on SD Times.

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

## Why do you have so many housekeeping jobs?

DevFeed: [Why do you have so many housekeeping jobs?](<https://devfeed.tech/articles/why-do-you-have-so-many-housekeeping-jobs-103481.md>)

Original publisher: [Read original article](<https://sqlperformance.com/2026/10/sql-maintenance/too-many-housekeeping-jobs>)

Author: Aaron Bertrand

Published: 2026-10-27T13:20:39Z

Content type: article

Language: en

Sources: [SQLPerformance.com](<https://devfeed.tech/sources/sqlperformance-com.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [scheduling](<https://devfeed.tech/topics/scheduling.md>), [conditionals](<https://devfeed.tech/topics/conditionals.md>), [Artificial Intelligence](<https://devfeed.tech/topics/ai.md>)

Tags: [actions](<https://devfeed.tech/tags/actions.md>), [agent](<https://devfeed.tech/tags/agent.md>), [aging](<https://devfeed.tech/tags/aging.md>), [alerts](<https://devfeed.tech/tags/alerts.md>), [archive](<https://devfeed.tech/tags/archive.md>), [artifacts](<https://devfeed.tech/tags/artifacts.md>), [audit](<https://devfeed.tech/tags/audit.md>), [audit-trail](<https://devfeed.tech/tags/audit-trail.md>), [automatically](<https://devfeed.tech/tags/automatically.md>), [avoid](<https://devfeed.tech/tags/avoid.md>), [batch](<https://devfeed.tech/tags/batch.md>), [batching](<https://devfeed.tech/tags/batching.md>), [cons](<https://devfeed.tech/tags/cons.md>), [jobs](<https://devfeed.tech/tags/jobs.md>), [routine](<https://devfeed.tech/tags/routine.md>), [server](<https://devfeed.tech/tags/server.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-job](<https://devfeed.tech/tags/sql-job.md>), [sql-maintenance](<https://devfeed.tech/tags/sql-maintenance.md>), [sql-performance](<https://devfeed.tech/tags/sql-performance.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [sql-server-agent](<https://devfeed.tech/tags/sql-server-agent.md>), [tasks](<https://devfeed.tech/tags/tasks.md>)

### AI overview

The author recommends selectively consolidating routine, infrequent SQL Server Agent housekeeping into ordered steps to reduce overlapping work and make schedules and activity easier to inspect. The article shows ways to run steps on specified weekdays using date arithmetic independent of language and DATEFIRST settings, and suggests checking whether a task has run since its last due date so missed runs can be recovered. It covers weekly SQL Server error log cycling and retention, Extended Events file rollover plus a PowerShell cleanup fallback, and frequent batched purges for potentially large histories. Consolidation has costs: shared failures or delays, reduced per-step visibility if steps are further combined, and faster exhaustion of bounded Agent history. The author advises deliberate failure handling, durable logging in a separately retained table, and external monitoring capable of checking SQL Server Agent itself. Some resource-intensive work may need fixed maintenance windows, and tasks with different owners, security contexts, or failure requirements may merit separate jobs.

### Source excerpt

Aaron Bertrand discusses the pros and cons of consolidating lots of SQL Server Agent jobs that perform routine housekeeping tasks. The post Why do you have so many housekeeping jobs? appeared first on SQLPerformance.com.

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

## Troubleshooting Data Mismatches with tablediff on Amazon RDS for SQL Server

DevFeed: [Troubleshooting Data Mismatches with tablediff on Amazon RDS for SQL Server](<https://devfeed.tech/articles/troubleshooting-data-mismatches-with-tablediff-on-amazon-rds-for-sql-server-95993.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/troubleshooting-data-mismatches-with-tablediff-on-amazon-rds-for-sql-server/>)

Author: Kanchan Bhattacharyya

Published: 2026-10-22T16:33:04Z

Content type: article

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [RDS for SQL Server](<https://devfeed.tech/topics/rds-for-sql-server.md>), [read-replica](<https://devfeed.tech/topics/read-replica.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [observability](<https://devfeed.tech/topics/observability.md>), [Disaster Recovery](<https://devfeed.tech/topics/disaster-recovery.md>), [audit](<https://devfeed.tech/topics/audit.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>)

Tags: [2022](<https://devfeed.tech/tags/2022.md>), [2025](<https://devfeed.tech/tags/2025.md>), [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-cloudwatch](<https://devfeed.tech/tags/amazon-cloudwatch.md>), [amazon-ec2](<https://devfeed.tech/tags/amazon-ec2.md>), [amazon-elastic-compute-cloud-amazon-ec2](<https://devfeed.tech/tags/amazon-elastic-compute-cloud-amazon-ec2.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [amazon-simple-storage-service-amazon-s3](<https://devfeed.tech/tags/amazon-simple-storage-service-amazon-s3.md>), [asynchronous](<https://devfeed.tech/tags/asynchronous.md>), [audit](<https://devfeed.tech/tags/audit.md>), [best-practices](<https://devfeed.tech/tags/best-practices.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [lag](<https://devfeed.tech/tags/lag.md>), [rds-for-sql-server](<https://devfeed.tech/tags/rds-for-sql-server.md>), [read-replica](<https://devfeed.tech/tags/read-replica.md>), [replication](<https://devfeed.tech/tags/replication.md>), [scripts](<https://devfeed.tech/tags/scripts.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [t-sql](<https://devfeed.tech/tags/t-sql.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>), [troubleshooting](<https://devfeed.tech/tags/troubleshooting.md>), [utility](<https://devfeed.tech/tags/utility.md>)

### AI overview

After an Amazon RDS for SQL Server read replica catches up, tablediff can provide independent row-level parity evidence that replication metrics alone do not: compare the primary and replica only after `ReplicaLag`, `redo_queue_size`, and `log_send_queue_size` are all zero. Run it from a Windows EC2 client with access to both endpoints; target tables need a clustered primary key or unique index. It reports source-only, destination-only, and column-mismatched rows, and can generate T-SQL fixes. The replica is read-only, so remediation requires promotion, which is irreversible; regenerate the fix script after promotion and wrap its bare DML statements in an explicit transaction with a validation gate. Re-run tablediff to confirm zero differences. A fresh rebuild may be preferable for extensive or structural divergence. Comparisons scan whole tables and can give misleading results during active writes or redo, so run during a quiet period after queues drain.

### Source excerpt

Learn how to use the SQL Server tablediff utility to validate an Amazon RDS for SQL Server read replica against its primary after a replication lag event, detect and classify row-level data mismatches, and apply auditable T-SQL fix scripts on a promoted replica instance.

## VergeOS 26.2 Demo: Failover Clustering on VergeOS Shared Disks

DevFeed: [VergeOS 26.2 Demo: Failover Clustering on VergeOS Shared Disks](<https://devfeed.tech/articles/vergeos-26-2-demo-failover-clustering-on-vergeos-shared-disks-95882.md>)

Original publisher: [Read original article](<https://www.verge.io/videos/failover-clustering-demo-vergeos-26-2/>)

Author: George Crump

Published: 2026-10-22T15:30:14Z

Content type: article

Language: en

Sources: [VergeIO](<https://devfeed.tech/sources/vergeio.md>)

Topics: [virtualization](<https://devfeed.tech/topics/virtualization.md>), [Windows](<https://devfeed.tech/topics/windows.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>)

Tags: [clustering](<https://devfeed.tech/tags/clustering.md>), [demo](<https://devfeed.tech/tags/demo.md>), [failover](<https://devfeed.tech/tags/failover.md>), [file-server](<https://devfeed.tech/tags/file-server.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [storage](<https://devfeed.tech/tags/storage.md>), [vergeos](<https://devfeed.tech/tags/vergeos.md>), [vergeos-26-2](<https://devfeed.tech/tags/vergeos-26-2.md>), [videos](<https://devfeed.tech/tags/videos.md>), [vmware](<https://devfeed.tech/tags/vmware.md>), [vmware-exit](<https://devfeed.tech/tags/vmware-exit.md>), [windows](<https://devfeed.tech/tags/windows.md>)

### AI overview

VergeOS 26.2 provides shared disks for a two-node Windows failover cluster through VergeFS, without an external SAN. A virtual disk is marked shared and attached to both guest nodes; SCSI-3 Persistent Reservations coordinate disk ownership so Windows failover can operate. The demo runs SQL Server and a clustered file server, cuts power to the active node, and reports recovery on the surviving node in 31.4 seconds for SQL Server and 25.3 seconds for the file share. The failed node then powers back on and rejoins. The excerpt describes guest clustering, where cluster software inside the guests coordinates writes.

### Source excerpt

A two-node Windows failover cluster runs SQL Server and a clustered file server on VergeFS shared disks, with no external SAN. The post VergeOS 26.2 Demo: Failover Clustering on VergeOS Shared Disks appeared first on VergeIO.

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