Your Microsoft SQL Server database often contains the most valuable information in your organization. Get tips for securing it properly and effectively in this free, information-packed webinar with Microsoft SQL Server expert Gidget Pryor.
In just an hour, Gidget will demonstrate the layered security approach used by SQL Server. She will step you through the process and best practices of setting up logins, users, roles, schemas, and permissions, and she will review the security model changes that have taken place from SQL Server 2005 through SQL Server 2012. She will also review SQL Server 2012 training and certifications.
Gidget Pryor, SQL Server course director at Global Knowledge, is a SQL Server consultant and instructor with more than 20 years of database, systems engineering, application development, and programming experience. She worked with multiple database platforms including SQL Server, Oracle, DB2, MySQL, FoxPro, Access, and Sybase. She especially enjoys business intelligence and performance tuning.
Outline:
- Logins vs. Users
- Server roles vs. Database roles
- The purpose of schemas
- Defining and combining permissions
- New security features in SQL Server 2012
- Contained databases
- User defined server roles
- Training options for SQL Server 2012