Developer Dive into SQL Server 2016

Tuesday May 22 09:00 - 17:00

This full-day workshop will get you up to speed on powerful features for developers in SQL Server. Lenni will pull no punches as he rips through 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. We start with the many enhancements made to T-SQL. 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 we’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 (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.

Part 3—Beyond Relational. Then we’ll examine the powerful “beyond relational” features, and get you thinking outside the box with respect to the types of data that can be managed by 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. We’ll also cover the geospatial data types that enable you to 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’ll learn a ton of new SQL Server features in this information-packed day!

Leonard Lobel

CTO, Sleek Technologies, Inc.

Leonard Lobel (Microsoft MVP, Data Platform) is the chief technology officer and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., a Microsoft National Systems Integrator and Gold Competency Partner.

Programming since 1979, Lenni specializes in Microsoft-based solutions, with experience that spans a variety of business domains, including publishing, financial, wholesale/retail, health care, and e-commerce. Lenni has served as chief architect and lead developer for various organizations, ranging from small shops to high-profile clients. He is also a consultant, trainer, and frequent speaker at local usergroup meetings, VSLive, SQL PASS, and other industry conferences.

Lenni has also authored several MS Press books and Pluralsight courses on SQL Server programming.