Anmerkungen:
Online resource; title from title details screen (O'Reilly, viewed October 18, 2022)
Beschreibung:
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.