SQL Server 2022 introduced the Ledger feature to meet the growing need for tamper-evident audit trails in regulated and audit-heavy industries such as finance, healthcare, and supply chains. One of the most notable implementations of this feature is the append-only ledger table, which ensures that sensitive data is immutable once added, providing stronger guarantees of integrity and compliance. 

Below, we incorporate and expand on the example and details from Microsoft’s official article on creating and using append-only ledger tables, showcasing its capabilities to preserve data integrity and support audit scenarios.