The Evolution of Security in SQL Server 2012

Microsoft rebuilt SQL Security from the ground up in SQL Server 2005, and since then they've evolved database security in each new version. SQL Server 2012 continues that trend with some new features that can keep your data even more secure, such as new server-level role features, new hashing algorithms, and new permissions. It also adds contained databases, which let users connect to the database without authenticating at the server level. This is a great feature that solves problems when you move databases, but it sounds scary from a security perspective. During this Live Learning event, we'll explore all of the new security features in SQL Server 2012. At the end of the session you'll have everything you need to decide for yourself whether your databases will be adequately protected in SQL Server 2012 or if security is getting way too onerous in SQL Server. Sample code and the slide deck can be downloaded from here: https://appdev.box.com/s/3b5660eefe54e29ef086

Recorded: 6/27/2012


Don Kiely

Don Kiely is a featured instructor on many of our SQL Server and Visual Studio courses. He is a nationally recognized author, instructor, and consultant specializing in Microsoft technologies. Don has many years of teaching experience, is the author or co-author of several programming books, and has spoken at many industry conferences and user groups. In addition, Don is a consultant for a variety of companies that develop distributed applications for public and private organizations.