Tag: security

• Debunking Symmetric Key Recreate-Ability

  

  2014-07-18 - Cryptography, General, Security, Security Misconceptions

  Do you think you can recreate a symmetric key that is protected by a certificate, by just using that same certificate? You might be in for a big surprise…

  [more…]

• How to Crack the Symmetric Keys in the Database Wide Open

  

  2014-07-14 - Cryptography, DMVs & CVs, General, Security, Security, SQL Server Internals

  Did you always want to get to the root of symmetric key encryption in SQL Server and actually decrypt a protected symmetric key? In some circumstances this can actually be done. Find out how to do this now.

  [more…]

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

• Security Blues [T-SQL Tuesday #56 – Assumptions]

  

  2014-07-08 - General, Security

  When it comes to security related investments, we often make excuses why we should not invest now. But think about the impact a random breach can have., not only on you but on your clients, the very people that trusted you.

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