Data anonymization is the process of removing or modifying identifiable information from a database so that it cannot be linked back to an individual. In SQL Server, there are several techniques you can use to achieve data anonymization.
Security
Transparent Data Encryption In SQL Server
Introduction
SQL Server Transparent Data Encryption (TDE) is a security feature. TDE is known as encryption at rest. Database files and backups are protected from unauthorized access using AES or 3DES algorithm.