Microsoft SQL Server 2008, Installation and Maintenance

• Install SQL Server 2008 and related services.

• Configure SQL Server instances.

• Configure SQL Server services. 

• Configure additional SQL Server components. 

• Implement database mail. 

• Configure full-text indexing. 

• Manage SQL Server Agent jobs.

• Manage SQL Server Agent alerts.

• Manage SQL Server Agent operators.

• Implement the declarative management framework (DMF).

• Back up a SQL Server environment. 

• Manage logins and server roles.

• Manage users and database roles. 

• Manage SQL Server instance permissions.

• Manage database permissions.

• Manage schema permissions and object permissions.

• Audit SQL Server instances.

• Manage transparent data encryption.

• Configure surface area.

• Back up databases.

• Restore databases.

• Manage and configure databases.

• Manage database snapshots.

• Maintain database integrity.

• Maintain a database by using maintenance plans.

• Import and export data.

• Manage data partitions.

• Implement data compression.

• Maintain indexes.

• Manage collations.

• Identify SQL Server service problems.

• Identify concurrency problems.

• Identify SQL Agent job execution problems.

• Locate error information.

• Implement Resource Governor. 

• Use the Database Engine Tuning Advisor. 

• Collect trace data by using SQL Server Profiler. 

• Collect performance data by using Dynamic Management Views (DMVs). 

• Collect performance data by using System Monitor. 

• Use Performance Studio. 

• Implement database mirroring.

• Implement a SQL Server clustered instance.

• Implement log shipping.

• Implement replication.