Tag: Certificates

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

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

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