On April 11, 2024, Microsoft released SQL Server 2019 Cumulative Update 26. This is Build 15.0.4365.2 By Microsoft’s count, there are 19 public fixes or improvements in this CU, so it has a about an average number of fixes and improvements. This CU is once again on time (based on Microsoft’s public guidance about how SQL Server is serviced), so kudos to Microsoft for staying on schedule for this CU. This CU also has the security fixes from the CU25 + GDR release from April 9, 2024. It is always a good idea to read through the CU KB article to see more information about each fix and improvement ..read more

On April 9, 2024, Microsoft released SQL Server 2019 CU25 + GDR. This is Build 15.0.4360.2. By Microsoft’s count, there are 2 security fixes in this GDR. As usual, this GDR is being pushed out by Microsoft Update. Also as usual, I have updated the SQL Server 2019 version of my SQL Server Diagnostic Information Queries to cover this. It is always a good idea to read through the GDR KB article to see more information about each fix. This will help you decide whether to push your organization to get the latest CU + GDR deployed or not. I have a blog post that might help you with this argument: W ..read more

Introduction These are my SQL Server Diagnostic Information Queries for April 2024, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration and performance of your SQL Server instance in a relatively short amount of time. This post is about my SQL Server Diagnostic Information Queries for April 2024. There are separate versions of these T-SQL queries for SQL Server 2005 through SQL Server 2022. Please make sure you download and use the appropriate T-SQL script for your version of SQL Server. SQL Server Diagnostic Information Queries for April 2024 I ..read more

On March 14, 2024, Microsoft released SQL Server 2022 Cumulative Update 12. This is Build 16.0.4115.5. By Microsoft’s count, there are 50 public fixes and improvements in this CU, so it has an above average number of fixes. This is not unexpected since SQL Server 2022 has been out for a over a year now. It is always a good idea to read through the CU KB article to see more information about each fix and improvement. There are a number of interesting fixes and improvements in this CU. Personally, I think most organizations are far better off being on the “CU Train” rather than the “GDR Train ..read more

Introduction These are my SQL Server Diagnostic Information Queries for March 2024, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration and performance of your SQL Server instance in a relatively short amount of time. This post is about my SQL Server Diagnostic Information Queries for March 2024. There are separate versions of these T-SQL queries for SQL Server 2005 through SQL Server 2022. Please make sure you download and use the appropriate T-SQL script for your version of SQL Server. SQL Server Diagnostic Information Queries for March 2024 I ..read more

On February 15, 2024, Microsoft released SQL Server 2019 Cumulative Update 25. This is Build 15.0.4355.3 By Microsoft’s count, there are 14 public fixes or improvements in this CU, so it has a lower than average number of fixes. This CU is once again on time (based on Microsoft’s public guidance about how SQL Server is serviced), so kudos to Microsoft for staying on schedule for this CU. It is always a good idea to read through the CU KB article to see more information about each fix and improvement. This will help you decide whether to push your organization to get the latest CU deployed or n ..read more

Introduction These are my SQL Server Diagnostic Information Queries for February 2024, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration and performance of your SQL Server instance in a relatively short amount of time. This post is about my SQL Server Diagnostic Information Queries for February 2024. There are separate versions of these T-SQL queries for SQL Server 2005 through SQL Server 2022. Please make sure you download and use the appropriate T-SQL script for your version of SQL Server. SQL Server Diagnostic Information Queries for Februar ..read more

On January 11, 2024, Microsoft released SQL Server 2022 Cumulative Update 11. This is Build 16.0.4105.2. By Microsoft’s count, there are 16 public fixes and improvements in this CU, so it has an average number of fixes. This is not unexpected since SQL Server 2022 has been out for a little over a year now. It is always a good idea to read through the CU KB article to see more information about each fix and improvement. There are several interesting fixes in this CU. This eleventh SQL Server 2022 CU is once again “on-time” (based on Microsoft’s public guidance about how SQL Server is serviced ..read more

Introduction On January 10, 2024, Microsoft released SQL Server Management Studio (SSMS) 19.3. You can download it here. The release notes are here. This means that SSMS 19.3 Is Available. I think the primary motivation for this “surprise” release is security related. The fix described below was also in an out-of-band GDR release for SQL Server 2022 CU10. It is also included in SQL Server 2022 CU11. Update to Microsoft.Data.SqlClient 3.1.5 to address CVE-2024-0056 If you are using a modern version of SQL Server in any capacity, you are going to want SSMS 19.3. This includes “r ..read more

Introduction These are my SQL Server Diagnostic Information Queries for January 2024, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration and performance of your SQL Server instance in a relatively short amount of time. This post is about my SQL Server Diagnostic Information Queries for January 2024. There are separate versions of these T-SQL queries for SQL Server 2005 through SQL Server 2022. Please make sure you download and use the appropriate T-SQL script for your version of SQL Server. SQL Server Diagnostic Information Queries for January 2 ..read more