Chapter 7. SQL Server System and Database Administration

This chapter outlines the role of a SQL Server system administrator and explores some of the methods that an administrator can use to query important system data. As with any other job, understanding the roles and responsibilities of the job is critical to doing the job well. The responsibilities of an administrator vary depending on the job, but there are some core responsibilities covered in this chapter.

You also need the right tools and right information to do the job well and do it efficiently. ...

Get Microsoft® SQL Server 2008 R2 Unleashed 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.