Database Development, Workshops

DPM02 Workshop: SQL Server Developer Deep Dive


8:30am - 5:30pm

Level: Intermediate

Leonard Lobel



Sleek Technologies, Inc.

This full-day workshop will get you up to speed on powerful new features in SQL Server 2022. 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 Linux containers on both Windows and Mac will revolutionize the way you work with the database engine. Then you'll explore the Intelligent Query Processing (IQP) features, which deliver groundbreaking performance improvements to the query engine. We'll then move on to the latest development platform improvements, including T-SQL enhancements added in SQL Server 2022, Python integration, JSON support, and temporal tables. And you'll discover the brand-new Data API Builder that enables you to instantly create REST and/or GraphQL endpoint services right over your database tables, views, and stored procedures.

Next, we'll explore security features, starting with ledger tables. New in SQL Server 2022, ledger utilizes blockchain technology that hashes every transaction, and guarantees tamper evidence in your database. Then we'll examine dynamic data masking, row-level security, Always Encrypted and demonstrate support for secure enclaves to enable rich querying over encrypted data. We'll wrap up with the latest PolyBase enhancements to query external data in Azure Blob Storage, Mongo 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 developer productivity by running SQL Server inside Linux containers with Docker
  • About Intelligent Query Processing features, T-SQL enhancements, Python integration, JSON support, and Data API Builder
  • Discover the newest security features including ledger tables, Always Encrypted with secure enclaves, and the latest data virtualization capabilities with PolyBase