Tag: built-in function

• HASHBYTES: How to Calculate a Cryptographic Hash in T-SQL

  

  2014-07-07 - Cryptography, General, Security

  The HASHBYTES function provides a simple way to calculate cryptographic hash values in T-SQL. Read on to learn how to use this function and discover its two limitations.

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