Transparent Data Encryption (TDE)

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

3,425 reads

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

3,566 reads

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

Database Fundamentals #24: Filtering Data

By

If you’ve been reading these Database Fundamentals posts, you’ve already seen the WHERE clause...

#PowershellBasics: The Windows Powershell icon in the task bar also lets you run Powershell ISE.

By

I don’t know about you, but I like having the tools that I’m likely...

Launching SQL Compare with Context

By

Years ago Redgate Software started some work to link our tools together. I remember...

Read the latest Blogs

Forums

insert into permanent table using cte

By samirca007

Good morning all I would like to add the result of a multiple query...

Datetime data migration.

By Arjun

Hi All, We are loading data from one of our source table in that...

2012 - 17 Performance Issue

By Matthew24

  Good afternoon everyone, This may sound familiar, but we are yet to find...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Another Typo

See possible answers