Adi Cohn-120898 (12/20/2009)
I’m not so sure that users will use the TDE on Express edition. Most of the time Express edition is not managed by a DBA. In fact in most of the time the Express edition is being installed by another software and many times the DBA is not even aware of those editions that are installed in his organization. The users that use those applications are not database professionals and wouldn’t know what TDE is and how to use it (in fact many times they also are not aware that SQL Server Express edition is used by their software). In short I think that if TDE will be supported on Express edition, it will hardly be used.Adi
I have to disagree with the point of your post.
I agree with Steve that it should be available. As with all security (and almost all other features), use of it is up to the DBA, whether that's a pro DBA or someone who "knows computer stuff" and doesn't even know how to spell "DBA".
The attitude you're expressing is comparable to saying, "Why even have keys for cars? Some people just leave the key in and the doors unlocked, so why bother even making cars that use keys?"
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon