Eric Brown demonstrates some practical encryption techniques in SQL Server 2005, to protect both your objects and your data.