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.

Get Professional Microsoft® SQL Server® 2008 Administration now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.