Tag: security

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

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