SQL Server 2008

Installation and Configuring

(File Locations,default paths,service accounts, sp_configure, configuration manager,SQL browser,

SSIS,SSAS,SSRS. Database Mail, Full text searching.

Installation of Cluster

SQL Server Agent Jobs.

Operator Management

Security

Logins ans server roles

Database roles

cross-database ownership,impersonation

Manage database permission, schema permission.

Auditing.

Data Encryption

Configure Surface Area.

Backups and restoration.

Database Options;recovery model;attach/detach data

Database Snapshot

Integrity Check : DBCC

Monitoring and Troubleshooting

blocks,deadlocks,activity monitor,DMV

Location Error Information

error log;agent log, job executin log; event logs

Optimization

Indexes

Resource Governor

Database Tuning Advisor

Dynamic Management Views

High Availability

Database Mirroring

Clustering

Log Shipping

Replication.