New Online Course – SQL Server 2019: What’s New

Hi there! I’m proudly announcing the general availability of my new online course titled: “SQL Server 2019 – What’s New (New and Enhanced Features)“!


What will I learn in this course?

In this course, you can learn in an interactive and efficient way, about all the major new features and enhancements in SQL Server 2019 categorized as per below categories:

  • About SQL Server 2019 and SSMS 18.0
    • SQL Server evolution over the years and major features
    • System requirements of SQL Server 2019 and installation (with live demonstration)
    • System requirements for SSMS v18.0 and installation (with live demonstration)
  • Performance
    • Performance enhancements
      • Intelligent Query Processing (with live demonstrations)
        • Batch mode on row store
        • Row mode memory grant feedback
        • Table variable deferred compilation
        • Approximate COUNT DISTINCT
        • Scalar UDF inlining
      • Expanded Support for Persistent Memory Devices
      • Hybrid Buffer Pool
      • Columnstore Statistics in DBCC CLONEDATABASE
      • Lightweight Query Profiling Infrastructure
  • Security and Compliance
    • Security and Compliance Enhancements (with live demonstrations)
      • Always Encrypted with Secure Enclaves
      • Data Discovery and Classification
      • Certificate Management in SQL Server Configuration Manager
      • Vulnerability Assessment
  • High Availability
    • High Availability enhancements
      • Enhancements for Availability Groups
      • High Availability with Remote Storage On Kubernetes
      • Online Operations
  • Development
    • Development-related enhancements (with live demonstrations)
      • UTF-8 Support
      • Java Language Programmability Extension
  • Other Enhancements
    • Other significant enhancements
      • SQL Server on Linux Enhancements
      • Big Data
      • sp_estimate_data_compression_savings
  • Special Topics
    • About Special Topics
    • New DMF sys.dm_exec_query_plan_stats
    • Transparent Data Encryption (TDE) Scan – Suspend and Resume
    • New Default Truncation Message
  • SQL Server 2019 on Linux
    • How to Install SQL Server 2019 on Ubuntu Linux
    • How to Install and use the SQL Server command-line tools on Ubuntu Linux
    • How to Access SQL Server 2019 on Ubuntu Linux using Azure Data Studio
    • How to Perform an Offline Installation of SQL Server 2019 on Ubuntu Linux

After each section, a quiz follows that will help you test your knowledge on what you’ve learned in that section.

Also, in the end of the course, there is a practice test, that will help you test your knowledge regarding the new and enhanced features in SQL Server 2019 and SSMS 18.0.


Enroll Now with Discount!


What does the course offer?

This course contains/offers:

  • 2.5 hours of high-quality video with live demonstrations
  • Downloadable resources
  • Six useful quizzes for testing your knowledge on each section
  • A practice test in the end of the course
  • Ability to ask the instructor questions related to the course via the Q&A section
  • Certificate on course completion


Course Preview


Enroll Now!

Enroll now to the course with special discount!

Enroll Now with Discount!


Featured Online Courses:


Read Also:


Rate this article: 1 Star2 Stars3 Stars4 Stars5 Stars (4 votes, average: 5.00 out of 5)


Reference: (

© SQLNetHub