What's New in SQL Server 2016 for DBAs and Devs

SQ-NEW2016-EN Learn about new features in SQL Server 2016.

}

Duration: 2 days

Level: 300

What does this course cover?

In this two-days course we introduce the most important Features of SQL Server 2016 and Focus on the usability and relevance for the real-life.

Agenda:

  • Installation
    • Changes
    • Management Studio
    • Upgrade Advisor
  • Database Engine Feature Enhancements
    • Stretch Database
    • Live Query Statistics
    • Backup to Microsoft Azure and Managed Backup
    • Trace flag 4199
    • TempDB enhancements
    • Database Scoped Configurations
    • New and updated System Views
  • Temporal Tables
  • Query Store
  • Transact-SQL Enhancements
    • Built-in JSON Support
    • PolyBase
    • SQL Server R Services
    • Other language Enhancements
  • Columnstore Indexes
    • updateable nonclustered columnstore indexes
    • columnstore indexes on in-memory tables
    • other improvements
  • In-Memory OLTP
    • Improvements and new Features
  • Security Enhancements
    • Row-Level Security
    • Always Encrypted
    • Dynamic Data Masking
    • New Permissions
    • Transparent Data Encryption
    • AES Encryption for Endpoints
    • Database Scoped Credentials
  • High Availability Enhancements

“Herbert Albert knows what he is talking about!”

WHEN and WHERE is this course running?