Getting Started with SQL Server Ledger

Course details

SQL Server is one of the world’s most popular database administration tools, and it just got even better. Meet Ledger, the brand-new feature in SQL Server 2022 that protects database integrity by recording cryptographic hashes which create an auditable record of all modifications. Join instructor Adam Wilbert to learn all about the features, functionalities, and benefits of this powerful, new technology.

Discover practical tips for applying Ledger to a SQL Server database and monitoring a Ledger-protected database to identify tampering events. Whether you’re an intermediate or advanced SQL Server professional, or just looking to upgrade your IT, Adam shows you how to leverage the latest capabilities of SQL Server 2022 so you can secure and protect your most sensitive data.

Concepts

0. Introduction

01 - Protect your data with SQL Server ledger
02 - What you should know

1. SQL Server Ledger Core Concepts

03 - What is SQL Server ledger
04 - Ledger tables and ledger databases
05 - Capture the database state in the digest

2. Add Ledger Features to Existing Databases

06 - Create updatable ledger tables
07 - Create append-only ledger tables
08 - Move existing data into a ledger table

3. Create a New Ledger Database

09 - Use T-SQL to create a ledger database
10 - Enable ledger in Azure SQL Database

4. Auditing a Database Protected by Ledger

11 - Manage the ledger digest
12 - Verify ledger integrity
13 - Detect unauthorized data modifications
14 - Recover a compromised database

Conclusion

15 - Next steps