MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft® SQL Server(TM) 2000 System Administration, Exam 70-228, Second Edition (Pro-Certification) (Hardcover)

~ Microsoft Corporation (Author) "SQL Server 2000 is a family of products designed to meet the data storage requirements of large data processing systems and commercial Web sites, as..." (more)
Key Phrases: sysadmin server role, differential database backup, recent transaction log backup, Server Enterprise Manager, Server Agent, Query Analyzer (more...)

Editorial Reviews

Product Description

Learn how to install, configure, and administer SQL Server 2000--as you prepare for MCP Exam 70-228, a core requirement for MCDBA certification and an elective for the MCSE and MCSA tracks.

Product Details

• Hardcover: 1024 pages
• Publisher: Microsoft Press; 2nd edition (June 11, 2003)
• Language: English
• ISBN-10: 0735619611
• ISBN-13: 978-0735619616
• Product Dimensions: 9.1 x 7.6 x 2 inches
• Shipping Weight: 4 pounds (View shipping rates and policies)
• Average Customer Review: 3.1 out of 5 stars  See all reviews (16 customer reviews)
• Amazon.com Sales Rank: #235,381 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #10 in	Books > Computers & Internet > Certification Central > MS SQL Server
  #51 in	Books > Computers & Internet > Certification Central > Publisher > Microsoft Press
  #54 in	Books > Computers & Internet > Databases > Relational Databases

Customer Reviews

Most Helpful Customer Reviews

53 of 59 people found the following review helpful:

5.0 out of 5 stars If you want to pass the exam or just learn SQL 2000 Server.., September 28, 2003

By A Customer

I have several year of experience with SQL 7.0 and was looking for the resource to tell me the distinct difference between 7.0 and 2000. The book reads well and has plenty of hands on step-by-step labs (if needed). Really the book is two books in one. The second part of the book is preparation for the exam with scenario-based questions. Additionally, the book comes with the usual 120 day Evaluation Edition of SQL 2000 server. Plus a second CD with supplemental course material, electronic version of the book (part 1), scripts for the lab, a test engine ("Electronic Assessment"), ect.

I used the book as the primary source for studying for the 70-228 exam (passed the first time)along with BOL for fine points mentioned in each chapter. I found reading the book forward and then backward increased overall coverage due to interrelationships between chapters (don't worry the book reads fast). Even if you have no experience with SQL server, I think the book will do the trick.

If you have no experience with relational databases, I would suggest picking up a source on database design.

22 of 24 people found the following review helpful:

1.0 out of 5 stars Horrible, horrible book, May 2, 2005

By	C. P. Rosing - See all my reviews (REAL NAME)

I bought this book a little while ago in hopes of using it to help me pass the 70-228 exam. Because of the title of the book and the many different descriptions that it used of itself (something like, "Your guide to getting the real world knowledge you need to pass the 70-228"), I studied it, alone, quite vigorously.

I was making excellent progress through the book and was nailing all of the review questions at the end of each section, so I made my appointment to take the exam. The day before the exam I started using the practice tests that came on the CD. To my surprise, there were quite a few questions on the practice tests that I could not find ANY answers for in the book. This is when I discovered the section in the book that recommends that you read approximately 5-10 other books before taking the exam.

By this time it was too late to cancel my test appointment, so I went and took it in hopes that the practice tests were not representative of how the exam truly is. As it turns out, the practice tests WEREN'T representative of the real exam - the real exam was much worse. On the practice tests, probably half of the questions came from material in the book. On the real exam - I kid you not - there was one question that had anything to do with the material in the book. I had to step out of the testing booth to verify with the proctor that they were giving me the correct exam. I got a 40% on the exam and I got lucky.

Is it my fault that I didn't read the pages that said that I should read other books before taking the exam? Yes, absolutely.
What my main gripe with this book is that there was almost no relevance to what was actually on the 70-228 exam! What is the point of this book? I could write a book titled "The Authoritative Guide to Passing the 70-228!!", talk about nothing but peanut butter sandwiches, but include a page of other books to read, and it would pretty much accomplish what this book did.

The bottom line is that there IS NO point to this book. If you're just looking to learn more about SQL Server 2000 and don't care about the exam, find another book - there have to be better ones than this out there. If you DO care about the exam, this isn't a foundational book, this isn't a supplemental book, this isn't a guide, this isn't anything but a time waster. DO NOT buy this book.

13 of 14 people found the following review helpful:

3.0 out of 5 stars Not the winning exam study guide one would employ to segue into a winning sitting for Exam 70-228, May 30, 2006

By	derazz "derazz" (Geneva, Versoix Switzerland) - See all my reviews

I used this guide as part of my revision portfolio for Exam 70-228 (SS2K admininstration).
I got it despite the wonky caveat-type reviews because i wanted to get some specific exam lab-time in.

verdict:
Though, I applied myself to all 16 chapters as best one can with a single instance of SS2K (developer edition) running on a WinXP Pro OS laptop; It became clear to me that the quest was far from over, post the sun setting on the book.

-What i liked Re: d book (d upshot): chapters on Backup & Recovery Plus the chapter on Security , Plus the portable e-book version of d book included on the accompanying CD.
-What was more like passing-shot: the rest of book seemed just ho-hum, side-line material vis-a-vis the final exam paper questions

-what i did about it: I had to go away and button up specific topic holes/sections of knowledge via other references.

Book References: that helped: selected out were the following:

- SQL Server 2k Fast Answers: Sack ;ISBN: 1590595920
Value: Clustering , Failover clustering, Log Shipping,Security & sp_defaultdb, Cascading Updates + check constraints

- SS2k Performance Tuning & Optimization: Ken England: ISBN: 1555582419
Value: good for plugging holes Re:locks & transactions, monitoring performance & how to use System monitor & Interprete Sys Mon Counters ie: % Processor time, % Priviledge time, as well as Lock modes

- Inside SQl Server2K: ISBN: 0735609985
Value: handle on Conducting C2 Security-level Server audits + Understanding Affinity Masks + Performance Counters + RAID, Understanding Primary Domain Controllers, Data placement using filegroups, Full-text indexing + searching & catalogs, File and filegroup restores, Using Global temporary tables, Recovery models, Explicit & Implicit Tansactions & Triggers,Locking , Lock modes & Lock Granularity & Query Lock Hints, Lock Compatibility, Setting up Profiler Traces

- Professional SS2K Programming: Rob Viera:ISBN: 0764543792 Value: Practise Using DTS, Replication

- Beginning SS2K DBA : Bane and Sack ;ISBN: 159059293X (2 of my favorite authors)
Value: This is the book most beginning SS2K DBA's use (i especially like the 'try-it-out' feature peppered ,littered/implanted throughout). DML and Querying + Connectivity:Network libraries & Protocols, Security Replication, Backup & Recovery:Differential backups. How to Monitor+Profile+Tune

- Admin 911:SS2K ISBN:0072130970 Values:Backing up individual Files and File groups

However, if u dont have the time or the resources to check out these references in order to plug these exam-readiness holes up, then do this instead :
-Get a copy of Certification study guide for 70-228 from Test Killer a.k.a "troytec" (Version 3) ...google it
Value: This gets right to business & cuts right to the heart of the Exam ; u'll find only tire-meets-road stuff here, no fluff. its a ".pdf" document of 67 neatly put together pages, requiring u to only put down a Time-resource investment down-payment of 15 to 20 hrs of study time. its all packaged rather nicely for one.

use this, and your exam-topic revison will be concrete .

Bottom line: u'll get to read exactly what ur going to meet, see & get in the exam .

After the study guide, u have the basics of all u'll need. all u need now is just solid exam past question practice time .
Select the following:
- Transender 70-228, answer all 135 question; Here's the Important bit :( take care to read and understand the explanations where u go wrong)
- Testking 70-228, answer all 142, or 203 questions (get the most recent version u can find with question answers verified & mind the important bit as mentioned for Transcender.
- BrainDumps dot com's exam 70-228 slice : same as testking.

The only caveat in these various past question papers is that you need to ensure the responses have been verifed ( u may need to dip into one or two of those book references cited earlier in order to have a final authoritative stand/answer to 2 to 3 questions.

et voila! finish these properly and for sure, u are going to pass.

So, in summary, here's a recap of the formula that worked:
Starting Point:
Level :
0.) Books on Administring SS2K & then some Labs with some actual hands-on practise time in using the db application to carry out admin (u need to know your stuff)

Exam Review & Revision Practise (fast track):
Level:
1.) Study Guide : Test Killer -(troytec) Version 3.0 Study guide 70-228 (15-20 hrs)
2.) Past 70-228 Exam Questions practise: Transcenders, Testking,BrainDumps
3.) Take & Ace the exam with ease: 160minutes & 45 questions

Conclusion: your answers are weighted , so u need to choose wisely & correctly.

Otherwise, its very much like 70-229: in that you need to tackle question regarding problem scenarios in order to sharpen your wits about employing/selecting the right solution / strategy in any given problem scenario. this is the crunch of it. do that ,and u pass

End Of.

oh yeah, i sat the exam just yesterday ie:( Tuesday 30th May 2006); scored 94% ie: 948. The pass mark is 700 ie: 70%.

Good luck.

cheers :-)