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 (https://blog.sqlauthority.com)

SQL Server Encryption, SQL Server Security, SQL White Papers
Previous Post
SQLAuthority News – SQL Server 2008 – The Other Side of Index – Community Tech Days
Next Post
SQL SERVER – Choose Right Edition of SQL Server Express for Your Application

Related Posts

1 Comment. Leave new

  • 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

    Reply

Leave a Reply