Database Development, Workshops

DPM02 Workshop: SQL Server Developer Deep Dive

11/18/2024

8:30am - 5:30pm

Level: Intermediate

Leonard Lobel

MVP

CTO

Sleek Technologies, Inc.

This full-day workshop will get you up to speed on powerful features in SQL Server 2022 and Azure SQL Database. 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. You’ll also learn about vector search features that enable Retrieval Augmented Generation (RAG) patterns, empowering your database with natural language AI search capabilities.

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 row-level security and Always Encrypted, with 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!

  • How to boost developer productivity by running SQL Server inside Linux containers with Docker
  • Learns about Intelligent Query Processing features, T-SQL enhancements, Python integration, JSON support, Data API Builder, and vector search for AI capabilities
  • Discover the newest security features including ledger tables, Always Encrypted with secure enclaves, and the latest data virtualization capabilities with PolyBase