Tag: Cryptography

• PCI DSS Compliance – Is It For Me?

  

  2015-03-28 - General, PCI DSS, Security

  If you have a small or medium sized business, you might be wondering of your business needs to be PCI DSS compliant. Read on to find out now.

  [more…]

• You’ve been Hacked! [T-SQL Tuesday #63 – Security]

  

  2015-02-10 - Audit, Cryptography, General, Security, T-SQL Tuesday

  One Billion – The number of accounts affected by security breaches during the last ten years. Is the data of your customers safe with you?

  [more…]

• Common Database Vulnerabilities: Flawed Key Management

  

  2014-09-23 - Common Database Vulnerabilities, Cryptography, General, HIPAA, PCI DSS, Security, Series

  Encrypting important data is not enough. You also need to handle the encryption keys correctly. Read on to see what flawed key management can result in.

  [more…]

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