#title Transparent Data Encryption 
[[TableOfContents]]

==== Create a Master Key ====
{{{
USE master;
CREATE MASTER KEY 
ENCRYPTION BY PASSWORD = 'Pass@word1';
GO
}}}

==== Create a Certificate ====
{{{
USE master;
CREATE CERTIFICATE TDECert 
WITH SUBJECT = 'TDE Certificate'
GO
}}}

==== Create a Database Encryption Key ====
{{{
CREATE DATABASE mssqltips_tde
GO
USE mssqltips_tde;
CREATE DATABASE ENCRYPTION KEY
WITH ALGORITHM = AES_256
ENCRYPTION BY SERVER CERTIFICATE TDECert
GO
}}}

==== Enable TDE ====
{{{
ALTER DATABASE mssqltips_tde
SET ENCRYPTION ON
GO
SELECT [name], is_encrypted FROM sys.databases
GO
}}}

==== 참고자료 ====
 * [http://www.mssqltips.com/sqlservertip/2641/sql-server-transparent-data-encryption-tde-performance-comparison/ SQL Server Transparent Data Encryption (TDE) Performance Comparison]
 * http://www.sql-server-performance.com/articles/dba/Transparent_Data_Encryption_p1.aspx
 * [http://www.sqlservercentral.com/articles/Transparent+Data+Encryption/66334/ Transparent Data Encryption (TDE) SQL Server 2008]
 * [http://databaser.net/moniwiki/wiki.php/TransparentDataEncryption?action=edit&section=5 Understanding transparent data encryption in SQL Server 2008]