Get a quick overview of one of the most important features in SQL Server 2019.
Category: 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.