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
Deploy Outlines
The Deploy Outline function in Optimize SQL improves SQL statement performance without changing your original source code. Using Optimize SQL, you can generate SQL statements that are semantically equ...
Using Toad Data Point with RDBMS Data Sources
Toad Data Point is a data preparation, analysis, and reporting tool with data access to several of the commonly used data sources. RDBMS databases is just one of the categories of data sources that ma...
What are the GDPR rules and how do these apply to the DBA?
Today I’m going to talk about the new GDPR rules, how they might affect your company, and steps DBAs can take to ensure compliance. The General Data Protection Regulation (GDPR) is now in effect, re...
