Tools › GDPR / PII wizard

Anonymize and mask PII in SQL Server

Test environments should not hold real emails. Pick a method per column. Run it on a copy.

Table Columns (name : kind). Kinds: email, phone, name, salary, id Method

Hashing is one-way. Masking is not encryption. Related: HASHBYTES, dynamic masking.

Learn it on a real ticket

Monday is free on WorkSQL. Write the T-SQL yourself. We mark it like a colleague would.