SQL Server 2016 New Features for Developers

This course teaches the new developer features in SQL Server 2016, including Drop If Exists (DIE), SESSION_CONTEXT, dynamic data masking (DDM), row-level security (RLS), Always Encrypted, stretch database, temporal data, and built-in JSON support.
Course info
Rating
(90)
Level
Intermediate
Updated
Oct 14, 2016
Duration
3h 41m
Table of contents
Course Overview
Introduction and Overview
Dynamic Data Masking
Row-level Security
Always Encrypted
Stretch Database
Temporal Data
Built-in JSON Support
Description
Course info
Rating
(90)
Level
Intermediate
Updated
Oct 14, 2016
Duration
3h 41m
Description

This demo-packed course, SQL Server 2016 New Features for Developers, teaches the many powerful features for developers that have been added in SQL Server 2016. First, you'll discover new security features such as dynamic data masking (DDM), row-level security (RLS), and Always Encrypted. Next, you'll learn about the innovative capabilities, including "stretch" database (allow select tables in an on-premises database to be transparently relocated in Azure SQL Database), and temporal data (enable "time travel" to access data as it existed at any point in time). You'll also learn about the new built-in Javascript Object Notation (JSON) support which enables bi-directional manipulation of JSON data in SQL Server. By the end of this course, you'll be ready for SQL Server 2016 and its exciting new developer features.

About the author
About the author

Leonard Lobel (Microsoft MVP, SQL Server) is CTO and co-founder of Sleek Technologies, Inc., a New York-based development shop. He is also a principal consultant at Tallan, Inc., a Microsoft National Systems Integrator and Gold Competency Partner. Lenni is also a consultant, trainer, and frequent speaker at major industry conferences.

More from the author
Learning Azure Cosmos DB
Intermediate
6h 37m
Oct 26, 2020
More courses by Leonard Lobel