SQL Server 2019 Cumulative Update #8
SQL Server 2019 Cumulative Update #8 is available, with 74 enhancements. The build number is 15.0.4073.23.
Category: SQL Server 2019
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.
Measure Delayed Durability impact in SQL Server 2016 and later
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
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.
SQL Server 2019 Cumulative Update #1
SQL Server 2019 Cumulative Update #1 is now available, with 83 fixes and improvements. Build # is 15.0.4003.23.
A simple use case for columnstore indexes
In this tip, I show how and why a columnstore index can provide benefits to COUNT(*) queries.
Introducing Big Data Clusters and SQL Server 2019
Let's talk a bit about the launch of SQL Server 2019 and the flagship, bet-the-farm feature: Big Data Clusters.
SQL Server 2019 Installation Enhancements
I talk a little bit about two big enhancements for SQL Server 2019: installation options for setting MAXDOP and Max Server Memory.
Memory-Optimized TempDB Metadata
Get a quick overview of a powerful new feature in SQL Server 2019 that will drastically improve certain tempdb-heavy workloads.
PASS Summit 2019 Keynote – Day 1
See the highlights from the first-day keynote at PASS Summit 2019 in Seattle.
Thoughts on SQL Server 2019 Editions
I share some thoughts about the upcoming SQL Server 2019 release and edition-specific features.
Impact of UTF-8 support in SQL Server 2019
I take a quick look at the performance and storage impact of the new UTF-8 collations in SQL Server 2019.
Accelerated Database Recovery in SQL Server 2019
Get a quick overview of one of the most important features in SQL Server 2019.
Scalar UDF Inlining in SQL Server 2019
Read a quick overview Scalar UDF Inlining, a long-awaited feature in SQL Server 2019 that will improve the performance of some workloads.