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
Oracle System Architecture
Oracle is an Object-Relational Database Management System, or, ORDBMS for short. A traditional RDBMS (Oracle Version 7 and below) stores data in tables called relations. These relations are two dimens...
Spotlight on Oracle – Improving Redo Log Writer Performance (SOO15)
Improving Redo Log Writer Performance Redo logs contain details of transactions that may not yet have been written to the data files. The primary purpose of the redo logs is to allow for the recove...
SQL Optimizer for Oracle – Optimize SQL (SQL Rewrite)
Using SQL Rewrite mode in Optimize SQL consists of two steps. In the first step, SQL Optimizer generates semantically equivalent alternatives with unique execution plans for your original SQL statemen...
