Server and Database Roles in SQL Server All versions of SQL Server use role-based security, which allows you to assign permissions to a role, or group of users, instead of to individual users. Fixed ...

Permissions of SQL Server Agent Fixed Database Roles The [!INCLUDE ssNoVersion] Agent database role permissions are concentric in relation to one another -- more privileged roles inherit the ...

SQL Server 2012 and 2014 are in extended support now, and SQL Server 2016 is less than 18 months from the same status. IT and network managers with applications dependent on SQL Server have an uphill ...

During the last few articles, we have covered the basics of working with SQL server using the Server Management Objects (SMO) and PowerShell. We have covered things such as viewing the state of ...