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.
Category: SQL Server 2019
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.