Azure SQL Database Ledger: Blockchain power in SQL

On this page

Ledger functionality adds tamper-evidence to Azure SQL. It cryptographically links blocks of transactions together (like a blockchain), creating an immutable history. If a DBA tries to modify a row in the history table directly, the cryptographic verification fails.

Creating a Ledger Table

SQL10 lines
CREATE TABLE dbo.Transactions
(
    TransactionId int PRIMARY KEY,
    Amount decimal(10,2)
)
WITH 
(
    SYSTEM_VERSIONING = ON (HISTORY_TABLE = dbo.TransactionsHistory),
    LEDGER = ON
);

Verification

You can run a stored procedure to verify the integrity of the database against a digest stored in immutable storage (Azure Blob with WORM).

Key Takeaways

  • Use for Financial, Healthcare, and Supply Chain systems where auditability is mandated.
  • It is transparent to the application (just normal SQL inserts).

Discover more from C4: Container, Code, Cloud & Context

Subscribe to get the latest posts sent to your email.

Written by

Nithin Mohan TK

Hello Namaste! 👋🏻 I'm an accomplished Enterprise Solution Architect & Engineering Leader with 20+ years of progressive experience architecting, building, and scaling transformative enterprise solutions. ⚜️ Solution Architect / AI & Cloud 📌 Galway, Ireland

Leave a comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.