Transparent Data Encryption (TDE)

SQLServerCentral Article

6 steps to a more secure SQL database

  • Article

Security is often something people think about only after they have had a problem. Given that the average cost of a data breach is $3.92 million (SecurityIntelligence 2019) and ransomware attacks have increased 97% over the past 2 years (PhishMe 2019), the "if it's not broke, don't fix it" approach can clearly be catastrophic. Here […]

5 (2)

2019-10-07

7,951 reads

SQLServerCentral Article

Key Rotation in TDE

  • Article

Transparent Data Encryption (TDE) has been around for a long time. It first appeared in SQL Server 2008, and after a rocky start with some bugs, it has become a regularly used feature for many organizations. While not perfect, it does provide some protection and auditors like to see physical protection features being used. It's […]

2019-08-29

9,580 reads

External Article

How to Move a TDE Encryption Key to Another SQL Server Instance

  • Article

If you have a database backup of a Transparent Data Encryption (TDE) enabled database, the database backup will contain encrypted data. Because the database backup contains encrypted data you can’t just restore it to any instance. You can only restore the database backup to an instance that contains the same certificate used to originally encrypt the database.

2018-02-20

2,970 reads

Blogs

Community Tools Month 2022 - dbatools

By

The Prompt In July, Brent Ozar (blog | twitter) asked us to make September...

Storytelling with Data – Enertia User Conference 2022

By

Thank you to everyone who attended my session at the Enertia User Conference in...

Daily Coping 30 Sep 2022

By

Today’s coping tip is to find a new way to use one of your...

Read the latest Blogs

Forums

How Important is Software?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Important is Software?

How and where did you learn SQL from?

By VladBar

Could you give me advice on where I should learn SQL and Python to...

Save Query Results to Excel and Automatically run it

By anonymous

Hello,   I have a very simple query Select * from Employees where company...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers