SQL Server / news
Fresh SQL Server updates and useful DBA reading from Microsoft, direct release feeds, trusted technical blogs, and r/SQLServer.
Checked Aug 26, 2026, 09:55 PM
A balanced chronological view. High-volume publishers are capped so quieter specialist sources still appear.
Showing 18 items
dbo.sp_ask_ai — technical description Purpose sp_ask_ai is a synchronous T-SQL wrapper around the async ask_ai chat pipeline. It lets a caller in plain SQL — SSMS, sqlcmd , an Agent job, a b...
Dealing With DDL and CDC Chapters 00:00:00 – Introduction 00:01:28 – Script Overview and Problems 00:04:05 – DDL History Table and CDC Tables 00:06:37 – Handling New Capture Instances 00:09:...
Wanna play some Texas Hold ‘Em style poker and make a pile of Query Bucks? Wanna watch other database people playing? The post sp_TexasHoldEm: Multi-Player Poker in T-SQL appeared first on S...
Is it possible to upgrade from the SQL Server 2019 Standard (non-developer) to the SQL Server 2025 Standard Developer edition? submitted by /u/Sufficient-Pace7542 [link] [comments]
Ten years ago, I published a blog post with the top 10 most highly upvoted requests for Microsoft SQL Server as shown on their feedback site at the time, Connect.Microsoft.com. That site has...
SQL Server Performance Office Hours Episode 74 To ask your questions, head over here. Chapters 00:00:00 – Introduction 00:03:15 – Query Store Basics 00:06:28 – Query Store Configuration 00:0...
Hey guys, I started a local WoW server just for myself using SQL on an SSD. I saw some information that it could kill my SSD faster. Should I be worried? Or can I just play without worrying?...
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 .
A T-SQL veteran's wish list: 9 missing SQL Server features that would simplify auditing, data validation, graph queries, and error handling.… The post 9 things I wish SQL Server had (and why...
CVE-2026-47295 is a SQL Server vulnerability that lets a maliciously crafted database backup execute attacker-controlled code with sysadmin privileges during a routine RESTORE DATABASE opera...
Introduction When designing the tables or writing the stored procedures in SQL Server, we get easily tempted to choose the path of least resistance. When deciding how much space to allocate...
This week, I’m back in Vegas, spending time in the home bar to recover from jet lag. I’m not saying booze is the best way to recover – but – it helps me fall asleep after a 16-hour-time-zone...
Learn how db_ddladmin permissions plus Azure Arc's SQL extension create a confused-deputy attack path to sysadmin — and how to detect and mitigate it.… The post How Azure Arc allows a DB adm...
Performance Monitor is Going Enterprise Chapters 00:00:00 – Introduction 00:00:38 – Full Dashboard Overview 00:02:18 – Challenges with the Full Dashboard 00:04:00 – New Direction for the Too...
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 th...
SQL Server 2025 introduces native JSON indexing via CREATE JSON INDEX. Learn how it works, when to use it, and its current preview-stage limitations.… The post JSON indexing in SQL Server 20...
Aaron Bertrand shows a stored procedure he wrote to make scripting SQL Server Agent jobs idempotent and avoid schedule spaghetti. The post A script to script a script that scripts jobs appea...
Introduction Here are my Diagnostic Information Queries for August 2026 focused on SQL Server. They let you view configuration and performance comprehensively in a short time. This post disc...
Use Microsoft material for product, servicing, security, support, and release decisions.
See what changes as SQL Server 2016 reaches end of support. Choose between cloud migration, upgrading SQL Server, and Extended Security Updates (ESU). The post SQL Server 2016 end of support is here:...
Security & servicing
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
Direct releases for SqlClient, the Microsoft JDBC driver, VS Code MSSQL, and dbatools.
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
Version 1.6.2 Release date: July 15, 2026 Release status: GA What's new in 1.6.2 Added Rename Symbol refactoring support for SQL project files. Added Move to Schema refactoring support for SQL project...
Tools & drivers
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
Technical articles and opinions from selected SQL Server publishers. Check Microsoft documentation before making version, security, or support decisions.
dbo.sp_ask_ai — technical description Purpose sp_ask_ai is a synchronous T-SQL wrapper around the async ask_ai chat pipeline. It lets a caller in plain SQL — SSMS, sqlcmd , an Agent job, a bench scrip...
Performance
Dealing With DDL and CDC Chapters 00:00:00 – Introduction 00:01:28 – Script Overview and Problems 00:04:05 – DDL History Table and CDC Tables 00:06:37 – Handling New Capture Instances 00:09:00 – Backf...
Performance
Wanna play some Texas Hold ‘Em style poker and make a pile of Query Bucks? Wanna watch other database people playing? The post sp_TexasHoldEm: Multi-Player Poker in T-SQL appeared first on SQLServerCe...
Development
Is it possible to upgrade from the SQL Server 2019 Standard (non-developer) to the SQL Server 2025 Standard Developer edition? submitted by /u/Sufficient-Pace7542 [link] [comments]
SQL Server releases
Ten years ago, I published a blog post with the top 10 most highly upvoted requests for Microsoft SQL Server as shown on their feedback site at the time, Connect.Microsoft.com. That site has gone out...
Performance
SQL Server Performance Office Hours Episode 74 To ask your questions, head over here. Chapters 00:00:00 – Introduction 00:03:15 – Query Store Basics 00:06:28 – Query Store Configuration 00:09:47 – Per...
Performance
Hey guys, I started a local WoW server just for myself using SQL on an SSD. I saw some information that it could kill my SSD faster. Should I be worried? Or can I just play without worrying? submitted...
Administration
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 .
Performance
A T-SQL veteran's wish list: 9 missing SQL Server features that would simplify auditing, data validation, graph queries, and error handling.… The post 9 things I wish SQL Server had (and why they’d ma...
Development
CVE-2026-47295 is a SQL Server vulnerability that lets a maliciously crafted database backup execute attacker-controlled code with sysadmin privileges during a routine RESTORE DATABASE operation. The...
Security & servicing
Introduction When designing the tables or writing the stored procedures in SQL Server, we get easily tempted to choose the path of least resistance. When deciding how much space to allocate for a text...
Development
This week, I’m back in Vegas, spending time in the home bar to recover from jet lag. I’m not saying booze is the best way to recover – but – it helps me fall asleep after a 16-hour-time-zone-jump, and...
Performance
