countdown boutiques-francophones Learn more scflyout Home All-New Kindle Explore the Vinyl LP Records Store sports Tools

Customer Reviews

3.3 out of 5 stars
3.3 out of 5 stars
Your rating(Clear)Rate this item

There was a problem filtering reviews right now. Please try again later.

on July 1, 2004
I have been working with SQL Server for the last five years and about two years ago when I was in a dilemma about transactions I purchased this book. It totally cleared all my concepts and I was able to not only resolve transaction problems that I was having but also become an expert within my firm. The book helped me gain a lot of respect with my fellow collegues. If you are looking to really become a SQL Server black belt and get a great understanding of what happens INSIDE then this is a highly recommended book.
0Comment|Was this review helpful to you?YesNoReport abuse
on June 26, 2004
This book is a must-have for DBAs or developers who want an inside view of SQL Server's architecture. It contains very little content duplicated from Books Online and delves much deeper than the majority of SQL Server books available.
Delaney shows everything from how data is actually stored on disc to the internals of the query optimizer. I find her writing style to be smooth and easy to digest, and I had no problem reading this book cover-to-cover.
Highly recommended.
0Comment|Was this review helpful to you?YesNoReport abuse
on May 29, 2004
We recently moved from Informix to Sql 2K and found this book very useful. Thanks to this and Henderson's book we were able to make the migration in 6 months. We actually unplugged the Informix server yesterday.
This book teaches how Sql works inside. The product docs don't even tell half the story, so a book like this can help fill in the gaps.
0Comment|Was this review helpful to you?YesNoReport abuse
on May 26, 2004
I usually prefer the Sybex books than the Microsoft books. But this book is really good. It is the best complement for the Self Paced Book. I wasn't ready for the exam until I finished this book. This book contains information useful not only for the exam but also for the real life.
I passed the exam two days ago and passed with 893.
I recommend this book for guys with SQL intermediate skills. Advanced user may find more useful the BOL, but maybe some samples will be useful. Beginners won't understand some sections.
This book uses examples to explain the theory (I love to learn using this way).
This book complements the SELF PACED training kit book in the following areas :
Accessing to data
Retrieve, filter, group, summarize, and modify data by using Transact-SQL.
Manage result sets by using cursors and Transact-SQL. Considerations include locking models and appropriate usage.
Analyze the query execution plan. Considerations include query processor operations and steps.
0Comment|Was this review helpful to you?YesNoReport abuse
on April 8, 2004
If you want to be a SQL Server DBA, there are really only three resources you need in order to gain a solid foundation of knowledge. Your first resource is Books Online, which is part of the SQL Server software. Next, read Ken England's book on Performance Optimization (ISBN 1-55558-241-9). When you finish those, read this book.
What I like about this book is that the author explains WHY SQL Server does things in a particular way. The book goes into great detail about SQL Server's architecture and internal processes. For this reason, the book is a great ally to have when you're working with a developer who doesn't understand database concepts. Yet, at the same time, it is easy to read.
This book is especially ideal for those who need to get a thorough understanding of transactions, locking and performance tuning.
When you're ready to become an expert in SQL Server, read this book.
0Comment|Was this review helpful to you?YesNoReport abuse
on January 22, 2004
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.
0Comment|Was this review helpful to you?YesNoReport abuse
on January 4, 2004
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.
0Comment|Was this review helpful to you?YesNoReport abuse
on November 3, 2003
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.
0Comment|Was this review helpful to you?YesNoReport abuse
on August 27, 2003
This is a must have book for any serious SQL Server programmer.
I was amazed by the level of details that the book covers. It is the BIBLE of Microsoft SQL Server 2000. From the architectural viewpoint, there no way to compare this book with any other in the market. It shows you the implementation as well as the programming details of Microsoft SQL Server. If you are serious about knowing SQL Server inns & outs. Get this great book. I enjoyed every paragraph and page along the way.
0Comment|Was this review helpful to you?YesNoReport abuse
on July 4, 2003
Not really a good book, too descriptive.
0Comment|Was this review helpful to you?YesNoReport abuse