SQL Server security – (Part 1) SQL Server security is based around principals and securables. A principal is a SQL Server object that can be used to grant permissions to securables. A securable is any object that supports permissions. In the first part of the SQL Server security article series, you’ll learn about the two types of authentication SQL Server […]
Tag: SQL Server Security
Microsoft SQL Server security best practices checklist – Part -2
Microsoft SQL Server security best practices checklist – Part – 2 Author: Basit A. Farooq Editor’s Note: This is the second part of my two part article series on SQL Server security best practices. SQL Server Administration Avoid managing SQL Server instances using sa or any other SQL login account that has been granted CONTROL SERVER permission, or is a...