SQLBits 2023
Keep the Integrity of your Database with Azure SQL Ledger
Data integrity is a huge concern for every business, especially when it comes to protecting your company's most valuable information and Azure SQL Ledger can be the way to go.
Data integrity is a huge concern for every business, especially when it comes to protecting your company's most valuable information.
In this session, I will share what Azure SQL Ledger is, why it came into existence, and what it is used for. I will show how we can configure the ledger in the tables of a database, how the structure based on a blockchain works, and how we can do data integrity checking.
I want to show people what the expected behavior of each transaction is and how it is stored to ensure that we don't lose track of all the modifications.
After the explanation and the demo, I will talk a little bit about what implications this implementation has on performance and what next steps are being worked on to improve this technology.
In this session, I will share what Azure SQL Ledger is, why it came into existence, and what it is used for. I will show how we can configure the ledger in the tables of a database, how the structure based on a blockchain works, and how we can do data integrity checking.
I want to show people what the expected behavior of each transaction is and how it is stored to ensure that we don't lose track of all the modifications.
After the explanation and the demo, I will talk a little bit about what implications this implementation has on performance and what next steps are being worked on to improve this technology.