Understanding database encryption in SQL Server 2008

I recently needed to investigate the possibilities of encrypting an SQL Server 2008 database. Of course, as a developer I could quite easily write C# code to encrypt my data with some key (using DPAPI like solutions, for example) and then store that data to the database. Simple and clean.

However, as I recalled from earlier investigation to the product, it turns out SQL Server 2008 has expanded the encryption capabilities in the latest version, meaning that developers don't need to do as much work as they used to do to get proper encryption in place.

On MSDN, there's a nice article about database encryption in SQL Server 2008 Enterprise Edition, which I suggest you to read. As with many security related topics, it's better to be safe than sorry. And even if you don't need encryption just today, it's good to know that there are such things available once you do.