Microsoft SQL Server 2012 User defined Server Roles

In this video we are going to explore the use of User defined Server roles. This feature adds additional security and help DBA follow the principle of least privileges within the DBA group. This feature allows the DBA to create customer roles that have very specific permissions and can be created to suit different unconventional roles within the DBA Group. With this feature we can now secure access to the database and the server based on job role and the DBA becomes securable just like any application roles within the databases residing on the server. Many DBAs might not see this is a big deal but for very large organizations which manage thousands of database servers with a resource pool of hundreds of DBAs it helps keep things manageable.