Ledger documentation

Find documentation about ledger for SQL Server 2022 and Azure SQL

Ledger overview

Overview

• What is ledger?

Ledger concepts

Concept

• What is the database ledger?
• Append-only ledger tables
• Updatable ledger tables
• Digest management
• Database verification
• Monitor digest uploads

Using ledger

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 Confidential Ledger

Ledger references

Reference

• Current ledger considerations and limitations
• Ledger whitepaper
• Microsoft Customer Story - Lenovo reinforces customer trust with ledger in Azure SQL Database
• Microsoft Customer Story - RTGS.global automates financial transfers, unlocks trillions in capital with Azure
• Microsoft Customer Story - Qode Health Solutions secures COVID-19 vaccination records with the ledger feature in Azure SQL Database

Ledger System Catalog Views

Reference

• sys.database_ledger_blocks (Transact-SQL)
• sys.database_ledger_transactions (Transact-SQL)
• sys.database_ledger_digest_locations (Transact-SQL)
• sys.ledger_table_history (Transact-SQL)
• sys.ledger_column_history (Transact-SQL)

Ledger Stored Procedures

Reference

• sys.sp_generate_database_ledger_digest (Transact-SQL)
• sys.sp_verify_database_ledger (Transact-SQL)
• sys.sp_verify_database_ledger_from_digest_storage (Transact-SQL)
• sys.sp_copy_data_in_batches (Transact-SQL)

Ledger video references

video

• Bringing the power of blockchain to Azure SQL Database and SQL Server with ledger | Data Exposed
• Learn how Lenovo reinforces trust using ledger in Azure SQL Database