Episode

Bringing the power of blockchain to Azure SQL Database and SQL Server with ledger | Data Exposed

with Anna Hoffman, Pieter Vanhove

Data Exposed

Establishing trust around the integrity of data stored in database systems has been a longstanding problem for all organizations that manage financial, medical, or other sensitive data. Ledger is a new feature in Azure SQL and SQL Server that incorporates blockchain crypto technologies into the RDBMS to ensure the data stored in a database is tamper evident. In this session of Data Exposed with Anna Hoffman and Pieter Vanhove, we will cover the basic concepts of Ledger and how it works, Ledger tables, and digest management, and database verification.

Chapters

  • 00:00 - Introduction
  • 01:30 - How do you know your data has (not) been tampered
  • 03:05 - Blockchains are overkill for centralized scenarios
  • 04:12 - Ledger, the power of blockchain with the simplicity of SQL
  • 06:19 - Ledger Tables - Updatable and Append-Only
  • 10:47 - How to create a ledger table
  • 11:28 - Database Verification
  • 12:12 - Demo
  • 18:23 - Scenarios for ledger tables
  • 18:52 - Customers using ledger in Azure SQL Database
  • 19:45 - Resources

Additional resources

Azure