Microsoft SQL Server 2019: New Features

Learn about the new and improved features in SQL Server 2019, including support for big data clusters and machine learning services.

Introduction

• What's new in SQL Server 2019
• Make the most of the exercise files
• What you should know

1. Database Engine Enhancements

• Intelligent Query Processing
• Improvements to persistent memory
• Secure enclaves
• Resumable online index create
• UTF-8 support
• Certification management
• Always On availability groups

2. Table Virtualization with PolyBase

• PolyBase connections
• Scale-out groups

3. Big Data Clusters

• Create a unified data cluster
• SQL Server, Apache Spark, and HDFS
• Train and create machine learning models
• Big data tools

4. Beyond Windows

• Updates to Linux installations
• Running SQL Server in containers

5. Machine Learning Services

• Enhancements to MLS

6. Updates to SSMS

• Management Studio 18.0
• Integration with Azure Data Studio
• Query Tuning Assistant
• SQL Data Discovery and Classification

Conclusion

• Next steps