There’s a Bug in sys.dm_exec_query_plan_stats.
When you turn on last actual plans in SQL Server 2019 and newer:
[crayon-6a66438daf0fa424579941/]
Category: SQL Server 2025
SQL Server 2025 CU1 is Off to a Rough Start
SQL Server 2025 Cumulative Update 1 came out last week, and I was kinda confused by the release notes. They described a couple dozen fixed issues, and the list seemed really short for a CU1. However, the more I dug into it, the weirder things got. For example, there were several new DMVs added -…
Known Issues So Far in SQL Server 2025
Whenever a brand spankin' new version of any software comes out, there are bugs, and SQL Server is no exception. This has led to a mentality where folks don't wanna install a new version of SQL Server until the first couple of Cumulative Updates come out, hopefully fixing the first big round of bugs.
So... are there bugs this time around?
SQL Server 2025 Is Out, and Standard Goes Up to 256GB RAM, 32 Cores!
Today marks the official birthday of Microsoft SQL Server 2025. Here's where to download the evaluation version. Here are the top things you wanna consider as you talk to your managers, developers, and end users. The feature differences between 2025 Enterprise and Standard have been revealed, and the news for Standard Edition folks is spectacular:…
How to Query JSON Data Quickly in SQL Server, Part 2: SQL Server 2025
SQL Server 2025 and .NET 10 bring several new improvements to storing JSON natively in the database and querying it quickly. On the SQL Server 2025 side, the two big ones are the new native JSON indexes and the new JSON_CONTAINS function. Let's see their improvements in action. On the .NET 10 side, EF 10…
SQL Server 2025 Makes Memory Troubleshooting Easier.
SQL Server 2025 introduces a new sys.dm_os_memory_health_history view to make it easier for meatbags like you and robots like Copilot to know if the SQL Server has been under memory pressure recently.
To show how it works, let's run a bunch of simultaneous high-memory-grant queries in the Stack Overflow database:
SQL Server 2025 RC0 Is Out with New Preview Features Settings
The release of SQL Server 2025 keeps inching closer. Release Candidate 0 is out now, and here are the release notes. If you're planning on replacing your SQL Server 2016 instances (which go out of support next July) with 2025, now would be a good time to start doing functionality testing. As a reminder, here's my post on how to go live on a new SQL Server version.
What’s New (And Undocumented) in SQL Server 2025 CTP 2.1
As the SQL Server 2025 previews continue to come out, Microsoft is making changes that they're not telling you about. Sometimes these changes never actually go into the final production version, other times they're held exclusively for the cloud, but sometimes - just sometimes - we get a sneak peek of something Microsoft hasn't announced…
SQL Server Reporting Services is Dead. Is SSIS Next?
It's official: SQL Server 2022 was the last release for SSRS.
At SQLBits this week, Microsoft announced that SQL Server 2025 won't include SSRS.
How SQL Server 2025’s Optional Parameter Plan Optimization Works
About three years ago, SQL Server 2022 introduced Parameter-Sensitive Plan Optimization (PSPO). At the time, I explained that it didn't work particularly well, and went so far as to pronounce PSPO in a rather unflattering way. I wouldn't suggest that anyone turn it off - it's fine, just fine - but it isn't powerful enough, and poses serious challenges for monitoring and plan cache analysis.
New Objects in SQL Server 2025 – And Thousands of New Undocumented Feature Flags!
The first public preview of SQL Server 2025 dropped yesterday, and here's what's new under the hood as compared to today's SQL Server 2022 CU19. Forgive me - this is quite a lengthy post, and it's mostly a data dump. There are new stored procedures, extended stored procs, views, feature switches, new columns in existing tables, messages, and more.
T-SQL & Development
T-SQL Has Regex in SQL Server 2025. Don’t Get Too Excited.
Regular expressions are a way of doing complex string searches. They can be really useful, but they have a reputation: they're hard to write, hard to read, and they're even harder to troubleshoot. Once you master 'em, though, they come in handy for very specific situations.
This post isn't about their complexity, though. This post is about Azure SQL DB & SQL Server 2025's regex performance.
What’s Coming in SQL Server 2025, DMV Edition
As we approach the first public releases of SQL Server 2025, it's fun to start spelunking through things Azure SQL DB has today - announced and unannounced - that aren't yet present in the boxed product version of SQL Server. Microsoft staff used to say that Azure SQL DB is "the next version" of the…
What’s New in SQL Server 2025
Today at Microsoft Ignite, Microsoft announced SQL Server 2025. The biggest new features focus on AI and bringing the latest Azure SQL DB features down to your own servers. Here are the top features: Call AI services like ChatGPT directly from T-SQL - using T-SQL commands and sp_invoke_external_rest_endpoint Vector searches, a native vector data type,…
I’m Getting Antsy for SQL Server vNext.
Historically, Microsoft publicly announces the next version of SQL Server about a year before it ships. For example:
November 2, 2021, Microsoft announced the private preview of SQL Server 2022.
About 6 months later, on May 24, 2022, they announced the public preview.
About 12 months after the private preview announcement, on November 16, 2022, SQL Server 2022 was generally available.
Contest: Guess the SQL Server 2025 Release Date
When will Microsoft officially release SQL Server 2024 (or 2025, or whatever it'll be) for download? The dust is just barely starting to settle on the 2022 box, so it's time to guess the next one. Leave one – and only one – comment here in YYYY/MM/DD format with your release date guess. If you…
