Database and Analytics, Workshops

M01 Workshop: SQL Server for Developers


9:00am - 6:00pm

Level: Intermediate

Andrew Brust

Senior Director, Market Strategy and Intelligence


Leonard Lobel



Sleek Technologies, Inc.

This full-day workshop will get you up to speed on powerful features for developers in SQL Server 2016. Lenni and Andrew will pull no punches as they rip through the most important SQL Server features for developers in this intensive demo-packed tour. We'll begin with the latest features added in SQL Server 2016, including 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), and temporal data (enable "time travel" to access data as it existed at any point in time). You'll also learn about Polybase (access Hadoop and Azure Blob Storage with T-SQL), QueryStore (maintain query plan history and per-formance data), and R integration (an open source data science language).

You'll then look at the Big Data and analytics capabilities of SQL Server and the Microsoft data stack. You'll see how columnstore indexers can make a huge difference in your data ware-house-style queries, and how to make sure columnstore indexes are being invoked when you intend. You'll learn about Apache Hadoop, HDInsight (Microsoft's cloud implementation of Hadoop) and the PolyBase technology in SQL Server 2016 that lets you query Hadoop using T-SQL. You'll cover basic data warehouse concepts, the fundamentals of Power BI, and un-derstand the capabilities of SQL Server components like Integration Services, Analysis Ser-vices, Master Data Services, Data Quality Services, and Analytics Platform System (APS), and you'll see what's new in SQL Server 2016 Reporting Services.

To wrap up, we'll examine the "beyond relational" features that will get you thinking outside the box with respect to the types of data that can be managed by a relational database system. You'll learn how to use the built-in JSON support, new in SQL Server 2016, and how to use the hierarchyid data type to cast a hierarchical structure over any relational table. We'll finish up by digging into FILESTREAM and FileTable, which lets you store large binary objects in the database transparently, and with full transactional capabilities.

You'll learn a ton of new SQL Server features in this information-packed day!

You will learn:

  • The latest new features in SQL Server 2016, including dynamic data masking, row-level security, always encrypted, stretch database, temporal data, and more
  • The Big Data and analytics capabilities in SQL Server, Power BI and HDInsight, in-cluding enhancements to Reporting Services
  • Unstructured data storage, including native file streaming, the hierarchical data type, and built-in JSON support (new in SQL Server 2016)