SQL Server 2012 security: Changes for the newest version

Database infrastructure security is extremely crucial for any organization, which is why Microsoft has invested heavily in SQL Server security features in recent years. Microsoft redesigned the SQL Server database security engine from scratch for SQL Server 2005, and since then, SQL Server security has improved with each update.

Microsoft SQL Server 2012 continues this trend with an extensive collection of new security features and enhancements. These enhancements not only help organizations to improve access controls to data, but also to achieve the highest level of data protection and compliance. Also, these features help make SQL Server arguably the most robust common database platform from a security perspective, with less vulnerability and fewer security patches needed to maintain the system.

Checkout my article here that list all security enhancements which DBAs expect in SQL Server 2012.

This article is published on SearchSQLServer.techtarget.com.

Creating and Managing User-Defined Roles in SQL Server 2012

SQL Server 2012 introduces user-defined server roles. These user-defined server roles are similar to fixed server roles with only difference is that they are created by SQL Server Administrator. SQL Administrators can create, delete or manage these user-defined server roles using T-SQL or SQL Server Management Studio. User-defined roles can be added as member of another user-defined or fixed server role. Like SQL Server logins, we can only also assign server-wide permissions to these user-defined server roles.

Checkout my article (ie Creating and Managing User-Defined roles in SQL Server 2012) that discusses how these user-defined roles can be used to simplyfy the administration of SQL Server.

This article is published on SSWUG.org.