Database and Analytics, Workshops

M02 Workshop Continued: Developer Dive into SQL Server 2016


2:00pm - 5:30pm

Level: Intermediate

Leonard Lobel



Sleek Technologies, Inc.

This full-day workshop will get you up to speed on powerful features for developers in SQL Server. You'll learn about the most important SQL Server programmability points in this intensive demo-packed tour, including the latest capabilities introduced with SQL Server 2016.

Part 1–T-SQL Enhancements: You'll start with the many enhancements made to T-SQL; and learn about the T-SQL windowing (OVER clause) enhancements, running and sliding aggregates, 22 new functions, the THROW statement, server-side paging, the SEQUENCE object, metadata discovery techniques, and DIE (drop if exists).

Part 2–What's New in SQL Server 2016: Next you'll explore many of the latest SQL Server features introduced in SQL Server 2016. 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 into Azure SQL Database), temporal data (which enables "time travel" to access data as it existed at any point in time), and integrated JSON support.

Part 3–Beyond Relational: Then you'll examine the powerful "beyond relational" features, and start thinking outside the box with respect to the types of data you can managed with a relational database system. Learn about the new built-in JSON support in SQL Server 2016. Dig into FILESTREAM and FileTable to discover how you can enjoy the native ability to store large binary objects in the file system. You'll also learn about the geospatial data types that let you integrate location-intelligence into the database, and build several location-aware applications on top of these new data types, including a Bing Maps mash-up.

You will learn:

  • About T-SQL enhancements including windowing, new functions, THROW, server-side paging, SEQUENCE, and DIE
  • The new developer features in SQL Server 2016, including DDM, RLS, Always Encrypted, Stretch, and Temporal
  • The beyond relational features in SQL Server, including JSON (new in 2016), FILESTREAM, FileTable, and geospatial data types