Category: General

• The Cost of a Data Breach

  

  2014-08-22 - General, HIPAA, PCI DSS, Security

  Can you afford the immediate as well as the hidden cost of a data breach in your company? Find out now.

  [more…]

• Common Database Vulnerabilities: Privilege Abuse

  

  2014-08-18 - Common Database Vulnerabilities, General, Security, Series

  Privilege abuse comes in two forms: Abuse of excessive and of legitimate privileges. Discover how to protect your environment from this vulnerability.

  [more…]

• Hey, where is my BLOB?

  

  2014-08-13 - General, Series, SQL Server Internals, Storage Wednesday

  LOB values are not always stored in the special LOB_DATA allocation unit. But, where else could they be? Discover the well-kept secret of the Inline LOB.

  [more…]

• How to Access Passphrase-Encrypted Data

  

  2014-08-11 - Cryptography, General, Security

  What do you need to do to decrypt data that was encrypted with ENCRYPTBYPASSPHRASE? Read on to see the DECRYPTBYPASSPHRASE function in action.

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