SQL Server 2019

SQL Server 2019 adventures on CentOS 7.5

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.

Measure Delayed Durability impact

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.

Introducing Big Data Clusters

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: Setup 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.

Scalar UDF inlining

Read a quick overview Scalar UDF Inlining, a long-awaited feature in SQL Server 2019 that will improve the performance of some workloads.

Exploring scalar UDF inlining

Some of your gnarly scalar UDFs will stop being in the naughty book when they can be inlined.