Passive security refers to the practice of logging user activity in order to avoid the threat of nonrepudiation. SQL Server 2022 also introduces Ledger, which uses blockchain technology to make data tamper-evident, which allows for streamlined auditing processes. In this session, we will discuss the new ledger functionality, how to implement it and how to use it to discover who has changed data. I will demonstrate the concepts of auditing and demonstrating how to implement SQL Server Audit, including creation of custom audit event. I will Cover :
• Auditing and Ledger Ledger
• Append-Only Ledger Tables
• Ledger Database
• Database Ledger and Digest Management
• Creating a Server Audit Specification
• Enabling and Invoking Audits
• Updateable Ledger Tables
• Database Audit Specifications
• Auditing the Audit
This is a demo session only with minimum theory & lessons from the fields!