SQL Server 2019 Cumulative Update #3 is available, with 56 enhancements. The build number is 15.0.4023.6.
Category: 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.
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 is now available, with 83 fixes and improvements. Build # is 15.0.4003.23.
In this tip, I show how and why a columnstore index can provide benefits to COUNT(*) queries.
Let's talk a bit about the launch of SQL Server 2019 and the flagship, bet-the-farm feature: Big Data Clusters.
I talk a little bit about two big enhancements for SQL Server 2019: installation options for setting MAXDOP and Max Server Memory.
Get a quick overview of a powerful new feature in SQL Server 2019 that will drastically improve certain tempdb-heavy workloads.
See the highlights from the first-day keynote at PASS Summit 2019 in Seattle.
I share some thoughts about the upcoming SQL Server 2019 release and edition-specific features.
I take a quick look at the performance and storage impact of the new UTF-8 collations in SQL Server 2019.
Get a quick overview of one of the most important features 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.
I provide my deck and demos for a GroupBy presentation on SQL Server 2019, and make up for some serious demo disasters.
This new approximate function may not cut down on execution time, but it relieves a whole lot of memory pressure.
Some of your gnarly scalar UDFs will stop being in the naughty book when they can be inlined.
New first class citizen in SQL Server 2019 that will help you identify and audit sensitive information.
This new function eliminates some of the tedious legwork you might find yourself doing with DBCC PAGE.