Database and Analytics, Workshops & Hands-On Labs

HOL02 Full Day Hands-On Lab: Developer Dive into SQL Server


8:00am - 5:00pm

Level: Intermediate

Leonard Lobel



Sleek Technologies, Inc.

Roll up your sleeves, and get ready to spend a full day learning great new features for developers in SQL Server 2016. You'll start with a vanilla database, and then adorn it – step by step – with some of the most compelling new SQL Server 2016 features, including dynamic database masking (DDM), row level security (RLS), and Always Encrypted. Then you'll "stretch" the database, which transparently relocates select tables to the cloud in Azure SQL Database), and utilize temporal tables, which enables "time-travel" queries. You'll also exploit the new JSON capabilities to consume and produce JSON in the database, integrate FILESTREAM and FileTable for native BLOB storage, and add location awareness with the geospatial data types. Attendance is limited.

You will learn:

  • New SQL Server 2016 security features such as dynamic data masking, row level security, and always encrypted
  • Other new SQL Server 2016 features, such as stretch database, temporal tables, and JSON
  • Beyond relational features, such as FILESTREAM, FileTable, and geospatial data types

Attendance is limited.

Attendee Requirements:

You must provide your own laptop computer for this hands-on lab.

You will need a computer that supports Wi-Fi and that can connect to a Microsoft Azure hosted virtual machine via Remote Desktop Protocol (RDP). If you're running Windows 8.1 or Windows 10, you're ready to go! For the stretch database demos only, you'll also need a Microsoft Azure subscription. No worries if you don't have one though, you'll be able to follow along with the rest of the workshop without it.

If you're running Windows 7, you'll want to make sure you're have installed the latest Remote Desktop client. You can get it at

You can also use a Mac running OS/X 10.7 (Lion) or later with an Intel 64-bit processor. You'll want to install the latest Microsoft Remote Desktop client from the Mac App Store. You can find it via