What’s New in Security for Microsoft SQL Server Code-Named "Denali"

Our current security for SQL Server 2008 & R2 is set up fine. Should try to get rid of any SQL Server logins when going to R2

New Security items in "Denali"
Special Schema's for Groups
Server specific roles
Now have an audit feature to replace SQLTrace.
User defined audit event: sp_audit_write()
Record filtering in the audit log
T-SQL Stack Information
Database Authentication

Location:TechEd 2011