There are many 3rd party data masking tools, but specific to SQL Server is Hush Hush. It does data masking with SSIS components. While example in the blog presents a...
So far, not a single user here addressed the real use case, and the real use case was NOT ENCRYPTION. if it was encryption, no one would care do decrypt...