MCSE: SQL Server 7 Administration Study Guide [Hardcover]

Lance Mortensen (Author), Klance Mortensen (Author)

Book Description

Publication Date: May 1999 | ISBN-10: 0782123821 | ISBN-13: 978-0782123821

MCSE Study Guides from Sybex present the most complete solution for candidates preparing for the MCSE exams. Each Study Guide provides:
-- Full coverage of every objective for its exam
-- Real-world examples illustrate key concepts
-- Scores of exercises give you valuable hands-on experience with important procedures
-- Includes a CD containing information resources and a test-preparation program for checking your knowledge and understanding of the material

The six key MCSE Study Guides include a second CD containing computer-based instruction from expert trainers LearnKey, Inc., covering important MCSE topics.

Product Details

• Hardcover: 704 pages
• Publisher: Sybex Inc (May 1999)
• Language: English
• ISBN-10: 0782123821
• ISBN-13: 978-0782123821
• Product Dimensions: 9.1 x 7.6 x 2.1 inches
• Shipping Weight: 3.4 pounds
• Average Customer Review: 3.9 out of 5 stars  See all reviews (17 customer reviews)
• Amazon Best Sellers Rank: #5,020,125 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

14 of 14 people found the following review helpful:

3.0 out of 5 stars Good on SQL 7. Not so for exam., August 2, 1999

By 

scg "scg" (Colorado Springs, CO, USA) - See all my reviews

Amazon Verified Purchase

This review is from: MCSE: SQL Server 7 Administration Study Guide (Hardcover)

I have read this book from cover to cover and performed all the exercises in it. Found the usual amount of errors: exercises that fail, wrong figures, etc. It is still better than most. You will learn a great deal about SQL Server 7. The one error most annoying is the fact the authors wrote the book with SQL installed on a domain controller, not on a member server per Microsoft's installation instructions/recommendations. Once I figured out what they had done then Chapter 5 and parts of Chapter 8 worked since my install was on a member server. Remember the SAM on the member server never receives a copy of the SAM on the PDC so you have to tell the member server about domain accounts by logging onto the member server itself and placing them there via user manager.

However this book does not do much for the test. I have taken both the Beta Exam and the Live Exam and passed. The chapter review questions are extremely easy. Compared to the real exam this book lacks the scenario type questions you will see that are given to you from the perspective of "you're the consultant on site. How would you do this...". While this book did cover traces and replaying them it was a very light run. It did not cover how to modify them and then replay them. Also not covered were issues with NT that could cause SQL to halt/fail.

If you plan on taking the test I recommend the following strategy:

Use this book Use Transcender (I was a Beta tester and it is excellent)

Use Books Online or better yet buy the actual documentation set.

Good Luck

Steven C. Grigsby, MCSE, MCT, MCP+I

9 of 9 people found the following review helpful:

5.0 out of 5 stars Sybex did it again!, December 17, 1999

By 

Gabe Bona "Gabe" (Vancouver, BC Canada) - See all my reviews

This review is from: MCSE: SQL Server 7 Administration Study Guide (Hardcover)

This book together with the "MS SQL Server 7.0 Test Success" helped me to pass the exam on the first try. Nonetheless this is a tough cookie, and you'll have to use the actual product a lot, a lot, a lot. I highly recommend this book.

10 of 11 people found the following review helpful:

5.0 out of 5 stars From a recent MSCE in Argentina, December 7, 1999

By A Customer

This review is from: MCSE: SQL Server 7 Administration Study Guide (Hardcover)

Well. Before I bougth this book I take the Administering exam 4 times... and fail. I didn't take any M$ course, I did it by myslef. I use an Osbornde book that sucks. Then appear the Sybex Administering book and my life changed. A lot of hands off exercises, a clear text and some little mistakes, but the book is excelent. If you use this and books online, and perhaps some exam test like Trancender, you may pass the exam, that is so hard. Well, I did it in 2 weeks with this book and passed with 780/680. Now I'm MSCE and next I'll be MSDBA