Fixed server roles have a fixed set of permissions and server-wide scope. They are intended for use in administering SQL Server and the permissions assigned to them cannot be changed. Logins can be ...

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part ...

Alternatively, the xref:Microsoft.SqlServer.Management.Smo.User object's xref:Microsoft.SqlServer.Management.Smo.Login property specifies the logon that is associated with the user. [!INCLUDE ...

We can group together multiple Database User Accounts that have similar security requirements into Database Roles.

While we've covered how to add users to the database, let's take it one step further and designate specific roles.

In SQL Server 2000, it was difficult to allow users to see the SQL Server Agent jobs on your database server without giving the user sysadmin permissions.

There's a very handy new tool from Microsoft called the Database Experimentation Assistant (DEA). The DEA makes it very easy to conduct A/B testing for SQL Server upgrades, providing quantitative ...