MSDN Article About SQL Server 2005 Security is Online
I wrote an article for MSDN that provides an overview of the new security features in SQL Server 2005, aimed at developers: Keep Bad Guys at Bay with the Advanced Security Features in SQL Server 2005.
Feel free to rate it, if you like it! ;-)