SQL Server Evolution Over the Years
Enroll to the FULL course (with discount): https://www.sqlnethub.com/go/course-s...
You are watching the second lecture of our online course "SQL Server 2019: What's New".
More specifically, the “SQL Server 2019: What’s New” course, focuses on the below areas:
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
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 with 15 questions, that will help you test your knowledge on SQL Server 2019.
Enroll to the FULL course (with discount): https://www.sqlnethub.com/go/course-s...
© Artemakis Artemiou, SQLNetHub
All rights reserved.