Introduction to SQL Server 2016
Describe key capabilities and components of SQL Server 2016.
· Overview of SQL Server 2016
· SQL Server 2016 Editions and Components
· Installing SQL Server 2016
· SQL Server Management Studio Enchancements
What’s New in SQL Server Performance
This modul describes new and enhanced features in SQL Server Performance.
· Columnstore Indexes for Optional Analytics
· In-memory OLTP Enhancements
· The Query Data Store
· Native JSON
· Temporal Tables
What’s New in SQL Server Security?
This modul describes new and enchanced features in SQL Server security.
· Using Always Encrypted
· Row-level Security
· Dynamic Data Masking
What’s New in SQL Server Availability and Scalability?
This modul introduces what’s new in SQL Server Availability and Scalability.
· Enhanced AlwaysOn Availbility Groups
· What’s New in Database Caching?
· Using Windows Server 2016
What’s New for SQL Server in the Cloud?
This modul describes new SQL Server cloud functionality.
· Stretch Database
· Enhanced Backups to Azure
· Introduction to SQL Server 2016 Hybrid Cloud
· What’s New in SQL Server Azure