NORTH - SQL Server 2019 New Features - Mike Burek

There are many new features and enhancements in SQL Server 2019. We'll go over bullet points of some features, some benefits, and run through a few demos.

• Polybase enhancements
• SQL Graph enhancements
• Linux SQL Server enhancements
• Persistent Memory
• Data Discovery and Classification
• Always On Availability Groups enhancements
• Transaction log enhancements
• Data Masking enhancements
• Compression enhancements
• Always Encrypted enhancements
• Index enhancements
• Query Hint enhancements
• Error Message enhancements
• Scalar Function enhancements
• Table Variable enhancements
• Memory Grant enhancements
• Query enhancements
• Data estimations
• UTF-8 Support

Demos:

• Scalar Function enhancements
• Memory Grant enhancements
• Table Variable enhancements