I provide my deck and demos for a GroupBy presentation on SQL Server 2019, and make up for some serious demo disasters.
Category: SQL Server 2019
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.