Category: Cryptography

• CREATE ASYMMETRIC KEY – How to Generate an Asymmetric Key

  

  2014-05-23 - Cryptography, Encryption Hierarchy, General, Security, Series

  What is the difference between certificates and asymmetric keys in SQL Server and how do you generate asymmetric keys in T-SQL? Read on to get all the details.

  [more…]

• CERTPRIVATEKEY: Scripting the Private Key of a Certificate

  

  2014-05-19 - Cryptography, General, Security

  Find out how to convert the private key of a SQL Server certificate into a varbinary value using the built-in CERTPRIVATEKEY function.

  [more…]

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