Introducing Azure SQL Ledger: Blockchain Technology for a Tamper Proof Record of Your Data over Time
Duration: 1h 12m | Video: 1280x720 30fps | Audio: AAC, 48 kHz, 2ch | Size: 284 MB
Genre: eLearning | Language: English

This video shows how to use blockchain technology in Azure SQL and SQL Server to provide an immutable record of data change over time, and to prove and attest to business partners that your data is accurate and has not been tempered with. You'll learn about the new, Ledger tables feature in Azure SQL and soon to be in SQL Server 2022 that enables this blockchain feature set. This video shows how Ledger-enabled tables protect your data from even high-privileged users, preventing even database and system administrators from making changes without a record of those changes being made.
Also covered in this video is the older feature set around system-versioned, temporal tables. You'll learn how temporal tables are used as the base infrastructure for maintaining the blockchain history in Ledger tables. The video shows how Ledger provides additional protection to ensure that – unlike the case with just temporal tables – rows are cryptographically hashed to ensure against tampering. You can even combine both features, temporal and ledger tables; while ledger tables protect the data, temporal tables allow you to easily see the state of the data on a specific time point.
What You Will Learn
Understand the technology behind Azure SQL Ledger
Create a database with ledger-enabled tables
Combine ledger and system-versioning technology in a single table
Modify the data in the ledger-enabled table
Change the structure of ledger-enabled tables
Verify that the ledger data has not been tampered with
Understand ledger technology limitations
Who This Book Is For
For advanced database administrators of Azure SQL Databases who are required to prove that sensitive data has not been tampered with. For administrators requiring a tamper-proof record of history over time. For those who are running SQL Server 2022 either on-premises or through Managed Instances who have the same needs.
Screenshots