MCSE System Administration for Microsoft SQL Server 7 [Hardcover]

Jeffry Byrne (Author)

Book Description

ISBN-10: 0130107956 | ISBN-13: 978-0130107954 | Publication Date: January 15, 1999

This is a great guide to passing Microsoft's System Administration for Microsoft SQL Server 7 exam - and every bit as valuable once you've passed the exam and you're running an SQL Server system. Written by a top SQL Server expert, the book starts with an overview of SQL Server 7 and SQL fundamentals, then shows how to build database objects - including tables, views, database roles, stored procedures, indexes, and more. It reviews key SQL Server components, including the Distributed Transaction Coordinator, SQL Server Agent, SQL Mail, Replication Monitor, Data Transformation Packages and more. From start to finish, it delivers comprehensive guidance on planning, installing, configuring and optimizing SQL Server 7. The book includes test questions at the end of each chapter, sample texts in the appendix, access to an interactive training Web site - even a free CBT Systems course on the CD-ROM, worth $225!

Editorial Reviews

From the Back Cover

Supercharge your training with EXCLUSIVE Web & interactive resources!
We've teamed with CBT Systems, the world's #1 developer of IT self-paced training, to include a state-of-the-art interactive training course on CD-ROM -- worth $225! And that's not all: Every Prentice Hall PTR MCSE book is 100% integrated with its own exclusive MCSE training Web site, delivering all this, and more...


*Interactive test Q&A section

*Projects you can complete - with detailed solutions

*Virtual Study Lounge: interact with students, authors and trainers on-line!

*Author's Corner: Book & exam updates, training news and more

*Expert techniques for database planning, installation, configuration and security

*Managing databases for maximum integrity, consistency and concurrency

*Publishing SQL Server 7 data on the Web

*Replication: planning, configuration and management

*Backup and restore - step-by-step!

*Complete sample test, plus 100+ extra questions and answers!

*Pass Microsoft's SQL Server 7 MCSE exam - with flying colors!

This isn't just a great guide to passing Microsoft's SQL Server 7 System Administration exam: it's an equally spectacular guide to actually running your SQL Server database system!
You'll start with a detailed overview of SQL Server 7's fundamentals - including logical structures, Key components and the Transact-SQL language. Walk step-by-step through planning, installing and configuring your SQL Server 7.0 database for maximum reliability and performance. Master crucial techniques for ensuring data integrity and security - techniques that constantly show up on Microsoft's exam!
Learn how to supercharge productivity by using the SQL Server Agent to automate administration tasks. Master database backup and restoration. Use SQL Server 7 as a high-performance back-end for your Web applications. It's all here, and lots more - including three full chapters on replication, a Key component of today's distributed database strategies!


*Ace Microsoft's Exam 70-028: System Administration for Microsoft<^>® SQL Server<^>™ 7.0!

*You get 100+ incisive test Q&As, plus a complete sample exam, access to the state-of-the-art Scholars.com interactive training Web site with even more quizzes and help -- and a free CBT Systems SQL Server 7 interactive training course on CD-ROM, worth $225!

*Don't just get a cram guide: get a total learning resource. Get MCSE: System Administration for Microsoft SQL Server!

About the Author

Jeffrey Byrneis a database developer living in Portland, OR. His software books include Understanding Microsoft SQL Server and Building Microsoft SQL Server Websites, both from Prentice Hall PTR.

Product Details

• Hardcover: 567 pages
• Publisher: Prentice Hall Ptr (January 15, 1999)
• Language: English
• ISBN-10: 0130107956
• ISBN-13: 978-0130107954
• Product Dimensions: 9.4 x 7.2 x 1.9 inches
• Shipping Weight: 3.1 pounds
• Average Customer Review: 1.2 out of 5 stars  See all reviews (12 customer reviews)
• Amazon Best Sellers Rank: #6,487,624 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

7 of 7 people found the following review helpful:

1.0 out of 5 stars A total,complete and utter waste of money!, November 10, 1999

By A Customer

This review is from: MCSE System Administration for Microsoft SQL Server 7 (Hardcover)

I am glad my bookstore has an exchange policy because I returned this book like it was a bad disease! I replaced it with Rick Sawtell's SQL Server 7 admin study guide.

The CBT is a joke, it is more a discussion on SQL 7 capabilities and features. There is no actual training, you could learn the same thing on the Microsoft website!

The interactive web-site is also a joke. There are sample test questions for each section of the book. The number of questions range from 3 to 8. Yeah, that will really help me pass the exam!

Do not, under any circumstance buy this book! Amazon should consider dropping such terrible books.

3 of 3 people found the following review helpful:

1.0 out of 5 stars Worst Book I have ever received!, August 16, 1999

By A Customer

This review is from: MCSE System Administration for Microsoft SQL Server 7 (Hardcover)

...too bad there was not an option for 0 stars!

I REALLY WISH that I had read the comments here at Amazon before I purchased the book. Everything said here is true! In my haste, I anxiously bought this book since it was the only one left at my local bookstore... I should have realized why it was left. I will never buy from Prentice Hall again! Information was inaccurate, not updated, syntax was aweful, CBT was useless, etc, etc. Do publishers no longer care what they are publishing? How does this J. Byrne author feel knowing that they knowingly are ripping people off!!!! The publisher should fess up and offer a refund to all people who have purchased this book at their web site!

My letter to them will be going into the mail tomorrow!

DO NOT BUY THIS BOOK!!!!!

2 of 2 people found the following review helpful:

1.0 out of 5 stars Absolutely Pitiful!!!, August 7, 1999

By A Customer

This review is from: MCSE System Administration for Microsoft SQL Server 7 (Hardcover)

Not only is the information contained in this book erroneous and unclear, the CBT CD isn't worth ten cents! It is based on Beta 3 and is a marketing ploy to get you to buy this book. No more Prentice Hall books for me! I'm a Sybex gal!