Category: SQL Server 2019
A new build is available for SQL Server 2019 (GDR = 15.0.2095.3, CU = 15.0.4236.7). From the CVE: "An authenticated attacker could exploit the vulnerability by executing a specially crafted query using $ partition against a table with a Column Store index."
SQL Server 2019 Cumulative Update #16 is available, with 47 enhancements. The build number is 15.0.4223.1.
SQL Server 2019 Cumulative Update #15 is available, with 39 enhancements (35 public). The build number is 15.0.4198.2.
SQL Server 2019 Cumulative Update #14 is available, with 38 enhancements (19 public). The build number is 15.0.4188.2.
SQL Server 2019 Cumulative Update #13 is available, with 38 enhancements (19 public). The build number is 15.0.4178.1.
SQL Server 2019 Cumulative Update #12 is available, with 40 enhancements (29 public). The build number is 15.0.4153.1.
In this tip, I show how you can evaluate a new index option in SQL Server 2019 aimed at reducing PAGELATCH_EX waits: OPTIMIZE_FOR_SEQUENTIAL_KEY.
After thinking setting up SQL Server 2019 on CentOS 7.5 was going to be a piece of cake, I explain how my team helped resolve a TLS issue preventing remote connections.
SQL Server 2019 Cumulative Update #11 is available, with 62 enhancements. The build number is 15.0.4138.2.
SQL Server 2019 Cumulative Update #10 is available, with 63 enhancements. The build number is 15.0.4123.1.
SQL Server 2019 Cumulative Update #9 is available, with 140 enhancements. The build number is 15.0.4102.2.
SQL Server 2019 Cumulative Update #8 is available, with 104 enhancements. The build number is 15.0.4073.23.
I like to encourage people to always be on the latest Cumulative Update, but lately my confidence has been eroding. The latest patch for SQL Server 2019 hasn't helped.
SQL Server 2019 Cumulative Update #7 is available, with 56 enhancements. The build number is 15.0.4063.15.
SQL Server 2019 Cumulative Update #6 is available, with 51 enhancements. The build number is 15.0.4053.23.
SQL Server 2019 Cumulative Update #5 is available, with 86 enhancements. The build number is 15.0.4043.16.
See how to work around some of the blockers for replacing legacy UDFs with STRING_SPLIT.
Cumulative Updates for SQL Server 2019, SQL Server 2017, and SQL Server 2016 SP2 have been pushed back a month or more due to our current health crisis.
SQL Server 2019 Cumulative Update #4 is available, with 50 enhancements. The build number is 15.0.4033.1.
SQL Server 2019 Cumulative Update #3 is available, with 56 enhancements. The build number is 15.0.4023.6.
In this tip, I show how to measure the positive effects of delayed durability, in cases where a small amount of data loss is acceptable.