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
Related Articles
Automating Automation in Toad Data Point
Recently I was talking to a group of Data Analysts about using Toad Data Point to access their multiple data sources and make sense of the data. As I was taking them through the process of building qu...
Quick Tips: Add SQL User/Rolemember to all Databases in SQL Server
Most of times when you have dedicated SQL Server for an Application clients come up with a request to add a user to all databases in the SQL Server with certain permission, while its east to do it via...
