SQL Server for Developers

SQF01 Workshop: Developer Dive into SQL Server 2019

11/19/2021

8:00am - 5:00pm

Level: Intermediate

Leonard Lobel

MVP

CTO

Sleek Technologies, Inc.

This full-day workshop will get you up to speed on powerful new features in SQL Server 2019. Lenni will pull no punches as he rips through the most important SQL Server features for developers in this intensive demo-packed tour.

We'll kick things off with the broad multi-platform support across Windows, Linux, and Docker. Learn how SQL Server's ability to run inside Docker containers on both Windows and Mac will revolutionize the way you work with Microsoft's venerable database engine. Then you'll explore all the latest Intelligent Query Processing (IQP) enhancements added in SQL Server 2019, which delivers groundbreaking performance improvements to the query engine. We'll then move on to the latest development platform improvements, including machine learning services with R and Python, integrated JSON support, support for graph databases, stretch database, and temporal tables.

Next, we'll explore security features, such as dynamic data masking and row-level security. We'll dig into Always Encrypted, and demonstrate SQL Server 2019's support for secure enclaves that enables rich query of encrypted data in use. You'll also see the new data classification features in SQL Server 2019 to help you cope with GDPR and HIPPA privacy concerns. We'll wrap up with the latest PolyBase enhancements in SQL Server 2019 to query external data in Azure Blob Storage, Cosmos DB, Oracle, and other remote data sources.

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

You will learn:

  • How to boost your productivity by running SQL Server inside Docker containers
  • Intelligent Query Processing features and modern development platform for machine learning with R and Python
  • Discover the newest security features in Always Encrypted with secure enclaves, and the latest data virtualization capabilities with PolyBase