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.