Roll up your sleeves and get ready for some hands-on developer experience with SQL Server! In this full day workshop, Lenni will guide you through powerful SQL Server features for developers, including modern capabilities introduced in SQL Server 2022, as well as brand new AI features coming your way in SQL Server 2025. 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. Finally, you’ll get a head start on the exiting new SQL Server 2025 vector capabilities, already available in preview on Azure. You’ll learn how to effectively AI-enable your database for RAG (Retrieval Augmented Generation) solutions using the native vector data type and vector search features, and Azure OpenAI integration.
Attendee Requirements:
- You must provide your own laptop computer (Windows or Mac) for this hands-on lab.
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:
- SQL Server Management Studio 19.3
Visual Studio 2022 Community Edition