From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Implement database ledger in Azure SQL

Implement database ledger in Azure SQL

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Implement database ledger in Azure SQL

“

- Welcome back. This is Lesson 6.6: Implement Database Ledger in Azure SQL. If you can't trust your data, your data's no good, and this is where ledger comes in. Ledger is all about establishing integrity of your data. So ledger, the ledger feature in SQL provides tamper-evidence capabilities within your database. Ledger uses cryptographic technology to provide data integrity guarantees, which you can use then to confirm to other parties that your data has not been tampered with. So before moving on, I need to spend a few minutes and talk about how ledger works. As rows are modified in a database and a table, those modified rows are cryptographically hashed using an SHA-256 cryptographic function. Transactions that the database processes are also hashed, and those are hashed together to form a root hash that form a block. That block is then hashed, resulting in a hash chain. The root hashes are called the database digest, and this information will come in handy on the next slide. So…

Contents