New Engine Features in SQL Server 2019 by Aaron Bertrand

A new release of SQL Server is like a new season of your favorite TV show. Some releases in the past were lacking; I always felt like SQL Server 2008 R2 was about as exciting as the Seinfeld finale. But Microsoft hasn't disappointed in recent years, and SQL Server 2019 is no exception. There are some really exciting features here. Some are big-ticket items, like support for Secure Enclaves, which provide all the benefits of Always Encrypted but without the client round trips. Others are smaller but powerful improvements, like deferred table variable compilation, and better error messages. Some are in between, like enhancements to batch mode, more online operations, and query hints to target specific compatibility levels. With plenty of demos, I'll show how these features will improve your performance, security, workflow, or all three. And when necessary, I'll point out pitfalls or gotchas that you won't find in the official documentation. These and many other features are worth talking about, so let's talk about them!

You can listen to New Engine Features in SQL Server 2019 by Aaron Bertrand online on Radio and Podcast. Open the player on this page to stream the available audio.

New Engine Features in SQL Server 2019 by Aaron Bertrand is an episode from GroupBy – Free SQL Server Training by Brent Ozar.

This episode is 54:09 long.

This episode was published on Jan 8, 2019.

Yes. Use the heart button on the episode page to add it to your favorite episodes list.

Yes. This page shows related episodes from GroupBy – Free SQL Server Training when more episodes are available from the podcast feed.