Both Hashbytes and Compress functions have some use cases that we should consider when designing and tuning databases. These functions can be used to improve query performance, reduce storage, and enforce consistency. We will walk through some examples where these functions have helped me and will hopefully help you in the future.
Jeff works at Citrix as a Database Engineer working primarily on the ShareFile platform. His day to day is mostly TSQL development and tuning but he does his best to involve PowerShell as much as he can. Past jobs have included accidental DBA work though he mostly tries to leave database administration to the experts.
Outside of work he enjoys building Legos with his kids and playing Ultimate Frisbee.