- Paperback: 1072 pages
- Publisher: Addison-Wesley Professional (November 1, 2003)
- Language: English
- ISBN-10: 0201700476
- ISBN-13: 978-0201700473
- Product Dimensions: 7 x 2 x 9.1 inches
- Shipping Weight: 3.4 pounds
- Average Customer Review: 24 customer reviews
- Amazon Best Sellers Rank: #1,709,811 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
The Guru's Guide to SQL Server Architecture and Internals
Use the Amazon App to scan ISBNs and compare prices.
What other items do customers buy after viewing this item?
Customers who viewed this item also viewed
From the Back Cover
"I can pretty much guarantee that anyone who uses SQL Server on a regular basis (even those located in Redmond working on SQL Server) can learn something new from reading this book."
--David Campbell, Product Unit Manager,
Relational Server Team, Microsoft Corporation
The latest book from the highly regarded and best-selling author Ken Henderson, The Guru's Guide to SQL Server Architecture and Internals is the consummate reference to Microsoft SQL Server. Picking up where documentation and white papers leave off, this book takes an all-inclusive approach to provide the most depth and breadth of coverage of any book on SQL Server architecture, internals, and tuning.
Blending in-depth discussion with practical application, the guide begins with several chapters on the fundamental Windows technologies behind SQL Server, including processes and threads, memory management, Windows I/O, and networking. The focus then moves on to the architectural details of SQL Server and how to practically apply them.
The entire SQL Server product is covered--not just the functionality that resides within the core executable or product features that have been in place for years. SQL Server has matured and broadened substantially with each release, and the author explores the "fringe" technologies that have yet to be covered elsewhere, including Notification Services, Full Text Search, SQLXML, replication, DTS, and a host of others.
Throughout the book, the author uses WinDbg, Microsoft's free downloadable symbolic debugger, to look under the hood of SQL Server. Armed with new debugging and coding skills, readers will be ready to master SQL Server on their own.
The accompanying CD-ROM is packed with additional material, including full source code for the book's 900+ examples, as well as three invaluable tools: DTSDIAG, the VBODSOLE Library, and DTS Package Guru. DTSDIAG allows developers and administrators to simultaneously collect Profiler traces, perform logs, blocking script output, system event logs, and SQLDIAG reports from a specified SQL Server. The VBODSOLE Library features more than twenty new COM-based functions for Transact-SQL, including T-SQL enhancements such as array-manipulation routines, financial functions, string-manipulation functions, and system functions. DTS Package Guru is a .NET-based package editor for SQL Server's Data Transformation Services that allows editing of any modifiable package and supports the automation of mass package changes.
The Guru's Guide to SQL Server Architecture and Internals is the essential guide for database developers and admin- istrators alike, regardless of skill level.
About the Author
Ken Henderson, a nationally recognized consultant and leading DBMS practitioner, consults on high-end client/server projects for such customers as the U.S. Air Force, the U.S. Navy, H&R Block, Travelers Insurance, J.P. Morgan, the CIA, Owens-Corning, and CNA Insurance. He is the author of five previous books on client/server and DBMS development, a frequent magazine contributor to such publications as Software Development Magazine and DBMS Magazine, and a speaker at technical conferences.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
The first 400 pages of this book give you internal of the Window Operating system which will help many of you to use the system resource wisely and write better SQL code. The author is very knowledge about what Window OS and SQL server. It is a great book to have and put on your bookshelf for reference.
Also some of the code loads at boot and spybot search and destroy picks up it immediately. I'm not sure why sequin needs a memory resident piece running at all times using up valuable resources. That is not acceptable from book code, esp. a query analyzer of dubious worth. The other code in this book is looked upon suspiciously by award winning security software. Anytime I find a macro or code written in this manner I'm very leary of allowing it to run simply because it may not be written well enough not to accidently trash my system. I'm not saying any intentional malicious code is on this CD. Not at all, just not written well enough to pass muster with good security products.
Thanks again, Ken
The rest is good, no questions (although there's some overlap with his other (very good) TSQL books).
I find such a structure extremely unusual, unnecessary, and, due to an absolutely exorbitant amount of redundancy in the general OS area--unsuitable for anyone with even a moderate exposure to Windows programming. It looks suspiciously like padding to me, and again, the amount of it is simply mind boggling; I've never seen anything like that before. Four-five hundred pages of padding? C'mon.
Now, one man's padding is another's bible, OK, I suppose this may be a feature rather than flaw to some. But please be aware of this and choose accordingly. I won't pretend to be an ultimate judge here (as for myself, I didn't buy this book).
Just to be fair in general, I'll add that Henderson is a knowledgeable guy and a good writer, which is a rare combination. So I'm not saying the book is bad: I would probably buy the second half of it (for half the price). And I'd easily give this second part four stars, maybe five.
I wrote the above on January 18, 2005. Now, a personal update: I did get this book for half price and I read it, and you know what? I'm not giving even the second part this book four stars -- in fact I'm bringing my rating further down. The book is incredibly fragmentary, as if it's a pile of scraps of whatever the author had -- including sometimes sizeable copy/paste from his other books (look at cursors); sometimes irrelevant material (what does XML have to do with the server architecture?) -- all bound together for some unknown reason. In addition to and beside from sporting the totally exasperating degree of redundancy in the first half of it, this book is very unsystematic and not really true to the title -- I have a feeling that after the somewhat deserved success of Henderson's first two books the publisher said, well, while success lasts lets issue something huge and expensive, so just make it real thick and we'll sell it for sixty bucks. There is, still, some curious information in this book but it's just too much effort to dig it out from beneath thick layers of redundant/irrelevant/disorganized stuff (for example, suddenly there appears the term "spid" -- good luck finding what it is: index, whatever, it's not there).
2007 bottom line: so, after all, I do not recommend this book. Get MS Press's books: well-written, intelligently paced, and systematic, they cover _most_ of what _everyone_ needs. If you want esoterica, read Celko. I have three books by Henderson, I've used them for a couple of years by now, and they're sorta OK but nothing to write home about; maybe they were unique in 2000, I dont' know, but purely empirically there seems to somehow always be another source you can get all the same stuff from, better organized and presented (MS Press books like Delaney's, or even 2005 docs online). This is one of those rare cases where my opinion of a book worsened after using it for a good while, and I will no longer look for books by this author. I also feel very funny about the profusion of content-free positive reviews for this (and other) Henderson books. I know this sounds paranoid, but hell, some things are just impossible to ignore.
Most recent customer reviews
Its one of the biggest sins is having a misleading title. "SQL Server Architecture and Internals" ? Forget it.Read more