In this tip, I show how to evaluate a new index option in SQL Server 2019 aimed at reducing PAGELATCH_EX waits.

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.

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

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.

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.

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.

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.