Session

Auditing and Ledger together in SQL Server 2022 from zero to a hero!

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!

Yitzhak David

DBA BDA POWER BI NOSQL K8s

Nahariyya, Israel

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top