» » SQL Server 2000 Black Book: A Resource for Real World Database Solutions and Techniques

Download SQL Server 2000 Black Book: A Resource for Real World Database Solutions and Techniques epub

by Paul Whitehead,Patrick Dalton

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 tate-of-the-art database solution. This book will help you install and configure SQL Server 2000, solve complex database management issues.

Download SQL Server 2000 Black Book: A Resource for Real World Database Solutions and Techniques epub
ISBN: 1932111387
ISBN13: 978-1932111385
Category: Technology
Subcategory: Hardware & DIY
Author: Paul Whitehead,Patrick Dalton
Language: English
Publisher: Paraglyph Press; Pap/Cdr edition (July 1, 2002)
Pages: 1016 pages
ePUB size: 1166 kb
FB2 size: 1788 kb
Rating: 4.7
Votes: 711
Other Formats: txt rtf azw mbr

I am a self-taught DBA in need to understand how to cope with my day-to-day job. This book comes in very handy. It covers everything you need to know about administration, from the installation, optimization, hardware selection and so on. The writers pour their own experience into the book. Don't hesitate: buy this book before it's out of print and you'll never be sorry afterwards.
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.
'SQL Server 2000 Black Book' is a guide and reference for professionals looking for solutions. It is truly a "Comprehensive Problem Solver", as the cover says.

"SQL Server 2000 Black Book" provides in-depth study as well as reference material. It is comprehensive and yet precise, a perfect resource for developers looking for database and server reference material.

Patrick Dalton and Paul Whitehead have explained crucial points twice or more in close proximity, and, in different ways, so that you understand and remember those points, during, your adventures in practical life with SQL Server, Windows Operating System and Data Storage.
I can't say that I read a technical book from cover but I've come pretty close with this one. In addition to the information that I can really use, ( and I mean everyday ) what impressed me most was the practical and meaningful tips about dealing with the day to day 'crises' a SQL server developer faces. The book is already well dog eared as it's a constant companion of mine at work, in the car, and at home.
I highly recommend this book. It's the best on the subject I've seen. I've learned things about SQL Server I didn't even know existed.
This book will be useful because it is clear and well-organized. Each chapter is introduced with a quick reference table of contents. The headings within the chapter make it easy to follow the outline (organization) of the material. There are numerous graphics and procedure lists. Where appropriate, source code is listed by way of demonstration. The coverage of the material is comprehensive.
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.