SQL Server MVP Randy Dyess has a short webcast which provides the highlights of SQL Server 2008 security.He includes some demos which show the centralized management features inherent in SQL Server 2008.
You can find it on the SQL Server Magazine's site. It is part of the SQL Server 2008 video cast series:
SQL Server 2008 Video Cast Series - SQL Security