Introduction

In terms of difficulty, you will find the Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 (70-444) exam easier than some of the other Microsoft SQL 2005 exams. This is especially true if you at least have experience with administering SQL Server 2000—based solutions. This is partly because the underlying core responsibilities of the database administrator (DBA) have not changed between releases. Experience with administering SQL Server 2005 of course will help immeasurably.

As a DBA, you are responsible for ensuring optimal performance of your SQL Server 2005 instances. This typically involves both a proactive approach and a reactive approach. Although proactive monitoring will allow ...

Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide 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.