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
Top 10 most popular Toad Edge® blogs
ToadWorld.com was launched in 2006 and hosted the first viral freemium, Toad® for Oracle. Since its inception, Toad World® has evolved into a trusted community where database developers and administra...
Learn how to use Dimensional Views in Toad Data Point Workbook
Tired of just using pivots? Learn how to correctly use Dimensional Views as an analysis tools in Toad Data Point Workbook. To learn all about Toad Data Point Workbook – check out our Guide to ...
SQL SERVER – Fix: Error: 1934, Level 16, INSERT or UPDATE Failed...
A very old client of mine yesterday pinged me with this question about error related to QUOTED_IDENTIFIER. “Pinal, When I run my query it works just fine in SSMS but when I run it via SQL Server Agen...