[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

Transparent Data Encryption



Analysis Services
CLR Integration
High Availability
Open Source
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019

Transparent Data Encryption

Applies: SQL Server 2008 (Katmai) CTP November 2007, SQL Server 2008 Enterprise Edition

SQL Server 2005 provides ways to encrypt pieces of data (views, UDFs, stored procedures and triggers), but now SQL Server 2008 Enterprise Edition allows to encrypt data at the database level, and that feature is called Transparent Data Encryption.

With Transparent Data Encryption all files of a database are encrypted without the need for application changes.

Benefits of Transparent Data Encryption.

Some benefits of Transparent Data Encryption:

bullet It provides the ability to comply with many regulatory requirements
bullet Simple and elegant
bullet A strong mechanism to secure sensitive information
bullet Transparent. Changes to programming applications are not required.

Q & A.

What happen if you need to restore or detach/attach an encrypted database on a different server or instance?

The certificate that was used to encrypt the database encryption key must be available. Otherwise, the operation will fail.


Using Transparent Data Encryption.


The following example illustrates encrypting a test database using a certificate installed on the server named MorilloCert.

First,  let's create a database on which to apply encryption.



Now, let's open the query editor and encrypt the database.



Finally, let's find the state of the database encryption.



.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.