I recently compared SQL Server system DMVs between SQL Server 2022 (16.0.4225.2) and SQL Server 2025 (17.0.1000.7). I used Redgate SQL Compare to generate an HTML report, and in this post, I’m providing a summary of the changes made, including additions, deletions, and modifications. See the full comparison: SQL_2022_To_2025_DMV_Comparison How…
When I migrated a set of linked servers from SQL Server 2022 to SQL Server 2025, a few of them started failing immediately during connection initialization. The root cause surprised me at first: SQL Server 2025 tightens the encryption defaults for linked servers, so a linked server that worked fine…
I recently encountered a deployment failure when provisioning a new SQL Server 2025 VM based on a Windows Server 2025 image in Azure. The VM size was E2ds_v6, which includes ~110 GB local storage (NVMe / ephemeral). The deployment failed during provisioning with this error: { “status”: “Failed”, “error”: {…
SQL Server 2025: Web Edition Is Gone
4. 1. 2026
As a SQL Server DBA, I usually don’t panic about licensing changes — but the removal of SQL Server Web Edition in SQL Server 2025 is one of those changes that immediately hit a real production project I’m responsible for.Web Edition has been the quiet workhorse for years: small web…
SET STATISTICS PROFILE
17. 6. 2024
SQL Server provides various tools and commands to help database administrators and developers analyze and optimize query performance. One of these commands is SET STATISTICS PROFILE. This command is particularly useful for obtaining a detailed execution plan along with the runtime statistics of a query, which can be invaluable for…
Temporary Stored Procedures
14. 5. 2024
Few people know that it is possible to create temporary stored procedures in SQL Server. I often ask about this when recruiting new candidates, and 9 out of 10 ask if I meant temporary tables, or if they start talking about them right away. So yes, we can indeed create…
SQL Server, like many relational database management systems, has specific limitations that developers need to be aware of when designing and implementing database solutions. One such limitation is the maximum number of expressions that can be specified in the SELECT list of a query. This limit is set at 4096…
Understanding Sparse Columns
9. 4. 2024
Sparse columns in SQL Server are an intriguing feature designed to optimize storage for columns that contain a significant amount of NULL values. Introduced in SQL Server 2008, sparse columns offer a way to store nulls efficiently, consuming no storage space for NULL values in a column. This feature can…
DBCC CHECKIDENT RESEED behaves differently when TRUNCATE or DELETE was used on the table
28. 12. 2021
Let’s assume we have some script where tables are filled with data and then DELETED/TRUNCATED again to rerun the script. Some of these tables are large and they don’t have a foreign key reference so we will decide to use TRUNCATE to remove the data. For tables referenced by foreign…
This article is just a simple demonstration of improvements in scalar functions handling implemented in SQL Server 2019. Prior to this version when the scalar function was used in a query, it was blocking parallel plan generation. You can read more on this topic in this article. One of the…