Keep the Integrity of your Database with Azure SQL Ledger

on YouTube ↗48m

" summary

SQL Ledger in SQL Server 2022 and Azure SQL adds updatable Ledger table and append-only table types plus a history table and ledger view, emits encrypted transaction blocks every ~30 seconds, and writes digests to trusted storage (Azure Blob or Azure Confidential Ledger). Verification reads those digests and compares them to on‑disk data to detect tampering; example demo shows bank account updates recorded in history. Limitations: no in‑memory tables or CDC, dropped rows/columns remain verifiable; verifying ~40M transactions takes ~20–30 minutes.

AI-written summary · about

" chapters (11)

1. 0:00Introduction to SQL Ledger
2. 2:34Context and blockchain
3. 6:25SQL Ledger architecture
4. 9:53Database ledger and storage
5. 13:32Configuring SQL Ledger
6. 18:59Demo: Working with ledger tables
7. 25:44System metadata tables
8. 28:27Verification process
9. 33:39Scalability and limitations
10. 37:10Use cases and conclusion
11. 40:56Q&A session

" related talks

• 48mProtecting the confidentiality and integrity of your high value data with Azure SQL and SQL Server 2Jakub Szymaszek · SQLBits 2023
• 40mUnderstanding the cryptographic controls in Azure SQL DatabaseMichael Howard · Microsoft Build 2023
• 44mAre Accounting Databases Interesting or Just Part of the Blockchain Hype?Javier Ramirez · Commit Conf 2019
• 50mAchieve peak performance and availability for your SQL Server and Azure SQL workloads with core engiAjay Jagannathan · SQLBits 2024
• 32mDesigning secure Azure SQL Database solutionsMichael Howard · Microsoft Build 2023
• 49mAnalytics in SQL Server and Azure SQL Databasechuck heinzelman, Ajay Jagannathan · SQLBits 2023
• 51mThe 10 things every developer must absolutely know about Azure SQLDavide Mauri · SQLBits 2023
• 40mThe SQL Leadership PanelBob Ward, Sanjay Mishra, Erin Stellato, Asad Khan, Muazma Zahid, Niko Neugebauer · SQLBits 2023