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
Db2 for z/OS PBG Table Spaces: The Ins and Outs of Partition Addition
In an entry posted to this blog about three years ago, I advocated for putting some thought into the PBG versus PBR decision (partition-by-growth versus partition-by-range) for larger tables (for smal...
What is a Toad Snapshot and why should I use it?
A Toad Snapshot* is basically an offline file. It stores the state of your database schema structure at any given moment in time. Besides being useful for documentation purposes, it can also be access...
SQL Pattern Matching in Toad Data Point
SQL allows for the selectivity of character data with a specific pattern and NOT in a specific pattern. Either way, pattern matching syntax will always be useful when sifting through your extensive da...
