Data & Analytics, Hands-On Labs

HOL01 Hands-on Lab: SQL Server 2022 for Developers

04/29/2024

8:30am - 6:00pm

Leonard Lobel

MVP

CTO

Sleek Technologies, Inc.

Roll up your sleeves and get ready for some hands-on developer experience with SQL Server 2022! In this full day workshop, Lenni will guide you through powerful SQL Server features for developers, including some of the newest capabilities introduced in SQL Server 2022. Lenni will first show you how these features work, and then it’s your turn to apply that knowledge right from your own laptop.

You’ll learn how to use many of the newest T-SQL functions added in SQL Server 2022, including DATE_BUCKET, DATETRUNC, GENERATE_SERIES, LEAST and GREATEST, IS [NOT] DISTINCT FROM, and more. We’ll dive into temporal tables for point-in-time data access, and then explore ledger tables, new in SQL Server 2022, which utilizes blockchain technology to hash every transaction, and guarantee tamper evidence in your database. You’ll see how Dynamic Data Masking (DDM) works for hiding sensitive data without encryption, including the latest ability to apply granular DDM permissions to different users and roles. We’ll also cover Row Level Security (RLS) and see how to use this feature to secure tables that grant read and write access to various users at the individual row level. And we’ll then wrap up with Always Encrypted, where you’ll learn how to secure your database with client-side encryption that ensures only authorized users and applications are able to encrypt and decrypt highly sensitive data.

There are only a few prerequisites to participate, so just make sure you’ve got the following software installed on your machine in advance of this hands-on labs workshop:


SQL Server 2022 Developer Edition
  • https://www.microsoft.com/en-us/sql-server/sql-server-downloads

  • SQL Server Management Studio 19.3
  • Earlier versions may not support all the demos
  • https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

  • Visual Studio 2022 Community Edition
  • .NET desktop development workload
  • https://visualstudio.microsoft.com/vs/community