 |
 |
The Guru's Guide to SQL Server Architecture and Internals
by Ken Henderson
List Price: $54.99
Our Price: $38.49
ISBN: 0201700476
Publisher: Addison-Wesley Pub Co (24 October, 2003)
Edition: Paperback
Sales Rank: 2,875
Average Customer Rating: 5 out of 5
|
Buy now directly from Amazon.com
|
|
 | |  |
|
| | Customers Reviews: | | |
| |
Rating: 5 out of 5
Excellent Reference
Don't let the 1000 pages deter you. Some of the chapters are likely to be considered too in-depth, but the book is loaded with so much info that you're sure to find something that makes it a worthwhile purchase. The material is presented well and the kiddy stuff is skipped so you're not wasting time flipping through material you've known for the last few years. I like the inclusion of the MS Debugger. The examples in the book have given me an introduction to it, and in time I expect that it will come in handy. In my years of reading SQL Server books, few have been as comprehensive as this one. It goes somewhat beyond Inside SQL Server, though I have not purchased that book since SQL 7. This is the type of book from which certification questions should be derived. It describes the nuances in using SQL Server and I've enjoyed reading several chapters of this book highlighting along the way. I consider it a better reference than SQL Server 2000 Resource Kit, and my only complaint is that it doesn't include other important subject areas such as security and hacking. Those areas are addressed in other references like SQL Server Security by Andrews, Litchfield, and Grindlay which I've got ready to read as soon as time permits.
Rating: 5 out of 5
Complex optimisations
Microsoft's SQL Server does not have all the functionality of Oracle or IBM's databases. But Microsoft has put a huge amount of work into beefing it up, as shown in this book. Henderson has done far more than just write a straightforward guide to the query syntax. In fact, the latter is not the emphasis here. Rather, he explains how SQL Server integrates into the Microsoft operating system, for one thing. Like memory mapped files, WinSock and network connections, and how they relate to SQL Server. He provides a long discussion of its memory management; crucial if you are heavily loading up the database. With queries and table joins, you get help on how to optimise, based on knowledge of SQL Server's innards. At over 900 pages, the breadth might seem daunting. But it reflects the complexity and potential of SQL Server. Henderson also provides some nice extra touches. Each chapter ends in a quick list of review questions, to see if you have been paying attention. Plus, at the book's end, he has 2 essays. One is on the drivel that constitutes most [all?] management fads. The second is on pseudo experts in newsgroups. The entire book is worth it, just for these essays! Very biting.
Rating: 5 out of 5
Outstanding
Ken Henderson is the premier author of SQL Server and has created his best work yet of his series "Gurus Guide.." with this book. This book digs in to the nuts and bolts of SQL Server like no other author has to date. I have had the honor of meeting him on a few occasions and listenting to two of his presentations - each time I run back to apply my newly acquired skills. We are lucky to have a great programmer, thinker, SQL Server wiz continuously exploring the application so that we might be better dba's and programmers ourselves. Thanks again, Ken
Lee
| | |
 | |  |
|
|
| Please note: |
Checkout and payment processing is done safely and securely through Amazon.com. |
| Prices (as shown) are subject to change without notice and cannot be guaranteed. |
|
| |
View My Shopping Cart
Email this page to a friend
Correction/Comment/Suggestion Regarding This Page?
