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……

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:…

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 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: Transact-SQL SELECT TOP 101 *…

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…

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…

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. Instead, all SQL Server 2025 customers will get free licensing for the on-premises Power BI Report Server (PBIRS.) The same license key you use to install 2025 will also work to…

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,…

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…

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…

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,…

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,…

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…