LIN | Microsoft SQL Server 2019: New Features (2019 EN)

Discussion in 'Information Technology' started by Kanka, Jul 29, 2019.

Tags:
0/5,
  1. Kanka

    Kanka Well-Known Member Loyal User

    Messages:
    16,053
    Likes Received:
    449
    Trophy Points:
    83
    [​IMG]

    Company: Linkedin Learning
    Author: Adam Wilbert
    Full Title: Microsoft SQL Server 2019: New Features
    Year: 2019
    Language: English
    Genre: Educational: Databases
    Skill Level: Intermediate
    Price: €24.99
    -
    Files: MP4 (+ Exercise Files, Subtitles .SRT)
    Time: 01:07:56
    Video: AVC, 1280 x 720 (1.778) at 30.000 fps, 150 kbps
    Audio: AAC at 128 Kbps, 2 channels, 48.0 KHz



    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.


    Lessons:
    1. Introduction
    01. What's new in SQL Server 2019
    02. Make the most of the exercise files
    03. What you should know
    2. Database Engine Enhancements
    04. Intelligent Query Processing
    05. Improvements to persistent memory
    06. Secure enclaves
    07. Resumable online index create
    08. UTF-8 support
    09. Certification management
    10. Always On availability groups
    3. Table Virtualization with PolyBase
    11. PolyBase connections
    12. Scale-out groups
    4. 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
    5. Beyond Windows
    17. Updates to Linux installations
    18. Running SQL Server in containers
    6. Machine Learning Services
    19. Enhancements to MLS
    7. Updates to SSMS
    20. Management Studio 18.0
    21. Integration with Azure Data Studio
    22. Query Tuning Assistant
    23. SQL Data Discovery and Classification
    8. Conclusion
    24. Next steps


    -------------
     
    Kanka, Jul 29, 2019
    #1