Well, It’s happened again. Hundreds of thousands of private records were stolen from a database. This one, however, was different. No one stole any passwords, no one did any social engineering, nothing was captured in-line. No, this one was accomplished by stealing the actual hard drives themselves!  When a thief breaks in and steals hard drives, you can be sure they know what they are after.

So even if the company had taken all of the regular authentication precautions and so on, the thieves could still take this step. But the data loss could still be prevented…

Enterprise SQL Server 2008 (and later) has a new feature called “Transparent Data Encryption”. When you turn this feature on,  you don’t have to change anything in your applications – from then on, the data files, log files, tempdb and even the data on the backup files are encrypted. Without the certificate you use to encrypt them, the thief can’t get to the data.

I’m sometimes asked why a company should upgrade to the latest version of SQL Server, or why Enterprise Edition is important. A few hundred thousand private records sounds like a pretty good reason to me.