Join this chat session that will walk you through some of the security features that were introduced in SQL Server 2005 (Yukon). This will outline features like user-schema separation, signed modules, encryption capabilities, architectural changes etc.