Microsoft SQL Server 2019: New Features

Microsoft SQL Server 2019: New Features
Microsoft SQL Server 2019: New Features
English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1h 07m | 143 MB

SQL Server 2019 offers a number of performance enhancements and new features, including support for big data clusters and machine learning services. In this course, Adam Wilbert helps you get up to speed with the latest and greatest in the powerful relational database management system. Learn about database engine enhancements, including improvements to persistent memory and UTF-8 support. Adam also goes over table virtualization with PolyBase, training and creating machine learning models, how Apache Spark and the Hadoop Distributed File System (HDFS) now work together in SQL Server, and other changes that are coming with the 2019 release.

Topics include:

  • Intelligent query processing
  • Improvements to persistent memory
  • Table virtualization with PolyBase
  • Creating a unified data cluster
  • Training and creating machine learning models
  • Running SQL Server in containers
  • Updates to the SQL Server Management Studio (SSMS)
Table of Contents

1 What’s new in SQL Server 2019
2 Make the most of the exercise files
3 What you should know

Database Engine Enhancements
4 Intelligent Query Processing
5 Improvements to persistent memory
6 Secure enclaves
7 Resumable online index create
8 UTF-8 support
9 Certification management
10 Always On availability groups

Table Virtualization with PolyBase
11 PolyBase connections
12 Scale-out groups

Big Data Clusters
13 Create a unified data cluster
14 SQL Server, Apache Spark, and HDFS
15 Train and create machine learning models
16 Big data tools

Beyond Windows
17 Updates to Linux installations
18 Running SQL Server in containers

Machine Learning Services
19 Enhancements to MLS

Updates to SSMS
20 Management Studio 18.0
21 Integration with Azure Data Studio
22 Query Tuning Assistant
23 SQL Data Discovery and Classification

24 Next steps