Blog
User-Defined Server Roles in SQL Server 2012
Excerpt by Don Kiely
A long awaited security feature in SQL Server 2012 has been user-defined server roles.
This course excerpt was originally posted May 30, 2013 from the online courseware SQL Server 2012, Part 5 of 9: Security Basics by Don Kiely
Contained Databases in SQL Server 2012
Excerpt by Don Kiely
Contained databases is an interesting new part of SQL Server 2012. This isn't directly a security feature as such, but it implements a new authentication feature and so has a security element.
This course excerpt was originally posted May 29, 2013 from the online courseware SQL Server 2012, Part 5 of 9: Security Basics by Don Kiely
Understanding Logins with SQL Server
Excerpt by Don Kiely
SQL Server logins are not part of Windows-they are saved in and managed by SQL Server.
This course excerpt was originally posted May 28, 2013 from the online courseware SQL Server 2012, Part 5 of 9: Security Basics by Don Kiely
Windows Logins via Transact-SQL
Excerpt by Don Kiely
Transact-SQL provides full support for creating logins by using the CREATE LOGIN statement.
This course excerpt was originally posted May 23, 2013 from the online courseware SQL Server 2012, Part 5 of 9: Security Basics by Don Kiely