O'Reilly logo

Programming Microsoft® SQL Server™ 2008 by Leonard Lobel, Andrew Brust, and Stephen Forte

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

Security is one of the most important considerations in any project, and the time you spend learning how to lock down SQL Server and your application is worthwhile in the long run. Microsoft has made efforts to increase the security of SQL Server 2008 out of the box by turning off features such as xp_cmdshell, the SQL Server Agent service, and many other optional features within the product. It has also extended the security feature set by adding the ability to easily encrypt data in transit and at rest within the database, by providing more granular permissions and allowing easy context switching, among other examples.

This chapter introduced some of the core concepts of security in SQL Server. You learned about logins, users, roles, and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required