SQL Server / news
Fresh SQL Server updates and useful DBA reading from Microsoft, direct release feeds, trusted technical blogs, and r/SQLServer.
Checked Jul 12, 2026, 08:53 PM
A balanced chronological view. High-volume publishers are capped so quieter specialist sources still appear.
Showing 18 items
Hi everyone, I'm trying to understand SQL Server licensing for a failover cluster. Suppose I have a SQL Server Failover Cluster Instance (FCI) running on a Windows Server Failover Cluster (W...
Had a fun TDE implementation tonight, was helping a colleague actually as they were nervous of the process but I had done something similar, but separate (one mirror set up and one log shipp...
What's Changed Harden Claude and CI workflows by @potatoqualitee in #10369 cu25 for 2022 (do Build) by @niphlod in #10375 Copy-DbaAgentJob - Add -NewName parameter to allow copying jobs to s...
Hi folks - I'm Drew, a PM at Microsoft involved in a few fun things including the SQL formatter in SSMS (and soon other places). We're currently working on expanding the formatting options -...
This update brings the following changes since the 7.1.0-preview1 release. Package version alignment: The Microsoft.Data.SqlClient driver and its companion packages continue the aligned vers...
We had an issue with a SQL Server database in an Always On Availability Group (AOAG) where it was not synchronizing the secondary replica even though it was using the “Synchronous commit” Av...
When you change a schema owner in SQL Server, all object-level permissions vanish instantly. There is no warning. Here's how to prevent it and fix it when it happens. The post Why Your SQL P...
Learn T-SQL With Erik: Aligning Queries and Indexes Part 4 Chapters 00:00:00 – Introduction 00:00:21 – Consulting Services 00:01:10 – Free Tools Mention 00:02:18 – Upcoming Event 00:03:16 –...
After the PASS Data Community Summit in Frankfurt, Germany, I headed back to Iceland and spent a few more days gallivanting around the country in a Tesla Model Y camper. (Well, “camper” is a...
Learn T-SQL With Erik: Aligning Queries and Indexes Part 3 Chapters 00:00:00 – Introduction 00:02:15 – Index Alignment and Design 00:04:33 – Query Tuning Magic 00:06:54 – Parameter Sniffing...
A veteran SQL Server expert's wish list for T-SQL: true constants, enumerations, extensibility, better naming consistency, and more. See what's missing.… The post What’s missing in T-SQL? My...
Learn about a few new features built into SQL Server 2022 that can help improve performance on your workload. The post Five Intelligent Query Processing Features in SQL Server 2022 That Quie...
When Adam Machanic started T-SQL Tuesday, I bet that nobody, least of all himself, expected it to run for over ten years. Yet, here we are. Not ten, but over 16 years later. Or 200 months, t...
I open it up and the first thing I see is a comment with a changelog showing a long list of dates and author initials. Oh I know, you think documentation is a good thing, but: Somebody’s ini...
SQL Server Performance Office Hours Episode 67 To ask your questions, head over here. Chapters 00:00:00 – Introduction 00:04:08 – Memory Grants and Sorts 00:07:59 – Suspicious Plan Operators...
I work with databases for a living. I teach people, and I help them via consulting. And as far as I can remember, I’ve never written something about how b-trees work. And I don’t ever expect...
Introduction These are my SQL Server Diagnostic Information Queries for July 2026, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration and per...
Welcome back to my plansplaining blog series, where I dive deep into the details of non-obvious execution plans. This part is also a sort of follow up on my post from two weeks ago, when I w...
Use Microsoft material for product, servicing, security, support, and release decisions.
Built on a consistent Microsoft SQL foundation from on premises to the cloud, Azure SQL brings AI capabilities directly into your database experience. The post Advancing agentic AI with Microsoft data...
SQL Server releases
Microsoft is modernizing SQL tools with AI, SSMS, Visual Studio Code, and DevOps features to boost productivity and future-proof development. The post How the Microsoft SQL team is investing in SQL to...
Tools & drivers
One consistent SQL delivers the agility and consistency needed to modernize data systems and unlock new innovation opportunities. The post One consistent SQL: The launchpad from legacy to innovation a...
SQL Server releases
We are moving toward general availability of SQL Server 2025 and focusing on delivering enhanced stability, performance, and product improvements. The post Accelerating SQL Server 2025 momentum: Annou...
Performance
We’re excited to announce a new migration experience in Azure Arc to simplify and accelerate SQL Server migration. This new experience, now in preview, is powered by Azure Database Migration Service....
SQL Server releases
We encourage all our customers running SQL Server 2016 to start planning for the end of support. We have migration resources, best practices, as well as a rich ecosystem of partners ready to help. The...
SQL Server releases
In this blog, we’ll walk you through what’s new across these services so you can plan your upgrade holistically and unlock the full potential of SQL Server 2025. The post Enhancing reporting and analy...
SQL Server releases
SQL Server 2025 is the most significant release for SQL developers in the last decade and will help streamline application development and greatly reduce complexity. The post From code to community: T...
SQL Server releases
Direct releases for SqlClient, the Microsoft JDBC driver, VS Code MSSQL, and dbatools.
What's Changed Harden Claude and CI workflows by @potatoqualitee in #10369 cu25 for 2022 (do Build) by @niphlod in #10375 Copy-DbaAgentJob - Add -NewName parameter to allow copying jobs to sa… by @fro...
Tools & drivers
This update brings the following changes since the 7.1.0-preview1 release. Package version alignment: The Microsoft.Data.SqlClient driver and its companion packages continue the aligned versioning int...
Tools & drivers
added error telemetry for failed provisioning Potential fix for pull request finding Co-authored-by: Copilot Autofix powered by AI 175728472+Copilot@users.noreply.github.com fixed lint fixed lint use...
Tools & drivers
This update brings the following changes since the 7.0.1 release: Important — package version alignment: Starting with 7.0.2, the Microsoft.Data.SqlClient driver and its companion packages share a sin...
Tools & drivers
This update brings the following changes since the 6.1.5 release: Added WAM broker support for the supported Entra ID authentication modes (Windows only) What Changed: Added support for the Web Accoun...
Tools & drivers
What's Changed Copy-DbaDatabase - Pass IgnoreFileChecks to Backup-DbaDatabase for UNC paths by @andreasjordan in #10360 Test-DbaSpn - Fix no output when an instance has TCP/IP disabled by @andreasjord...
Tools & drivers
Added Add Enhanced Routing Support for Hyperscale Reader Endpoints #2935 What was added : Implemented TDS FEATUREEXT 0x0F negotiation and ENVCHANGE 0x21 parsing to support Hyperscale reader endpoints...
Tools & drivers
This update brings the following changes since the 7.0.0 release: Added SqlBatch Support on .NET Framework What Changed: Added SqlBatch and related batch-command support for the .NET Framework target...
Tools & drivers
Technical articles and opinions from selected SQL Server publishers. Check Microsoft documentation before making version, security, or support decisions.
Hi everyone, I'm trying to understand SQL Server licensing for a failover cluster. Suppose I have a SQL Server Failover Cluster Instance (FCI) running on a Windows Server Failover Cluster (WSFC) with...
HA & DR
Had a fun TDE implementation tonight, was helping a colleague actually as they were nervous of the process but I had done something similar, but separate (one mirror set up and one log shipping one, n...
Backup & recovery
We had an issue with a SQL Server database in an Always On Availability Group (AOAG) where it was not synchronizing the secondary replica even though it was using the “Synchronous commit” Availability...
HA & DR
When you change a schema owner in SQL Server, all object-level permissions vanish instantly. There is no warning. Here's how to prevent it and fix it when it happens. The post Why Your SQL Permissions...
Security & servicing
I need to verify ESU has been applied to SQL servers (2016) in Arc. I have done a ton of searching and can't narrow down on SQL specifically. The Azure team can only provide me with a list of servers...
Administration
Learn T-SQL With Erik: Aligning Queries and Indexes Part 4 Chapters 00:00:00 – Introduction 00:00:21 – Consulting Services 00:01:10 – Free Tools Mention 00:02:18 – Upcoming Event 00:03:16 – Tipping Po...
Performance
After the PASS Data Community Summit in Frankfurt, Germany, I headed back to Iceland and spent a few more days gallivanting around the country in a Tesla Model Y camper. (Well, “camper” is a glamorous...
Performance
Learn T-SQL With Erik: Aligning Queries and Indexes Part 3 Chapters 00:00:00 – Introduction 00:02:15 – Index Alignment and Design 00:04:33 – Query Tuning Magic 00:06:54 – Parameter Sniffing Issue 00:0...
Performance
A veteran SQL Server expert's wish list for T-SQL: true constants, enumerations, extensibility, better naming consistency, and more. See what's missing.… The post What’s missing in T-SQL? My wish list...
Development
Learn about a few new features built into SQL Server 2022 that can help improve performance on your workload. The post Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Y...
Performance
When Adam Machanic started T-SQL Tuesday, I bet that nobody, least of all himself, expected it to run for over ten years. Yet, here we are. Not ten, but over 16 years later. Or 200 months, to be exact...
Development
I open it up and the first thing I see is a comment with a changelog showing a long list of dates and author initials. Oh I know, you think documentation is a good thing, but: Somebody’s initials from...
Development
