Protecting data from unauthorized access is a major challenge for organizations today. SQL Server 2022 introduces Database Ledger, a new feature that enhances data security. It protects data from attackers and high-privileged users like DBAs, system administrators, and cloud administrators.
The Database Ledger works like a traditional ledger, recording historical data. When a row is updated, SQL Server stores its previous value in a history table. This feature uses blockchain technology to ensure cryptographic data integrity. SQL Server hashes each transaction with SHA-256, generates a root hash and then links it to the previous block’s hash – forming a secure