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:

Note: You can find detailed setup instructions for these steps at: https://lennilobel.wordpress.com/2024/04/22/hands-on-lab-sql-server-2022-for-developers/

SQL Server 2022

• The Developer Edition is available for free
• Choose Basic Installation
• During the install, choose “Mixed-mode authentication” and set a password that you’ll remember for the “sa” account
• 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
• This is a free tool
• https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

Visual Studio 2022 (any edition) with .NET desktop development workload

• The Community Edition is available for free
• Choose the “.NET desktop development workload”
• https://visualstudio.microsoft.com/vs/community

Sample databases

• Some demos utilize the AdventureWorks2019 or WideWorldImporters sample databases
• Download their backup files, and restore the databases to your local SQL Server instance
• https://bit.ly/sql2022-hol-databases