Tag: Cryptography

• CERTENCODED: How to Script your Certificates

  

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

  The ability to copy certificates from one database to another is often an important requirement in SQL Server security management. Read on to learn how to do just that effectively.

  [more…]

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