Database and Analytics

T07 What's New for Developers in SQL Server 2016


10:45am - 12:00pm

Level: Introductory to Intermediate

Leonard Lobel



Sleek Technologies, Inc.

SQL Server 2016 has many powerful new features, and you'll learn about them 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 (which lets you transparently relocate select tables in an on-premises database to be in Azure SQL Database), temporal data (which lets you "time travel" to access data as it existed at any point in time), and integrated JSON support. Attend this session and you'll be ready for SQL Server 2016.

You will learn:

  • About the new security features in SQL Server 2016, including dynamic data masking, row-level security, and always encrypted
  • About stretch database and temporal data support added in SQL Server 2016
  • How Store, retrieve, and manipulate JSON data in SQL Server