Security Enhancements in SQL Server 2012

The following list shows a few of the improvements that will appeal to organizations looking to gain
maximum security and control of their database platform:

1. Security manageability improvements
• Default schema for groups
• User-defined server roles

2. Audit enhancements
• Audit supported on all SKUs
• Improved resilience
• User-defined audit event
• Record filtering
• T-SQL stack information

3.Database authentication enhancement: contained databases authentication

4. Crypto changes
• Hashing algorithms
• Certificate key length
• Service master key and database master key encryption changes from 3DES to AES

5. Miscellaneous security enhancements
• Tight Integration with SharePoint and Active Directory
• Provisioning enhancements
• New permissions

This chapter describes each of these new security enhancements introduced in SQL Server 2012,
starting with security manageability improvements.