SQL Server 2016 New Features for Developers
Pluralsight
Course Summary
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 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.
-
+
Course Syllabus
Course Overview- 2m 35s
—Course Overview 2m 35sIntroduction and Overview- 19m 31s
—Introduction 2m 48s
—Overview of New SQL Server 2016 Developer Features 5m 23s
—SSMS vs. SSDT 1m 48s
—Just DIE (Drop if Exists) Please! 1m 11s
—Demo: DIE (Drop if Exists) 2m 1s
—Introducing SESSION_CONTEXT 2m 33s
—Demo: Sharing State with SESSION_CONTEXT 2m 41s
—Summary 1m 4sDynamic Data Masking- 20m 21sRow-level Security- 38m 49sAlways Encrypted- 36m 29sStretch Database- 34m 47sTemporal Data- 28m 4sBuilt-in JSON Support- 41m 43s