CirquedeSQLeil (12/21/2009)

---

I agree with Steve. I would prefer to have extra security on the laptops - not to the level of fully encrypting the entire hard drive. Security as options should be standard across all editions of SQL Server. If the DBA employs those options, that is their decision. As the DBA, I would rather the option be available so I can use it, than be the one questioned, since it is a database, and not have a legitimate answer for the lost data on the laptop.

the company I work for is managing some hundred client sales applications in the pharm business. Most of these are express edition, some larger clients have workgroup edition. I'm a member of the db-development team.
Since customer data in pharm / health care business is very sensitive, we (and most of our customers) would prefer to have stronger security on their data.

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.

Lynn Pettis (12/21/2009)

---

If it can be done transparently at the database level there may be a better chance of developers making use of the technology when it is needed without specialized coding.