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

4,344 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

4,148 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

Power BI Monthly Digest – February 2020

By

In this month’s Power BI Digest Manuel I will again guide you through some...

Using Google Chrome with SSRS

By

In this post, you will learn how to resolve the Kerberos Double-Hop issue and...

Using Google Chrome with SSRS

By

In this post, you will learn how to resolve the Kerberos Double-Hop issue and...

Read the latest Blogs

Forums

More Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item More Data

SQL 2019 AG and system databases

By tony28

Hello, I read that in new SQL is Ag feature also for sync system...

Dimensional Database \"examples\"

By wallywizard

I have read many things online regarding dimensional vs relational databases. I under that...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

More Data

See possible answers