Databases Robert Sheldon in Databases SQL Server Contained Databases: Users & Portability How SQL Server's partially contained databases work — creating contained users, duplicating them across databases, and unlinking users from logins.… 25 February 2019 15 min read
SQL Server Robert Sheldon in SQL Server SQL Server Access Control: Logins, Roles & Permissions How to create SQL Server logins, roles, and database users, then grant, deny, and revoke permissions on them with T-SQL... 28 January 2019 24 min read
SQL Server Robert Sheldon in SQL Server SQL Server Security Overview: Authentication to Encryption An overview of SQL Server's security toolkit — authentication modes, principals/permissions, encryption, auditing, and vulnerability tools.… 31 December 2018 15 min read