locked
Process of data encryption in SQL 2012 RRS feed

  • Question

  • Hi,

    What is the process of data encryption in SQL 2012?


    Tnx

    Wednesday, June 13, 2012 5:38 AM

Answers

  • Hi MGerio,

    There’re two levels encryption in SQL Server 2012 which including column level encryption(data encryption) and database level encryption. The main processes of this two levels of encryption are following:

    1. Column Level Encryption(Data Encryption)
    Create master key which will be used for creating digital certificate, and certificate will be used for generating the symmetric key, and symmetric key will finally be used for encrypting data in individual columns. For more details, please refer to following links which sushil mentioned above:
    • Data Encryption in SQL Server 2008, 2008R2, 2012: http://blog.webagesolutions.com/archives/658
    • Encrypt a Column of Data: http://msdn.microsoft.com/en-us/library/ms179331

    2. Database Level Encryption(Transparent Data Encryption, TDE)
    Unlike column level encryption, transparent data encryption is performed automatically by the Database Engine, and this is fully transparent to the end user and applications. The encryption of a Database using TDE helps prevent the unauthorized access of data in the scenario in which physical media or backups have been lost or stolen. Implementing TDE for a specific Database is accomplished by subsequent these steps:
    1) Create a master key.
    2) Create or obtain a certificate protected by the master key.
    3) Create a Database encryption key and protect it by the certificate.
    4) Configure the Database to use encryption.
    For more details, please refer to following links:
    • Transparent Encryption in SQL Server 2012: http://www.infotechguyz.com/SQLServer2012/TransparentEncryptioninSQLServer2012.html
    • TDE(Transparent Data Encryption) in SQL Server 2012 RC 0: http://sqlsailor.com/2011/12/29/tdetransparent-data-encryption-in-sql-server-2012-rc-0/
    • Transparent Data Encryption (TDE): http://msdn.microsoft.com/en-us/library/bb934049


    Best Regards, Ray Chen

    Thursday, June 14, 2012 10:29 AM
    Answerer

All replies

  • Hi ,

    check this

    http://msdn.microsoft.com/en-us/library/ms179331.aspx

    http://sqlsailor.com/2011/12/29/tdetransparent-data-encryption-in-sql-server-2012-rc-0/

    http://blog.webagesolutions.com/archives/658

    Wednesday, June 13, 2012 5:49 AM
  • Hi MGerio,

    There’re two levels encryption in SQL Server 2012 which including column level encryption(data encryption) and database level encryption. The main processes of this two levels of encryption are following:

    1. Column Level Encryption(Data Encryption)
    Create master key which will be used for creating digital certificate, and certificate will be used for generating the symmetric key, and symmetric key will finally be used for encrypting data in individual columns. For more details, please refer to following links which sushil mentioned above:
    • Data Encryption in SQL Server 2008, 2008R2, 2012: http://blog.webagesolutions.com/archives/658
    • Encrypt a Column of Data: http://msdn.microsoft.com/en-us/library/ms179331

    2. Database Level Encryption(Transparent Data Encryption, TDE)
    Unlike column level encryption, transparent data encryption is performed automatically by the Database Engine, and this is fully transparent to the end user and applications. The encryption of a Database using TDE helps prevent the unauthorized access of data in the scenario in which physical media or backups have been lost or stolen. Implementing TDE for a specific Database is accomplished by subsequent these steps:
    1) Create a master key.
    2) Create or obtain a certificate protected by the master key.
    3) Create a Database encryption key and protect it by the certificate.
    4) Configure the Database to use encryption.
    For more details, please refer to following links:
    • Transparent Encryption in SQL Server 2012: http://www.infotechguyz.com/SQLServer2012/TransparentEncryptioninSQLServer2012.html
    • TDE(Transparent Data Encryption) in SQL Server 2012 RC 0: http://sqlsailor.com/2011/12/29/tdetransparent-data-encryption-in-sql-server-2012-rc-0/
    • Transparent Data Encryption (TDE): http://msdn.microsoft.com/en-us/library/bb934049


    Best Regards, Ray Chen

    Thursday, June 14, 2012 10:29 AM
    Answerer