Category: Cryptography

• How to Restore a Certificate in SQL Server

  

  2014-05-05 - Cryptography, General, Security

  Do you know how to restore certificates in SQL Server? Read on to find out how, even though there is no RESTORE CERTIFICATE statement.

  [more…]

• sys.certificates: How to get Information about all Certificates in a Database

  

  2014-05-04 - Cryptography, DMVs & CVs, General, Security

  sys.certificates: Find out where to turn when you need information like the name the X.509 subject or the last backup date of a certificate that is installed in the current database.

  [more…]

• 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…]