LinkedIn

MS-SQL Server 2016 HASHBYTEs function brings data auditing to a Higher Level (In other words, appyling BLOCKCHAIN concept into Data Auditing)

The secure hash algorithm (SHA), in other words HASHBYTEs function in MS-SQL Server 2016 simply rocks. The one-way hashing SHA2_256 and SHA2_512 are stronger algorithm. Hash algorithm SHA-256 is used ...
GitHub

today-i-learned-staging /sql_server

Imagine we have two tables (or views), TableNew and TableOld, and we want to know if their data is the same or different. Assume they have the same schema. Further assume that their primary key is a ...
LinkedIn

How we performed data validation and used HASHBYTES()

𝐄𝐱𝐩𝐥𝐚𝐢𝐧𝐞𝐝 𝐡𝐨𝐰 𝐰𝐞 𝐩𝐞𝐫𝐟𝐨𝐫𝐦𝐞𝐝 𝐯𝐚𝐥𝐢𝐝𝐚𝐭𝐢𝐨𝐧 — 𝐭𝐡𝐞 ...
GitHub

bulk_comparison_with_hashbytes.md

Imagine we have two tables (or views), TableNew and TableOld, and we want to know if their data is the same or different. Assume they have the same schema. Further assume that their primary key is a ...