Learn about the new and improved features in SQL Server 2019, including support for big data clusters and machine learning services.
Overview
Syllabus
Introduction
- What's new in SQL Server 2019
- Make the most of the exercise files
- What you should know
- Intelligent Query Processing
- Improvements to persistent memory
- Secure enclaves
- Resumable online index create
- UTF-8 support
- Certification management
- Always On availability groups
- PolyBase connections
- Scale-out groups
- Create a unified data cluster
- SQL Server, Apache Spark, and HDFS
- Train and create machine learning models
- Big data tools
- Updates to Linux installations
- Running SQL Server in containers
- Enhancements to MLS
- Management Studio 18.0
- Integration with Azure Data Studio
- Query Tuning Assistant
- SQL Data Discovery and Classification
- Next steps
Taught by
Adam Wilbert