Don Kiely has an article in the June MSDN Magazine (I still haven't gotten my copy yet but it is online now) where he looks at what he thinks are the most interesting security enhancements in SQL Server 2005. It's called Hackers Beware: Keep Bad Guys at Bay with the Advanced Security Features in SQL Server 2005. This is all good stuff for us developers who have to work with SQL Server all the time but still are not DBAs. This will be good reading for my plane trip I am taking tomorrow.