MCSA MCSE MCDBA Self-Paced Training Kit: Microsoft SQL...

Features

• Cover Type: Paperback with 1024 pages
• Published by: Microsoft Press
• Edition: 2nd Edition June 11, 2003
• Written in: English
• ISBN 10 Number: 0735619611
• ISBN 13 Number: 978-0735619616
• Book Dimensions: 9.1 x 7.6 x 2 inches
• Weighs: 4 pounds

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.

Reader 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 twenty 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 :-)