See the highlights from the first-day keynote at PASS Summit 2019 in Seattle.
Category: SQL Server 2019
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.