Tag: Certificates

• CERTPROPERTY – Digging Deeper into SQL Server Certificates

  

  2014-05-12 - Cryptography, General, Security

  Discover how to read the properties of a specific SQL Server certificate using its certificate_id and the built-in CERTPROPERTY function.

  [more…]

• How to Drop a Certificate Conditionally with CERT_ID

  

  2014-05-09 - Cryptography, General, Security

  Discover how CERT_ID can be used to conditionally execute statements (like a drop or create) based on the existence of a specific certificate, since it returns a noon-NULL value only if the certificate exists.

  [more…]

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