In this video we cover TDE or transparent data encryption. It is a feature that allows the DBA to protect files in the disk such as MDF, LDF and NDF. It doesn’t prevent the DBA from viewing the data. But it does protect the database from being restored on an unauthorized server where other security features can be bypassed. The biggest drawback is the significant performance impact it has because it encrypts the temp database files as well.
Here is the link to implement and test TDE as shown in the video