SQLAuthority News – Database Encryption in SQL Server 2008 Enterprise Edition

Database Encryption in SQL Server 2008 Enterprise Edition
SQL Server Technical Article
Writers: Sung Hsueh
Technical Reviewers: Raul Garcia, Sameer Tejani, Chas Jeffries, Douglas MacIver, Byron Hynes, Ruslan Ovechkin, Laurentiu Cristofor, Rick Byham, Sethu Kalavakur
Published: February 2008

TDE does not replace cell-level encryption, EFS, or BitLocker. This white paper compares TDE with these other encryption methods for application developers and database administrators. While this is not a technical, in-depth review of TDE, technical implementations are explored and a familiarity with concepts such as virtual log files and the buffer pool are assumed. The user is assumed to be familiar with cell-level encryption and cryptography in general. Implementing database encryption is covered, but not the rationale for encrypting a database.

Read Database Encryption in SQL Server 2008 Enterprise Edition

Abstract courtesy : Microsoft

Reference: Pinal Dave (http://blog.sqlauthority.com)

About these ads

One thought on “SQLAuthority News – Database Encryption in SQL Server 2008 Enterprise Edition

  1. Hi Pinal

    USE master;
    GO
    CREATE MASTER KEY ENCRYPTION BY PASSWORD = ”;
    go
    CREATE CERTIFICATE MyServerCert WITH SUBJECT = ‘My DEK Certificate’;

    use DbName
    go
    CREATE DATABASE ENCRYPTION KEY
    WITH ALGORITHM = AES_256
    ENCRYPTION BY SERVER CERTIFICATE MyServerCert;

    I am getting below Error Please suggest:
    Cannot find the certificate ‘MyServerCert’, because it does not exist or you do not have permission.

    Note : Cerificate are there on named ‘MyServerCert’

    Server Configuration :
    Window Server : 2003 SP2
    SQL Server 2008 Cluster with Enterprise Edition SP1

    Regards
    Jayant Dass

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s