TDE And Encrypted Backups

Arun Sirpal shows that Transparent Data Encryption will also lead to encrypted backups:

Ok great let’s check this backup file using a cool tool (XVI32). I really want the contact number of a guy called SQLDOUBLEG because I need his help tuning my SQL Servers so I go looking for a text string, hopefully the phone number will be close by.

As Arun points out, you don’t need TDE to get encrypted backups, but it does the job.

Related Posts

Stopping SQL Injection

Wayne Sheffield has a post explaining what SQL injection is and discussing how to stop it: Me: Umm, boss… Does this report allow users to enter in search criteria? Boss: But of course! Me: Well, I really hate to tell you this, but we have a SQL Injection problem. And after a bit of back […]

Read More

Securing S3 Credentials In Spark Jobs

Jason Pohl shows how to protect credentials for connecting to Amazon Web Services S3 buckets when building Spark jobs: Since Apache Spark separates compute from storage, every Spark Job requires a set of credentials to connect to disparate data sources. Storing those credentials in the clear can be a security risk if not stringently administered. […]

Read More


March 2017
« Feb Apr »