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:

  1. Install and uninstall SQL Server 2000.
  2. Install and upgrade earlier versions of SQL Server.
  3. Import and export data using the Bulk Insert task, the bulk copy program, and Data Transformation Services (DTS).
  4. Create a link server and run ad hoc queries using the OPENQUERY function.
  5. Set up and configure a replication server.
  6. Set up IIS virtual directories to support XML.
  7. Continue reading

Check out Sonya’s 70-228 uCertify Prepkit review

Sonya A. McNeal (MCSE, MCDBA, MCITP, MCTS, MBS CRM 3.0, SBSS, and MCT) has been working with various technologies and as a consultant and trainer for the last 11 years. She has also worked for various clients and organizations as an Architect and Solution Professional. She is currently working on numerous articles in order to benefit beginners and professionals for designing SQL Server 2008 Business Intelligence solutions. Continue reading