Omri Bahat is a director at SQL Farms in Alexandria, Virginia. Specializing in large database environments, he served as the lead database architect at Symantec and has a doctorate in electrical and computer engineering.
Developers and software vendors use the WITH ENCRYPTION clause to obscure the underlying schema of their products. However, advanced users can still access the code. Here’s a simple do-it-yourself T-SQL algorithm that unlocks encrypted database objects.