Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition
This exam is core credit toward an MCDBA and elective credit toward an MCSE. I just passed the exam -- so I'm documenting what I studied & providing that list to you. I hope you find it and my other lists helpful. I have been working with SQL 7 for 1 1/2 years now, so that is some preaparation.

The passing score was 755 and the time allowed for the test itself was 1 hour and 45 minutes. To my surprise, I didn't get any questions on XML. There was a lot on filegroups, performance monitoring, replication, managing logins, and backup & restore. The questions on indexing dealt with what indexes to create for performance, when to rebuild them, and which ones to have clustered. I did not encounter any questions where I had to calculate the size of a table or index -- though that doesn't mean someone else won't get such questions.

  • 70-228 Exam Objectives
  • Inside SQL Server 2000 by Kalen Delaney is an excellent reference. I intend to read the whole thing, but not everything in the book applies to this exam. I'm noting the chapters besidethe section(s) they cover. The trial version of SQL 2000 comes with this book.

    The software to play with

    If you pass up Delaney's book, you can download the SQL Server 2000 evaluation edition from Microsoft -- or order it on CD for just a few dollars.

    General Information & Resources for SQL Server 2000

  • Books Online (BOL) is downloadable from Microsoft. It is also available as an online, browsable resource. I will be providing links into that version.
  • SQL Server Magazine is a good source for up-to-date articles by some of the sharpest SQL Server gurus.
  • sql.2000trainers.com is a growing site of articles and exams by Mike Aubert. Thanks to Consultant on microsoft.public.cert.exam.mcse for making me aware of this resource.
  • SQL-Server-Performance.Com is dedicated to Microsoft SQL Server Performance Tuning and Optimization. Thanks to Annette West for reminding me of this excellent resource.
  • System Requirements for SQL Server 2000
  • Maximum Capacity Specs by edition -- how much RAM does Enterprise Edition support, How big a DB is supported, etc.
  • How SQL Server 2000 sees Intel Hyperthreading for licensing purposes. The short answer is that SQL Server is fine with it. For Licensing purposes, SQL Server counts only physical processors.
  • The Cramsession on 70-228 is a 16-page guide.
    the Transcender Certification Trainer for exam 70-228


    Resources by Exam Objective

    Installing and Configuring SQL Server 2000

  • Inside SQL Server 2000 chapters 4 & 5
  • SQL Server 2000 Administration Fundamentals -- an overview of installation issues
  • Overview of Installing SQL Server 2000
  • Upgrading to SQL Server 2000: Overview
  • SQL Server Advanced Installations -- covers remote Installations and clusters
  • Configuring Linked Servers
  • SQL Mail and SQLServerAgent Mail
  • Configuring Client Net-Libraries -- Inside SQL Server 2000, pp. 70-74
  • Troubleshoot failed installations. -- That's a pretty broad subject ...

    Creating SQL Server 2000 Databases

  • Inside SQL Server 2000, chapter 5 is excellent for this stuff!
  • Create and manage objects. Objects include constraints, indexes, stored procedures, triggers, and views.

    Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases

  • Optimize database performance. Considerations include indexing, locking, and recompiling.
  • Inside SQL Server 2000, chapter 5, covers data storage & backup & recovery
  • Log Shipping

    Perform integrity checks. Methods include configuring the Database Maintenance Plan Wizard and using the Database Consistency Checker (DBCC).

    Troubleshoot transactions and locking by using SQL Profiler, SQL Server Enterprise Manager, or Transact-SQL.

    Extracting and Transforming Data with SQL Server 2000

  • IIS Virtual Directory Management for SQL Server

    Import and export data. Methods include the Bulk Insert task, the bulk copy program, Data Transformation Services (DTS), and heterogeneous queries.

  • Use Microsoft SQL Server DTS on your next migration project -- TechRepublic article on migrating between platforms using DTS

    Develop and manage DTS packages.

  • Manage Linked Servers
  • Convert data types.
  • Configure, maintain, and troubleshoot replication services.

    Managing and Monitoring SQL Server 2000 Security

    Configure mixed security modes or Windows Authentication. Considerations include client connectivity, client operating system, and security infrastructure.

    Create and manage log ons.

    Create and manage database users.

    Create and manage security roles. Roles include application, database, and server.

    • Add and remove users from roles.
    • Create roles to manage database security.

    Enforce and manage security by using stored procedures, triggers, views, and user-defined functions.

    Set permissions in a database. Considerations include object permissions, object ownership, and statement permissions.

    Manage security auditing. Methods include SQL Profiler and C2 auditing.

  • C2 Certified and Audited -- requires subscription

    Managing, Monitoring, and Troubleshooting SQL Server 2000

    Create, manage, and troubleshoot SQL Server Agent jobs.

    Configure alerts and operators by using SQL Server Agent.

    Optimize hardware resource usage. Resources include CPU, disk I/O, and memory.

    Optimize and troubleshoot SQL Server system activity. Activities include cache hits, connections, locks, memory allocation, recompilation, and transactional throughput.



    If you know of more resources which should be listed here, please email a link to me. I very much appreciate other resources to study and will be sure to acknowledge you on this page.



  • Williamston Consulting is now ...

    Black Locust Software

    Technology Solutions for Business ... Large or Small
    .



    Home

    Auto Dealers' Form Software

    Software Development

    Website Development

    Website Advice

    IT Guys' Stuff:

    Certification
    Study Guides

    Programming
    Tips