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
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...
My backup and SLEEP_BPOOL_FLUSH
I noticed that my backup was taking longer than usual. I went to Perfmon to look at some counters, more specifically Physical disk:Avg sec/read(orange/yellow line) and Physical disk:Avg sec/write(blue...
Overview of File Version Control
This video provides an overview of file version control. The video was recorded using Toad Data Point, but the features work identically in Toad for SAP Solutions as well as Toad for IBM DB2....
