Tag: security

• How to Encrypt a Column with a Passphrase

  

  2014-08-08 - Cryptography, General, Security

  If you are searching for a quick and dirty way to encrypt data in SQL Server, the ENCRYPTBYPASSPHRASE function might be just what you are looking for.

  [more…]

• Temporary Symmetric Key Conflicts

  

  2014-08-04 - Cryptography, General, Security, Temporary Objects

  Temporary symmetric keys are a great idea. However, SQL Server’s current implementation falls apart based on a requirement that makes them all but usable.

  [more…]

• What, You Are Not Using Two-Factor Authentication?

  

  2014-08-02 - General, Passwords, Security

  If you are not using two-factor authentication, your data is at risk. Read on to find out exactly why you should enable two-factor authentication now.

  [more…]

• How to Create Temporary Symmetric Keys

  

  2014-07-25 - Cryptography, General, Security, Temporary Objects

  Temporary symmetric keys in SQL Server behave similar to temp tables. In particular, they are stored in tempdb and automatically go away at the end of the session. Make sure however that you do not get caught creating a non-recreatable temporary symmetric key…

  [more…]

• How to Create Two Identical Symmetric Keys

  

  2014-07-21 - Cryptography, General, Security

  SQL Server provides only one way to re-create a symmetric key multiple times. Read on to find out about the necessary extension to the CREATE SYMMETRIC KEY statement.

  [more…]