SQL Server 2019 – SQLBlog.org

SQL Server 2019 Cumulative Update #13

Aaron Bertrand October 5th, 2021 SQL Server / SQL Server 2019

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

Aaron Bertrand August 4th, 2021 SQL Server / SQL Server 2019

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

Aaron Bertrand July 23rd, 2021 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

Aaron Bertrand June 24th, 2021 SQL Server / SQL Server 2019

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

Aaron Bertrand June 10th, 2021 SQL Server / SQL Server 2019

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

Aaron Bertrand April 7th, 2021 SQL Server / SQL Server 2019

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

Aaron Bertrand February 11th, 2021 SQL Server / SQL Server 2019

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

Aaron Bertrand October 1st, 2020 SQL Server / SQL Server 2019

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

Aaron Bertrand September 25th, 2020 SQL Server 2019

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

Aaron Bertrand September 2nd, 2020 SQL Server / SQL Server 2019

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

Aaron Bertrand August 4th, 2020 SQL Server / SQL Server 2019

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

Aaron Bertrand June 22nd, 2020 SQL Server / SQL Server 2019

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

Aaron Bertrand June 1st, 2020 SQL Server 2016 / SQL Server 2017 / SQL Server 2019

See how to work around some of the blockers for replacing legacy UDFs with STRING_SPLIT.

SQL Server Cumulative Updates Delayed

Aaron Bertrand May 13th, 2020 SQL Server 2016 / SQL Server 2017 / SQL Server 2019

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

Aaron Bertrand March 31st, 2020 SQL Server 2019

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

Aaron Bertrand March 13th, 2020 SQL Server 2019

SQL Server 2019 Cumulative Update #3 is available, with 56 enhancements. The build number is 15.0.4023.6.

Measure Delayed Durability impact in SQL Server 2016 and later

Aaron Bertrand March 4th, 2020 SQL Server 2016 / SQL Server 2017 / SQL Server 2019

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.

SQL Server 2019 Cumulative Update #2

Aaron Bertrand February 14th, 2020 SQL Server 2019

It's a few days later than many of us were expecting, but Cumulative Update #2 for SQL Server 2019 (15.0.4013.40) is overflowing with 134 fixes and enhancements.