SQL Server 2000 Black Book: A Resource for Real World Database Solutions and Techniques [Illustrated] [Paperback]

Patrick Dalton (Author), Paul Whitehead (Author)

Book Description

Publication Date: January 19, 2001 | Series: Black Book (Coriolis Group Books Software)

The SQL Server 2000 Black Book is an insightful guide to utilizing the power and flexibility of SQL Server 2000. Geared toward the intermediate to advanced database administrator and programmer, this book will help you leverage the full potential of relational database technology to create a state-of-the-art database solution. This book will help you: install and configure SQL Server 2000, solve complex database management

Editorial Reviews

About the Author

Patrick Dalton has been designing databases for 14 years, and for the last 7 years he has focused exclusively on client-server development with Microsoft SQL Server and other database systems. He is certified by Microsoft as aTrainer and a Solution Developer in SQL Server Administration.

Paul R.Whitehead (Fort Lauderdale, FL) is currently a Senior DBA, Senior Developer, and Database Architect. He has worked in the area of software development for nearly 20 years and has extensive experience with Microsoft SQL Server versions 6.5, 7.0, and 2000. His primary focus has been database design and Transact-SQL programming, optimization, and troubleshooting. He recently co-authored SQL Server 2000 Black Book (Coriolis, 2001).

Product Details

• Paperback: 1016 pages
• Publisher: Coriolis Group Books; illustrated edition edition (January 19, 2001)
• Language: English
• ISBN-10: 1576107701
• ISBN-13: 978-1576107706
• Product Dimensions: 9.2 x 7.4 x 2.3 inches
• Shipping Weight: 4.4 pounds
• Average Customer Review: 3.3 out of 5 stars  See all reviews (9 customer reviews)
• Amazon Best Sellers Rank: #4,556,445 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

9 of 9 people found the following review helpful:

3.0 out of 5 stars YABFB, April 27, 2002

By A Customer

This review is from: SQL Server 2000 Black Book: A Resource for Real World Database Solutions and Techniques (Paperback)

Yet Another Big Fat Book. It has become an aggravating trend in the industry and this is one example among a myriad of clones.

Why is this just another big fat book? Page margins are about an inch and a half all around. The font is bigger than my two year old son's readers. A big cardboard flap holds two compact disks, one in the middle of the book and one at the end, that guarantees the book will never lay flat even after ripping them out. The CD's hold nearly useless timed evaluation copies of software that requires far more time to master. The pages are heavy bond, arguably to make the book fat as fat spines stand out on the shelf. The book covers a good deal of topics, but with less than 1000 words dedicated to any given one. Typos abound. The spellchecker calls the i386 architecture the 1386 (one three eight six) architecture in a half-dozen places.

The audience this book is aimed at might appreciate a light introduction without getting caught up details, so I'm giving it a three star. Like other reviews said, strictly beginner and in no way authoritative on any given topic. You'll need to make another purchase if you're looking to scratch the surface of SQL Server 2000.

6 of 6 people found the following review helpful:

2.0 out of 5 stars It's not as good as it seems, November 13, 2001

By 

"mrdimn" - See all my reviews

This review is from: SQL Server 2000 Black Book: A Resource for Real World Database Solutions and Techniques (Paperback)

A "Comprehensive Problem Solver" it is not. The SQL Server 2000 Black Book is full of good information on theories and principles, and at the end of each chapter is a good amount of examples and solutions for particular situations. The examples do help you ,sort of, understand how to build your own SQL commands, but if you want to know WHAT those commands you typed in really means, you may want to buy another book.

This book is supposed to be for Immediate to Advanced users and as toted a "problem solver". It's not. It seems like a good beginners book.

I have two examples to discuss:
1) If/Else logic. Granted as a programmer I know how this stuff works, but they use the flow control statements throughtout the book, but never explain IF/Else statements. Considering how important If/Else statements are in programming, this is a major weakpoint.

2) Stored Procedures. Chapter 14 of the book is supposed to cover Stored Proceduures. Well, it talks about it, and there are examples at the end of the book. But that chapter has more discussions than hardcore examples that it really depressed me about the book. It seemed to me that some of this chapter was probably taken from the manuals. If you wanted to understand Stored Procedures, this book won't help.

Overall, it has some good points if you are beginning, bad points if you want a good programming/breakdown type of book.

3 of 3 people found the following review helpful:

2.0 out of 5 stars Don't waste your time, November 25, 2003

By 

Randall Moulton (Aurora, IL United States) - See all my reviews
(REAL NAME)   

This review is from: SQL Server 2000 Black Book: A Resource for Real World Database Solutions and Techniques (Paperback)

I bought this book on sale and thought it would be a good reference - looking at how large it is. However, I have not been able to get a single answer to any of my questions.

The text goes into no in-depth explanations and it literally has copied the Books On-Line documentation that comes with SQL Server! I don't know how they got by with this as I compared it almost word-for-word in many, many places.

I say it's a waste of time because you might as well use SQL's own doc because there's no extra cost and you can search for your topics. Then spend the money to get another reference that goes into more detail and covers what-if scenarios.