Make sure your network’s SQL Servers are secure, using best practices for physical, instance, network, and file system security. Gerry O’Brien introduces basics like SQL Server securables, principals, logins, users, and roles. Then learn how SQL Server checks permissions and use that information to create accounts and assign logins and roles. Last, Gerry explains common network security risks and steps you can take to secure network protocols.
Topics include:
Understanding security best practices
Managing logins and users
Understanding how SQL Server checks permissions
Creating and assigning logins and roles
Securing SQL on the network