Category: Cryptography

• OPEN SYMMETRIC KEY – Avoid the NULL Ciphertext Trap

  

  2014-07-11 - Cryptography, General, Security, Security Pitfalls, T-SQL Statements

  Don’t get caught in this nasty trap that will cause all your encrypted data to be wiped out. Discover how to use the OPEN SYMMETRIC KEY statement correctly to protect yourself (and your data) from this ugly surprise.

  [more…]

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

• The sys.key_encryptions Catalog View

  

  2014-06-23 - Cryptography, DMVs & CVs, General, Security, Security

  Do you have a symmetric key in a SQL Server database but forgot how it is encrypted? Discover how you can use the sys.key_encryptions catalog view to find out which protection mechanisms were used to encrypt the symmetric keys in the current database.

  [more…]

• Five Reasons why You Need to Encrypt Your PHI

  

  2014-06-20 - Cryptography, General, HIPAA, Security

  Are you a covered entity under the HIPAA rules and do you store PHI (Protected Health Information) in your database? Here are five reasons why you really should encrypt that data.

  [more…]

• The sys.symmetric_keys Catalog View

  

  2014-06-16 - Cryptography, DMVs & CVs, General, Security, Security

  Where do you turn if you need information about the symmetric keys in the current database? Meet the sys.symmetric_keys catalog view and discover what types of information on symmetric keys it can provide.

  [more…]