SQL Server for Developers

SQT04 What's New for Developers in SQL Server 2016

11/14/2017

1:30pm - 2:45pm

Level: Introductory to Intermediate

Leonard Lobel

MVP

CTO

Sleek Technologies, Inc.

SQL Server 2016 adds many powerful features that you'll learn about in this demo-packed session. Discover new security features such as dynamic data masking, row-level security, and always encrypted. Other innovative capabilities include "stretch" database (allow select tables in an on-premises database to be transparently relocated in Azure SQL Database), temporal data (enable "time travel" to access data as it existed at any point in time), and integrated JSON support. Attend this session and get ready for SQL Server 2016 today!

You will learn:

  • New security features in SQL Server 2016, including dynamic data masking, row-level security, and always encrypted.
  • How to examine stretch database and temporal data support added in SQL Server 2016.
  • How tosStore, retrieve, and manipulate JSON data in SQL Server