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.
What you'll learn
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.
Table of contents
- Introducing Row-level Security 1m
- Filter and Block Predicates 1m
- Combining RLS Predicates 2m
- Creating Security Predicate Functions 3m
- Creating Security Policies 2m
- Demo: Creating and Testing an RLS Predicate 10m
- Demo: Implementing an RLS Security Policy 7m
- Identifying Users for RLS 2m
- Demo: Using Row-level Security in N-tier applications 9m
- Summary 1m
- Traditional SQL Server Encryption Features 3m
- Introducing Always Encrypted 2m
- Encryption Types 2m
- Encryption Keys 2m
- Always Encrypted Workflow 5m
- Catalog Views for Always Encrypted Metadata 1m
- Demo: Encrypting an Existing Table 7m
- Demo: Querying and Storing Encrypted Data 7m
- CMK Rotation 1m
- Demo: Rotating the Column Master Key 3m
- Limitations and Considerations 2m
- Summary 2m
- Introducing Stretch Database 2m
- Demo: Running the Stretch Database Advisor 4m
- Stretch Database Terminology 1m
- Stretch Database Workflow 1m
- Demo: Preparing Azure for Stretch 2m
- Demo: Stretching a Table 10m
- Stretching selected Rows 3m
- Demo: Stretching Selected Rows 6m
- Stretch Pricing 1m
- Limitations and Considerations 2m
- Summary 1m
- Introducing Temporal Tables 2m
- Using Temporal 4m
- Demo: Creating a Temporal Table 4m
- Demo: Converting an Existing Table to Temporal 1m
- Demo: Querying Temporal Data 7m
- Demo: Combining Temporal with Stretch 5m
- Demo: Hiding Period Columns 1m
- Demo: Managing Schema Changes 1m
- Limitations and Considerations 2m
- Summary 1m
- JSON and SQL Server 3m
- Bidirectional JSON Transformation 2m
- FOR JSON clause 3m
- Demo: Querying with FOR JSON AUTO 7m
- Demo: Querying with FOR JSON PATH 5m
- Built-in JSON Functions 2m
- JSON Path Expressions 3m
- Demo: Storing JSON 4m
- Demo: Querying JSON 3m
- Shredding JSON 1m
- Demo: Getting Started with OPENJSON 4m
- Demo: Parsing Parent/child Objects with OPENJSON 3m
- Demo: Using OPENJSON with an Explicit Schema 3m
- Summary 1m
About the author
Leonard Lobel (Microsoft MVP, SQL Server) is the chief technology officer and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., one of only 40 Microsoft National Systems Integrators in the United States. For more than 25 years, Tallan has been providing cutting-edge custom web/application development, business intelligence, customer relationship management, and int... more