New Features in SQL Server 2016

New Features in SQL Server 2016

Audience

Experienced database administrators and developers who plan to upgrade to SQL Server 2016, or are just interested in the new features and need to evaluate the benefits of upgrading to the latest version.

Prerequisites

Good knowledge of SQL Server 2012 / 2008 administration or development.

Duration

2 days. Hands on.

This course is available on site only. Please call for details.

Course Objectives

Delegates will learn what the new features of SQL Server 2016 are, and how these innovations will help them to do their daily work better, faster and more reliably. They will also learn new ways of scaling performance of SQL Server and its components.

Upon successful completion of this course, delegates will be able to:

  • Appreciate key capabilities and components of SQL Server 2016
  • Appreciate new and enhanced features in SQL Server performance and security
  • Appreciate what's new in SQL Server Availability and Scalability
  • Appreciate new and enhanced features in reporting and PowerBI in SQL Server 2016
  • Appreciate new and enhanced data access features
  • Appreciate new and enhanced features in SQL Server OLAP
  • Appreciate new SQL Server cloud functionality

Course Contents

Introduction to SQL Server 2016
Overview of SQL Server 2016
SQL Server 2016 Editions and Components
Installing SQL Server 2016
SQL Server Management Studio Enhancements

New Features in SQL Server Performance
Columnstore Indexes for Operational Analytics
In-memory OLTP Enhancements
The Query Data Store
Native JSON
Temporal Tables

New Features in SQL Server Security
Using Always Encrypted
Row-level Security
Dynamic Data Masking

New Features in SQL Server Availability and Scalability
Enhanced AlwaysOn Availability Groups
What's New in Database Caching?
Using Windows Server 2016

New Features in SQL Server Reporting and BI
Reporting Services Enhancements
PowerBI Enhancements

New Features in SQL Server Data Access
PolyBase
Enhancements to Integration Services

New and Enhanced Features in SQL Server OLAP
New and Enhanced Features in SQL Server OLAP
What's New in SQL Server Analysis Services

New Features for SQL Server in the Cloud
Stretch Database
Enhanced Backups to Azure
Introduction to SQL Server 2016 Hybrid Cloud
What's New in SQL Server Azure Database

On-Site Courses

Can't attend one of our public classes? Booking for multiple people?

All our courses are available on your site! Delivered for your staff, at your premises.

Contact us to find out more...