SQL Server / news
Fresh SQL Server updates and useful DBA reading from Microsoft, direct release feeds, trusted technical blogs, and r/SQLServer.
Checked Sep 16, 2026, 02:10 AM
A balanced chronological view. High-volume publishers are capped so quieter specialist sources still appear.
Showing 18 items
Hi everyone, I recently migrated our architecture to the cloud ([GCP]). Previously, the application and SQL Server were on the same machine. Now, they are separated: 1 Application Server and...
Working in SSMS 22.10.0 and I get a popup that 22.10.1 is available. So I click the button to see what is updated. The SSMS Release Notes page only goes up to 22.10.0. So I start over and se...
NOLOCK is bad and you probably shouldn’t use it, but every time I mention that publicly, the pushback just keeps coming. I don’t know why people so firmly believe that their situation couldn...
SQL Server Performance Office Hours Episode 79 – Dang is it hot again To ask your questions, head over here. Chapters 00:00:00 – Introduction 00:01:28 – TempDb Contention in 2022+ 00:03:57 –...
At my company we work with a big SQL server database, it makes it a hassle navigating, developing or understanding the business logic. With AI being a thing now I'd like to have something th...
Discover how a Microsoft-signed system procedure bypasses SQL Server's disabled xp_cmdshell setting - plus detection and mitigation steps for defenders.… The post How a Microsoft-signed SQL...
Added Add FLOAT16 Vector Version Negotiation to the TVP Write Path #2997 What was added : Negotiated vector-version validation before writing VECTOR column metadata for table-valued paramete...
This update brings the following changes since the 7.0.2 release: The core driver and its companion packages ship together as version 7.0.3 . Update the companion packages you use alongside...
For this episode, I’m up in the mountains just outside Vegas, enjoying the nice cool temperatures, spending the weekend at Mount Charleston. Let’s go through your top-voted questions from ht...
SQL Server Performance Office Hours Episode 78 – There’s No SSMS In Paris To ask your questions, head over here. Chapters 00:00:00 – Introduction 00:02:45 – Blocking Chains and Deadlocks 00:...
By popular demand, SQL Server 2025 added JSON indexes. You can eat the cake of being able to store practically schema-less JSON blobs as part of each row, and have it too by querying specifi...
SQL Server Performance Office Hours Episode 77 – Paris is nice again To ask your questions, head over here. Chapters 00:00:00 – Introduction 00:01:25 – Query Plan Changes Explained 00:04:07...
Stack Overflow had two outages involving the same identity column. The first time, we bought ourselves 12 years of runway. The second time, we burned through it in minutes. The post T-SQL Tu...
Learn how to detect and report SQL Server login failures using T-SQL and xp_readerrorlog. Includes ready-to-use scripts for filtering, aggregating, and emailing alerts.… The post SQL Server...
(Warning: This blog post is non-technical but purely personal. In my leukemia diary, I write openly about my current health issues. This blog might be triggering for people who struggle with...
SQL Server triggers execute under the caller's privileges by default - not the creator's. Learn why this design enables privilege escalation, how Oracle and Service Broker do it differently,...
Version 1.45.1 Release date: August 26, 2026 Release status: GA What's new in 1.45.1 Improved cell selection in the new Query Results Grid (Preview) to match the familiar classic grid experi...
Aaron Bertrand talks about multiple ways NOLOCK can seduce you into basing update decisions on faulty data. The post Dirty Reads, Permanent Damage appeared first on SQLPerformance.com .
Use Microsoft material for product, servicing, security, support, and release decisions.
No items are loaded in this section right now.
Direct releases for SqlClient, the Microsoft JDBC driver, VS Code MSSQL, and dbatools.
Added Add FLOAT16 Vector Version Negotiation to the TVP Write Path #2997 What was added : Negotiated vector-version validation before writing VECTOR column metadata for table-valued parameters. Who be...
Tools & drivers
This update brings the following changes since the 7.0.2 release: The core driver and its companion packages ship together as version 7.0.3 . Update the companion packages you use alongside the driver...
Tools & drivers
This update brings the following changes since the 6.1.6 release: Changed Updated the Microsoft.Data.SqlClient.SNI and Microsoft.Data.SqlClient.SNI.runtime dependencies to 6.0.3 (was 6.0.2). ( #4598 )...
Tools & drivers
This update brings the following changes since the 7.1.0-preview2 release. Package version alignment: The Microsoft.Data.SqlClient driver and its companion packages continue the aligned versioning int...
Tools & drivers
Version 1.45.1 Release date: August 26, 2026 Release status: GA What's new in 1.45.1 Improved cell selection in the new Query Results Grid (Preview) to match the familiar classic grid experience, incl...
Tools & drivers
Version 1.7.0 Release date: August 19, 2026 Release status: GA What's new in 1.7.0 Added support for using Move to Schema on sequences and DML triggers Added a Restore Packages command to the SQL proj...
Tools & drivers
What's Changed VMSS CI fleet: replace AppVeyor with Azure VMSS self-hosted runners by @potatoqualitee in #10414 Add Import-DbaParquet command by @jovanpop-msft in #10309 Save-DbaCommunitySoftware - Re...
Tools & drivers
Version 1.44.1 Release date: July 29, 2026 Release status: GA What's new in 1.44.1 Fixed an issue where some connection-related dialogs would be blank when opened on systems with case-sensitive file-s...
Tools & drivers
Technical articles and opinions from selected SQL Server publishers. Check Microsoft documentation before making version, security, or support decisions.
Hi everyone, I recently migrated our architecture to the cloud ([GCP]). Previously, the application and SQL Server were on the same machine. Now, they are separated: 1 Application Server and 1 dedicat...
Performance
Working in SSMS 22.10.0 and I get a popup that 22.10.1 is available. So I click the button to see what is updated. The SSMS Release Notes page only goes up to 22.10.0. So I start over and search for t...
Backup & recovery
NOLOCK is bad and you probably shouldn’t use it, but every time I mention that publicly, the pushback just keeps coming. I don’t know why people so firmly believe that their situation couldn’t possibl...
Performance
SQL Server Performance Office Hours Episode 79 – Dang is it hot again To ask your questions, head over here. Chapters 00:00:00 – Introduction 00:01:28 – TempDb Contention in 2022+ 00:03:57 – Serial Pl...
Performance
At my company we work with a big SQL server database, it makes it a hassle navigating, developing or understanding the business logic. With AI being a thing now I'd like to have something that is trai...
Tools & drivers
Discover how a Microsoft-signed system procedure bypasses SQL Server's disabled xp_cmdshell setting - plus detection and mitigation steps for defenders.… The post How a Microsoft-signed SQL Server sto...
Security & servicing
For this episode, I’m up in the mountains just outside Vegas, enjoying the nice cool temperatures, spending the weekend at Mount Charleston. Let’s go through your top-voted questions from https://poll...
Performance
SQL Server Performance Office Hours Episode 78 – There’s No SSMS In Paris To ask your questions, head over here. Chapters 00:00:00 – Introduction 00:02:45 – Blocking Chains and Deadlocks 00:05:15 – CP...
Performance
By popular demand, SQL Server 2025 added JSON indexes. You can eat the cake of being able to store practically schema-less JSON blobs as part of each row, and have it too by querying specific values q...
Performance
SQL Server Performance Office Hours Episode 77 – Paris is nice again To ask your questions, head over here. Chapters 00:00:00 – Introduction 00:01:25 – Query Plan Changes Explained 00:04:07 – Redesign...
Performance
Stack Overflow had two outages involving the same identity column. The first time, we bought ourselves 12 years of runway. The second time, we burned through it in minutes. The post T-SQL Tuesday #202...
Performance
Learn how to detect and report SQL Server login failures using T-SQL and xp_readerrorlog. Includes ready-to-use scripts for filtering, aggregating, and emailing alerts.… The post SQL Server login fail...
Development
