Recovering a TDE protected database without the Certificate
If you’ve been careful and done everything right when you’re setting up TDE then you shouldn’t run into this problem.
We...
2018-02-21
3,270 reads
Matthew McGiffen DBA
TDE and backup compression – still not working?
Until SQL 2016 if you used TDE (Transparent Data Encryption) you couldn’t use backup compression.
In 2016 Microsoft changed this, but...
2019-04-26 (first published: 2018-02-16)
2,391 reads
Migrating or Recovering a TDE protected Database
When encrypting a database with Transparent Data Encryption(TDE), a vital consideration is to make sure we are prepared for the...
2018-02-14
524 reads
Encrypting an existing database with TDE
As mentioned previously, the process of setting up TDE (Setting up Transparent Data Encryption (TDE)) is the same whether you’ve...
2018-01-26
1,189 reads
Setting up Transparent Data Encryption (TDE)
You can set up Transparent Data Encryption (TDE) when you first create a database, or you can apply it to...
2018-01-26
2,658 reads
What is Transparent Data Encryption?
Transparent Data Encryption (TDE) was introduced in SQL 2008 as a way of protecting “at rest” data. It continues to...
2019-04-26 (first published: 2018-01-26)
2,156 reads
How Secure is Transparent Data Encryption (TDE) – and How to Prevent Hacking
TDE is commonly described as “at-rest” encryption, i.e. it protects your data wherever it is stored on disk. This includes...
2019-04-26 (first published: 2018-01-03)
3,179 reads
SQL Puzzle 5: Prime Magic
Quite a few of you have read or attempted the previous puzzle SQL Puzzle 1: Magic Squares
As a quick reminder, when...
2019-04-26 (first published: 2017-12-19)
1,645 reads
Understanding Keys and Certificates with Transparent Data Encryption (TDE)
I’ve been taking a bit of a deep dive into understanding Transparent Data Encryption (TDE). As part of that I’ve...
2019-04-26 (first published: 2017-12-12)
2,681 reads
Overview of Encryption Tools in SQL Server
More and more people are considering some level of encryption against their data stored in SQL Server. In many cases...
2019-04-26 (first published: 2017-12-05)
4,228 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
Happy Holidays, Let's Do Nerdy Stuff
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
Question of the Day
UNISTR Escape
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers