SQL Server 2019 Cumulative Update #17
SQL Server 2019 Cumulative Update #17 is available, with 43 enhancements. The build number is 15.0.4249.2.
Category: SQL Server 2019
SQL Server 2019 Security Update, June 2022
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
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
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
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
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
SQL Server 2019 Cumulative Update #12 is available, with 40 enhancements (29 public). The build number is 15.0.4153.1.
Minimizing PAGELATCH_EX waits in SQL Server 2019
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.
SQL Server 2019 Adventures on CentOS 7.5
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
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
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
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
SQL Server 2019 Cumulative Update #8 is available, with 104 enhancements. The build number is 15.0.4073.23.
Avoid SQL Server 2019 Cumulative Update #7
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
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
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
SQL Server 2019 Cumulative Update #5 is available, with 86 enhancements. The build number is 15.0.4043.16.
Replace legacy splitting functions with STRING_SPLIT
See how to work around some of the blockers for replacing legacy UDFs with STRING_SPLIT.
SQL Server Cumulative Updates Delayed
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
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
SQL Server 2019 Cumulative Update #3 is available, with 56 enhancements. The build number is 15.0.4023.6.