SQL Server 2019 Cumulative Update 25
Glenn's SQL Server Performance Blog
by Glenn Berry
1w 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
3w 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
1M 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
1M 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
2M 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
Upgrade Your PC Storage!
Glenn's SQL Server Performance Blog
by Glenn Berry
2M ago
Introduction Over the past six months or so, the retail cost of NAND client SSD storage has plummeted. For most client machines this primarily affects M.2 PCIe NVMe SSDs and 2.5″ SATA SSDs. The price per gigabyte of storage space has gone down dramatically, to about 70-90 cents/GB. Because of this, it is time to Upgrade Your PC Storage! The main reason there is some urgency here is because NAND prices are forecasted to rise in 2024. Another reason is that there are still a lot of holiday-related sale prices that you can take advantage of right now. If you wait too long, you will be paying more ..read more
Visit website
SQL Server Diagnostic Information Queries for December 2023
Glenn's SQL Server Performance Blog
by Glenn Berry
3M ago
Introduction These are my SQL Server Diagnostic Information Queries for December 2023, 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 December 2023. 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. I also have separate versions for Azure SQL Managed I ..read more
Visit website
SSMS 19.2 Is Available
Glenn's SQL Server Performance Blog
by Glenn Berry
3M ago
Introduction On November 13, 2023, Microsoft released SQL Server Management Studio (SSMS) 19.2. You can download it here. The release notes are here. This means that SSMS 19.2 Is Available. If you are using a modern version of SQL Server in any capacity, you are going to want SSMS 19.2. This includes “regular” SQL Server, Azure SQL Managed Instance, Azure SQL Database, Azure Synapse Analytics and Microsoft Fabric. SSMS 19.2 is fully aware of SQL Server 2022, and it is also officially supported on SQL Server 2014 and newer. It will probably mostly work on older versions of SQL Server, but I ha ..read more
Visit website
Gaming the Electric Grid – PV Solar
Glenn's SQL Server Performance Blog
by Glenn Berry
3M ago
Introduction The second post in this series, Gaming the Electric Grid – PV Solar will cover my experiences with residential grid-tied PV solar systems as a homeowner over the past fourteen years. Over that time, I’ve had two solar PV systems installed in two different houses, and I think I have learned quite a bit about how they actually work in real life. One thing you should do before you even think about getting a residential grid-tied PV solar system is to have an energy audit done on your house. Many utility companies offer free or subsidized energy audits that will give you a list of cha ..read more
Visit website
Azure Data Studio 1.47
Glenn's SQL Server Performance Blog
by Glenn Berry
4M ago
On November 8, 2023, Microsoft released Azure Data Studio 1.47. The release notes are here. According to Microsoft, some of the highlights of this release include: Azure AD is becoming Microsoft Entra ID We have updated the name in Azure Data Studio but everything else stays the same. Parallel message processing is enabled by default This should make ADS much snappier when connected to SQL Server data sources. Excel formatting options Save time by defining standard formatting options when saving to Excel. Upstream improvements from Visual Studio Code 1.80, 1.81, and 1.82 Improved ex ..read more
Visit website

Follow Glenn's SQL Server Performance Blog on FeedSpot

Continue with Google
Continue with Apple
OR