Database and Analytics

T03 What's New in SQL Server 2016


9:15am - 10:30am

Level: Introductory to Intermediate

Leonard Lobel



Sleek Technologies, Inc.

SQL Server 2016 adds many powerful features, as you'll learn 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. You'll also learn about Polybase (access Hadoop and Azure Blob Storage with T-SQL), QueryStore (maintain query plan history and performance data), and R integration (an open source data science language). Attend this session and get ready for SQL Server 2016 today.

You'll learn:

  • About the new security features in SQL Server 2016, including dynamic data masking, row-level security, and always encrypted.
  • How to examine stretch database, temporal data, and JSON support added in SQL Server 2016.
  • How to explore additional capabilities such as Polybase, QueryStore, and R integration