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
Introduction
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
Conclusion
24 Next steps
Resolve the captcha to access the links!