Many applications require the ability to capture the history of changes to a record. We used to have to write custom code to do that, often with triggers. While common, that method was time-consuming to implement and maintain, and an error in a trigger could rollback the transaction, causing data loss. SQL Server 2016 added temporal tables, which automated change tracking and provided us a method of easily viewing all past versions of a record. However, while a temporal table is effective and relatively straightforward to implement, it provides no guarantees to the history’s completeness.
Enter ledger tables. First introduced in Azure SQL Database and now in SQL Server 2022, ledger tables use cryptography to create a verifiable and immutable audit trail of all changes to the data, providing the guarantees that temporal tables lack.
So how do they work? And are they right for your application? Come to this session to find out!
Sign up to stay up to date with news, special announcements and educational content.
Redgate will only contact you about PASS Data Community Summit (in line with our Privacy Policy) unless you separately request emails about Redgate. You can unsubscribe from these updates at any time.
Summit video library