Chapter 18. Security
After completing this chapter, you will be able to
Configure a secure surface area
Work with endpoints
Manage principals, securables, and permissions
Encrypt and decrypt data
The primary job of a database administrator (DBA) is to protect the data within the databases that they manage. Protecting the data is accomplished through two main tasks: backing up databases and securing databases. In this chapter, you will learn about one of the two most important tasks that a DBA can perform. You will learn how to limit the feature set to reduce your security exposure. You will also learn how to control access to an instance and database object as well as encrypt data and databases.
Configuring the Attack Surface
Security is an exercise ...
Get Microsoft® SQL Server® 2008 Step by Step 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.
