Tag: Cryptography

• How to Back Up Your Certificates

  

  2014-05-02 - Backup, Cryptography, General, Security

  Certificates are an important part of you encryption strategy and as such need to be backed up. Discover how to achieve that, by using the BACKUP CERTIFICATE statement.

  [more…]

• CREATE CERTIFICATE – How to create a Self-Signed Certificate in SQL Server

  

  2014-04-28 - Cryptography, Encryption Hierarchy, General, Security, Series

  Discover how the CREATE CERTIFICATE T-SQL statement can be used to create a self-signed certificate, and what your options are to protect its private key.

  [more…]

• How to Create a Database Master Key

  

  2014-04-27 - Cryptography, Encryption Hierarchy, General, Security, Series

  Discover how to create and protect the Database Master Key that builds the base of a database encryption hierarchy and in turn can protect certificates and asymmetric keys in its database.

  [more…]

• How to Create a Service Master Key in SQL Server

  

  2014-04-25 - Cryptography, Encryption Hierarchy, General, Security, Series

  Discover how the service master key is created, what it protects and how it is protected itself, and learn about the two important security implications that arise from the protection mechanism used.

  [more…]

• The SQL Server Encryption Hierarchy

  

  2014-04-20 - Cryptography, Encryption Hierarchy, General, Security, Series

  Discover how in SQL Server the different encryption keys can build a complex encryption hierarchy in which one key protects the next.

  [more…]