SQL Server 2012: The Database Engine
Enroll to our SQL Server 2019 FULL course on Udemy (with discount) - https://www.sqlnethub.com/go/course-s...
SQL Server 2012 shipped with a plethora of useful new features. In this webcast we will see the majority of the Database Engine features.
We are going to see enhancements that fall into the following SQL Server areas:
High Availability
Manageability Enhancements
Programmability
Performance & Scalability
Security
The webcast is full of live demos showing how the DBA/Developer can easily use the new features of SQL Server 2012 and be more productive with even less effort!
Also, feel free to check our online course "SQL Server 2019: What's New" and learn all about SQL Server 2019 and SSMS 18.0.
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 on Udemy (with discount) - https://www.sqlnethub.com/go/course-s...
---
Subscribe to SQLNetHub TV! http://bit.ly/Rk7abL
© 2008-2019 Artemakis Artemiou, SQLNetHub
All rights reserved.