ASP.NET Resources
	Tutorials & HOW TOs
	ASP.NET Feeds
	Articles
	Blogs - ASP.NET Team
	Blogs - Others
	Conferences & Events
	Forums
	Microsoft KB Articles
	ASP.NET Store
	Books (including reviews)
	Software
	Videos
	ASP.NET Directory
	Applications
	Articles & Samples
	Components & Controls
	Developer Sites
	Hosting Services
Post your ASP Questions here! ASP.NET Hosting .Net software programmers
	.NET Downloads
	.NET Framework 3.5
	.NET Framework 3.0
	.NET Framework 2.0
	Visual Studio 2008
	Visual Web Dev 2008 Express
	Visual Web Dev 2005 Express
	ASP.NET Web Matrix

Store See larger picture MCSA/MCSE/MCDBA: SQL Server 2000 Administration Study Guide, 2nd Edition (70-228) by Rick Sawtell, Joseph L. Jorden, Lance Mortensen, and Joseph Jorden - Sybex List Price: $49.99 Price at Amazon.com: $32.99 (Save 34%) Availability: Usually ships in 24 hours Shipping rates and policies Average Customer Review: Based on 6 reviews. Amazon.com Sales Rank: 369488 Product Description Here's the book you need to prepare for Exam 70-228, Installing, Configuring, and Administering Microsoft SQL Server 2000. This Study Guide provides: In-depth coverage of every official exam objective Practical information on installing, configuring, and administering SQL Server 2000 Real-world insights, advice, and recommendations Hundreds of challenging practice questions, in the book and on the CD Leading-edge exam preparation software, including a test engine and electronic flashcards Authoritative coverage of all exam objectives, including: Installing and configuring SQL Server 2000 Creating SQL Server 2000 databases Managing, monitoring, and troubleshooting SQL Server 2000 databases Extracting and transforming data with SQL Server 2000 Managing and monitoring SQL Server 2000 security Managing, monitoring, and troubleshooting SQL Server 2000 Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file. Featured Customer Reviews Easy to read, but ..., May 23, 2006 I've not decided to get this one before because i already had a couple of SQL books for the 70-228 (Unleashed, 70-228 for Dummies and SQL in 10 min from Ben Forta) book's reviews were not so good either. But ... i went to a major book store last night and i was able to hold the book on my own hands and read some chapters. My 1st impression, after read a few pages quickly, was a good one. Nice explanations...a lot of graphics (i love that, it helped me a lot when i'm studying) It's the kind of book you like to read and you enjoy the lecture at same time. But ... but ... it is not complete and it just gave a quick brief on most of topics. My advice is to get this one only if you already have another book source too (let's say SQL Unleashed). You simply won't pass using this book only. It's a nice book (EXCELLENT EXPLANATIONS AND GRAPHICS) but can't be your main choice. DEFINITELY Incomplete Information, November 27, 2005 I bought this book because 1)I have absolutely ZERO experience with Microsoft SQL 2000 and 2)I have used Sybex books in the past to help me gain knowledge of Windows XP and Windows Server 2003, of which I have passed all exams. However, with this book I am very dissappointed. Examples are imcomplete, not clear and generally leave the reader hanging as to what to do next. More often than not, when working my way through the excercises I have to go to the SQL page on the Microsoft website and try and find the information that was left out of the book. It's a tremendous waste of time and very frustrating. If the authors of this book want to assume that every reader out there already has knowledge of how SQL server is installed and administered, then they should be writing handbooks and pocket guides for existing IT administrators and engineers. Like many people out there who are working on a certification, I bought this book to learn the ins-and-outs of SQL installation and administration. As such, I need to understand every step as much as possible. Unfortunately both the authors and Sybex have failed me this time. Good Contents, April 02, 2005 Coming from Oracle background I am currently using this book to prepare for my MCDBA certification. I would not rate myself as beginner because I have dealt with MS SQL Server on many occasions but not heavily. I am pacing myself with one chapter a day. So far I read about 5 chapters and I would admit that the content is good. Like any other technical book, this one also has some mistakes. In my case I started seeing the mistake on pages 145 and 146. On those pages the authors stated that to see the file id you need to run in the SQL Analyzer the stored procedure sp_helpdb. That is not true at all it should be sp_helpfile. I caught that mistake quickly because I really understood the previous information given and related to file, and I also tested the stored procedures listed in the book. I did check the errata on sybex website nothing is listed concerning that mistake but there are some other corrected mistakes though on the website. As I always do I don't rely on one source for my certification exams. I have got another book and I am planning to get a third one too. I will go through all of them before I go take the exam end of May. I will try to post another review after I took exam. My overall impression on this book is the book is well-written and easy to follow. So far I am getting useful information out of the book. And that helps me understand the objectives on the exam. I am doing pretty good with the review questions at the end of the chapters. After going through half of the book I think I like what I see and I would recommend this book but not as the only source to study for the exam. Explanations Incomplete, February 25, 2005 This book is very uninspired. The layout is pretty good, but I am finding lots of places where there are incomplete explanations which causes lots of wasted time. If you already know the product that wouldn't be bad, but then you wouldn't need this book. Look for a better baisc Admin book. Good Tutorial, Bad Test Prep, June 08, 2004 I really enjoyed this book. It's explaniations are incredibly good and it explains SQL Server very well. However, the exam questions suck. Two Examples: Page 230: Question 4 - It says the correct answer is D, but there is no such command as sp_grantaccess ( It should be sp_grantdbaccess ) Page 232: Question 8 - again, there is no such command as sp_activateapprole, it's sp_setapprole. I could go on, but it's really frustrating trying to use a book for an exam when it misleads like this. You might also be interested in these items... MCSE: SQL Server 2000 Design Study Guide (Exam 70-229) MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server(TM) 2000 Database Design and Implementation, Exam 70-229, Second Edition (Pro-Certification) Inside Microsoft SQL Server 2000 MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server(TM) 2000 System Administration, Exam 70-228, Second Edition (Pro-Certification) MCSE: Windows(r) Server 2003 Network Security Design Study Guide (70-298)