Create and use updatable ledger tables - SQL Server Applies to: SQL Server 2022 (16 x) and later versions Azure SQL Database Azure SQL Managed Instance This article shows you how to create an updatable ledger table Next, you'll insert values in your updatable ledger table and then make updates to the data Finally, you'll view the results by using the ledger view We'll use an example of a banking application that tracks banking customers
Database ledger - SQL Server | Microsoft Learn Applies to: SQL Server 2022 (16 x) and later versions Azure SQL Database Azure SQL Managed Instance The database ledger is part of the ledger feature The database ledger incrementally captures the state of a database as the database evolves over time, while updates occur on ledger tables It logically uses a blockchain and Merkle tree data structures Any operations that update a ledger table
Demo for SQL Server Ledger for SQL Server 2022 - GitHub Demo 1: Using an updatable ledger table This demo will show you the fundamentals of an updatable ledger table Create logins by executing the script addsysadminlogin sql from SSMS as the default sysadmin for the SQL Server instance Login with the 'bob' sysadmin user created in step #1
Create and use append-only ledger tables - SQL Server Applies to: SQL Server 2022 (16 x) and later versions Azure SQL Database Azure SQL Managed Instance This article shows you how to create an append-only ledger table Next, you'll insert values in your append-only ledger table and then attempt to make updates to the data Finally, you'll view the results by using the ledger view We'll use an example of a card key access system for a facility
What is SQL Server Ledger? - C# Corner SQL Server Ledger is a feature of SQL Server that provides tamper-evident capabilities for your database It does this by using a blockchain and Merkle tree data structures to track the history of changes to your database
Append-only ledger tables - SQL Server | Microsoft Learn Append-only ledger tables are ideal for systems that don't update or delete records, such as security information event and management systems or blockchain systems where data needs to be replicated from the blockchain to a database
Ledger documentation - SQL Server and Azure SQL How-To Guide Configure a ledger database Create append-only ledger tables Create updatable ledger tables Enable automatic digest storage Migrate data from regular tables to ledger tables Recover ledger database after tampering Verify a ledger table to detect tampering Configure Azure SQL Managed Instance NSG rules to work with Azure