TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget that it also encrypts your backup file too. I fancied looking inside the MDF and a backup of my database before enabling TDE and comparing it to … Continue reading
Tags: SQL Server
Identity Security Risk Assessment
Get a free AD security assessment to evaluate your environment and identify the most actionable issues.
Related Articles

How to use the Cross Connection features in heterogeneous database...
In the real world I found that most customers have two or more different database vendors in house and sometimes there is a business need to join both database environments. I found some features in T...

When Using Availability Group Listeners, Why Can I See Non-AG Databases?
Yep. This is actually by design; and is because listeners can be tricky little fellas. When using a SQL Server Availability Group Listener, you can see any databases on the server that is hosting the...