Lynn Pettis (12/21/2009)
I could see developers writing client apps that using Compact and Express editions for holding data in flight locally. TDE may be necessary if those apps hold critical data, particularly if these apps are remote apps using replication back to a central server.
SQL Server 2005 and up comes with standard .NET encryption which allows sensitive data to be encrypted as needed not the whole database.
Kind regards,
Gift Peddie