First of all THANK YOU !!! 1K subscribers is a big deal and I wanted to let you know how much I appreciate it. Stay tuned for special video to celebrate 1K users.

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. https://www.enabledbusinesssolutions....


Need more information?
Visit https://www.enabledbusiness.com

To know more about Jayanth Kurup visit www.jayanthkurup.com

Jayanth is a Microsoft SQL Server trainer / consultant with over 15 years experience. He has worked with companies like Microsoft, IBM, HCL , Wipro , WellFargo , Zeomega and many more. He is based out of Bangalore and a very active member of the SQL Server Community.

In this channel he covers complex topics related MS SQL Server , PowerBI , Azure , AWS , Powershell, SSIS , SSAS , SSRS , Machine Learning , AI , etc

You can reach Jayanth via his LinkedIn Profile
  / jayanthkurup