Azure SQL Database Ledger​ - The power of blockchain with the simplicity of SQL | Data Exposed

In this episode of Data Exposed with Jason Anderson, learn what the ledger feature of Azure SQL Database is and where using ledger can help enable digital trust in your data. There will also be some quick demos on how to enable this exciting new capability and how to show to others that your data is in-fact, intact.

0:00 Show begins
0:35 Introduction
1:46 Azure SQL Database Ledger Overview
8:04 Demo
13:03 Scenarios for ledger tables
15:34 Getting started

✔️ Resources:

📌 Let's connect:

🔔 Subscribe to our channels for even more SQL tips:

#AzureSQL #SQLServer #AzureSQLSecurity #SQLLedger #DataExposed

[demc]

Just an amazing way to simplify what actually is complex, now Ledger is GA for Azure SQL Database, which makes even more secure the SQL databases

[machevellian]

Concise, clear explanation of how to implement blockchain auditing verification among other features. Thanks, going to check out the white paper! Cool, cool, cool as they say ;)

[PicaPauDiablo]

What a very pleasant surprise. You both Rock. Thank you!

[TechCodeLock]

Perfect Jason . Thanks for short and sweet demo. I leaned interesting topic..

[junsato]

I'm trying this out and have a dumb question. With append-only, how do you do retention control? If you can't DELETE, then how do you, say, kill logs older than a year? or are you doomed to have an ever-expanding table with no way for size control?

[deeteenw]

Hi Anna and Jason. I viewed the documentation for Ledger tables but let's say I only need to store historical data for a year or so. How do I ever get rid of old data in the history table? Or am I stuck with an ever growing database, hoping that storage costs decline faster than my database grows?

[stephenmorris]

A definition of immutable & non-repudiation would probably be helpful for people with english as a 2nd language