SQL Server DBA

SQL Server 2008 Installation & Features

Installing SQL Server, Essential Tools

Creating & Managing Databases

Storage Structures, Managing Database Space, Moving Databases

Implementing Server & Database Security

Creating Logins, Authorising Database Access

Managing Permissions

Granting Database-Scoped Privileges, Schemas, Handling Object-Level Permissions

Recovering From Disasters

Backingup Databases, Restoring Databases

Automating Tasks with Jobs & Alerts

The SQL Server Agent, Multistep Jobs

Performing Database Maintenanace

Fragmentation & Database Corruption, Database Maintenance Plan Wizard

Monitoring SQL Server

Ad hoc Monitoring, The Management Data Warehouse