Removing TDE from a Database: Level 4 of the Stairway to TDE

Learn how to remove TDE from a database and return it to a normal state.

Enforce SSL for connecting to AWS RDS Instance of SQL Server

Learn how to force all SQL Server connections to an AWS RDS instance to use SSL encrypted connections.

The Worst Data Breech

A new law in Australia might be a source for the worst data breeches we could have.

How to Remove Transparent Data Encryption From a Database

There may be a time when you want to turn off transparent data encryption on one of your TDE enabled databases. In this tip, Greg Larsen shows you how simple it is to remove Transparent Data Encryption.

Enable FIPS 140-2 Compliance in SQL Server

What is FIPS? How do I use it? What is going to break if I do use it?

Data Encryption Using Always Encrypted in SQL Server

The key challenge for application developers is to build a foolproof system to ensure data security. This is not only more intense, but more complex these days, as many organizations are planning to move their applications to the cloud. Read on to learn more.

TDE with Automatic Database Seeding

Transparent Data Encryption on an Availability Group and Automatic Database Seeding

Rotating Certificates

How to Enable Transparent Data Encryption

By default, SQL Server does not encrypt data in a SQL Server database in an encrypted format. When SQL Server 2008 was introduced, Microsoft implemented Transparent Data Encryption (TDE). When TDE is enabled on a database SQL Server will encrypt the database as data is written to the disk.

Remove Database Encryption Key on all user databases

Below script will remove database encryption key, database certificate and master key on all the user databases.

For tempdb database, you need to restart the SQL Server Instance to complete the process.

Note: It is advisable to take transaction log backup before this activity is performed.