Why should you care?

Regulated ledgers and audit trails need stronger guarantees than ordinary UPDATEs.

See it live — copy this example

Run in SQL Server Management Studio (SSMS) or Azure Data Studio.

USE DataVerse;
-- Requires SQL Server 2022+
CREATE TABLE dbo.PaymentLedger (
    PaymentId INT IDENTITY PRIMARY KEY,
    AccountId INT NOT NULL,
    Amount DECIMAL(18,2) NOT NULL,
    NotedAt DATETIME2 NOT NULL DEFAULT SYSUTCDATETIME()
)
WITH (SYSTEM_VERSIONING = ON, LEDGER = ON);
INSERT INTO dbo.PaymentLedger (AccountId, Amount) VALUES (1, 250.00);
SELECT * FROM dbo.PaymentLedger;

What happened?

• LEDGER = ON creates a ledger table with history digest protection.
• Inserts append; verify digests with ledger views/tools as you deepen the feature.

Practice next

1. Confirm SQL Server 2022+.
2. Create PaymentLedger with LEDGER = ON.
3. Insert a payment and select it.
4. Attempt an in-place UPDATE policy — learn append-only behaviors.
5. Digest verification demo from Microsoft Learn.

Remember

Ledger = tamper-evident tables. SQL Server 2022+ feature. Ideal for high-assurance money trails.

Immutable payment trail

DataVerse records wallet top-ups in a ledger table.

Outcome: Auditors verify digests independently.