Microsoft test 70-228 focuses on your ability to set up and manage SQL Server 2000 solutions at a system level. To successfully pass the 70-228 test, you should practice the following:
- Install and uninstall SQL Server 2000.
- Install and upgrade earlier versions of SQL Server.
- Import and export data using the Bulk Insert task, the bulk copy program, and Data Transformation Services (DTS).
- Create a link server and run ad hoc queries using the OPENQUERY function.
- Set up and configure a replication server.
- Set up IIS virtual directories to support XML.
- Use SQL Profiler and capture, analyze, replay, and study traces.
- Use System Monitor to optimize hardware resource usage.
- Configure alerts and operators by using SQL Server Agent.
- Define object level security including database, tables, and column level permissions.