O'Reilly logo

Professional Microsoft® SQL Server® 2008 Administration by Steven Wort, Ross LoForte, Wayne Snyder, Ketan Patel, Brian Knight

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

Chapter 9. Securing the Database Engine

In this chapter you learn how to use the security features of SQL Server 2008 to protect your SQL Server and the data it contains. While SQL Server security has generated entire books on the subject, it isn't too hard to learn the basics and tighten down your SQL Server 2008 system. This chapter focuses on those basics, such as implementing logins and users according to the principle of least privilege. This chapter also takes a look at additional security features built into the core engine, such as encryption, which debuted in SQL Server 2005 and has been enhanced in SQL Server 2008; the new audit features developed to help DBAs better meet regulatory compliance, such as with Sarbanes-Oxley; and what aspects of Policy-Based Management (covered in detail in Chapter 10) to use to increase the overall security of your SQL Server installation.

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