SQL Server 2019 Cumulative Update 26
Glenn's SQL Server Performance Blog
by Glenn Berry
3d ago
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
Visit website
SQL Server 2019 CU 25 + GDR
Glenn's SQL Server Performance Blog
by Glenn Berry
5d ago
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
Visit website
SQL Server Diagnostic Information Queries for April 2024
Glenn's SQL Server Performance Blog
by Glenn Berry
1w ago
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
Visit website
SQL Server 2022 Cumulative Update 12
Glenn's SQL Server Performance Blog
by Glenn Berry
1M ago
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
Visit website
SQL Server Diagnostic Information Queries for March 2024
Glenn's SQL Server Performance Blog
by Glenn Berry
1M ago
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
Visit website
SQL Server 2019 Cumulative Update 25
Glenn's SQL Server Performance Blog
by Glenn Berry
1M ago
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
Visit website
SQL Server Diagnostic Information Queries for February 2024
Glenn's SQL Server Performance Blog
by Glenn Berry
2M ago
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
Visit website
SQL Server 2022 Cumulative Update 11
Glenn's SQL Server Performance Blog
by Glenn Berry
2M ago
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
Visit website
SSMS 19.3 Is Available
Glenn's SQL Server Performance Blog
by Glenn Berry
3M ago
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
Visit website
SQL Server Diagnostic Information Queries for January 2024
Glenn's SQL Server Performance Blog
by Glenn Berry
3M ago
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
Visit website

Follow Glenn's SQL Server Performance Blog on FeedSpot

Continue with Google
Continue with Apple
OR