Inside Microsoft SQL Server 2000 (With CD-ROM)
||Author: Kalen Delaney|
List Price: $59.99
Our Price: Click to see the latest and low price
Publisher: Microsoft Press (15 November, 2000)
Sales Rank: 2,933
Average Customer Rating: 3.22 out of 5
Customer ReviewsRating: 4 out of 5
Accurate but sloppy
The book is probably the best out there (the author works for Microsoft SQL Development) for understanding the underlying SQL architecture (index, transaction logs, locks, data placement on disks etc). This is not a book for the beginners but for those who seek more than superficial understanding of SQL. Nor is this book for those who seek comprehensive knowledge of SQL because it addresses mostly SQL architecture. Nevertheless, I highly recommend this book both for the DBA and the Developers alike.
My main qualm with this book is it seems to be hastily written. It reads almost like a late night term paper. This is not to say the information is inaccurate, but the writing of this book is second rate and the author's lack of enthusiasm for explaining the finer points is evident.
Rating: 3 out of 5
Somebody forgot SQLXML
I was browsing through the book in a bookstore and saw that a chapter on SQL 2K's support for XML missing. I think any book on SQL Server 2000 that doesn't have at least a discussion on SQL Server 2000's support for XML is incomplete. I looked in the index for the XML. None there. I felt that the same title for version 7 was the best resource for learning SQL Server but this one ranks at least 2 stars below that.
Rating: 5 out of 5
From the author of SQL Server 2000 Bible
As the author of SQL Server book, I would not hesitate to recommend Kalen Delaney's book or any of her seminars. Her book is a reference work that I keep handy on my shelf. Each time I hear her speak I am impressed with her knowledge and her ability to communicate difficult concepts clearly.
Every published book serves a specific purpose - Inside SQL Server's purpose is to illuminate the internal architecture of SQL Server so that developers and admins can make better educated decisions and develop better databases. Within that purpose her book is excellent and well written.
Is it all things to all people? no. Does it do an excellent job of meeting its purpose? without question, yes. There are some reader reviews that seem to criticize Kalen's work for not meeting other needs, and I don't understand these comments. If you need a general SQL, T-SQL programming tutorial, XML/SQL, or introductory SQL Server book, Inside SQL Server is probably too focused on the internal workings of SQL Server and I'd recommend that you begin with one of the other excellent books on SQL Server. But, if you want to get deeper into the internals so you understand why you're writing code or tuning indexes, then there can be no question that Kalan's book is a must have on your shelf. Sooner or later, if you're serious about SQL Server, you should read this book.
· Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook
· Microsoft SQL Server 2000 Performance Tuning Technical Reference
· Microsoft SQL Server 2000 Resource Kit (With CD-ROM)
· Microsoft ADO.NET Step by Step
· MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 Database Design and Implementation, Exam 70-229, Second Edition