Qty:1
  • List Price: $64.99
  • Save: $29.43 (45%)
Only 4 left in stock (more on the way).
Ships from and sold by Amazon.com.
Gift-wrap available.
FREE Shipping on orders over $35.
Used: Like New | Details
Sold by AZ-Emporium
Condition: Used: Like New
Comment: Excellent Condition Book. Condition ranges from having slight shelf wear from storage to being a new book (I do not grade any used book "new" as so many do). NOT Ex Library. No writing, underlining, or highlighting.
Access codes and supplements are not guaranteed with used items.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

The Guru's Guide to SQL Server Architecture and Internals Paperback – November 1, 2003

ISBN-13: 978-0201700473 ISBN-10: 0201700476

Buy New
Price: $35.56
27 New from $22.97 27 Used from $5.50
Amazon Price New from Used from
Paperback
"Please retry"
$35.56
$22.97 $5.50
Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Frequently Bought Together

The Guru's Guide to SQL Server Architecture and Internals + The Guru's Guide to SQL Server Stored Procedures, XML, and HTML + The Guru's Guide to Transact-SQL
Price for all three: $116.01

Buy the selected items together

NO_CONTENT_IN_FEATURE

Shop the New Digital Design Bookstore
Check out the Digital Design Bookstore, a new hub for photographers, art directors, illustrators, web developers, and other creative individuals to find highly rated and highly relevant career resources. Shop books on web development and graphic design, or check out blog posts by authors and thought-leaders in the design industry. Shop now

Product Details

  • Paperback: 1072 pages
  • Publisher: Addison-Wesley Professional (November 1, 2003)
  • Language: English
  • ISBN-10: 0201700476
  • ISBN-13: 978-0201700473
  • Product Dimensions: 1.9 x 6.9 x 9.2 inches
  • Shipping Weight: 3.4 pounds (View shipping rates and policies)
  • Average Customer Review: 4.3 out of 5 stars  See all reviews (27 customer reviews)
  • Amazon Best Sellers Rank: #585,725 in Books (See Top 100 in Books)

Editorial Reviews

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.



0201700476B10012003

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.



0201700476AB07032003

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Regardless of your proclivities, I think you will find some of this relevant to what you do.
Charles McNutt
If you need or want to understand how SQL Server works inside & interoperates with the Windows environment, this is an excellent guide & reference.
Greg Linwood
Ken Henderson is the premier author of SQL Server and has created his best work yet of his series "Gurus Guide.." with this book.
Raymond L Everest

Most Helpful Customer Reviews

73 of 76 people found the following review helpful By raj on May 14, 2004
Format: Paperback
I have been working RDBMS for more than 10 years and with SQL Server for more than 5 years. I have not seen a book in SQL server which explains exactly how internals of SQL Server is implemented. There are lots of SQL books out there which are nothing but the repeat of SQL books online. This books stand out from the crowd. First 400 pages of the book talks about the windows OS, which crucial to understand SQL Server internals since the database engine lot of OS features. I like this author's straightforward style and the sample programs are excellent in demonstrating the concepts. I would strongly recommend this book for anybody interested in understanding SQL Server beyond its syntax. I wish I had an opportunity to study this kind of book few years back.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
65 of 68 people found the following review helpful By Greg Linwood on May 5, 2004
Format: Paperback
.
Ken's latest Guru's Guide is an important book for SQL Server Professionals who build or manage SQL Server systems.
SQL Server is tightly integrated with Windows, so understanding how SQL Server uses Windows services is essential to managing it effectively. This book covers the important Windows / SQL Server topics in significant depth, exploring each one from both a pure Windows perspective and then how it relates to SQL Server.
The first half of the book is dedicated to covering technical Windows concepts such as I/O, Memory, Thread scheduling, Synchronisation & Sockets as well as covering how SQL Server uses each of these. The second half of the book explores various SQL Server features in the depth you'd expect one of Ken's Guru's Guides.
This is not a beginners' book. It will feel at home on your shelf if you're reading books such as "Inside SQL Server" (another excellent SQL book) or "Inside Windows", both MS Press. These are all technically deep references for SQL people which offer real answers to the problems & issues we face in working with SQL Server & Windows. Many other books simply skim the edges of the technical topics that this book covers in depth.
If you're trying to learn how to write simple SQL statements, this is not the book for you. If you need or want to understand how SQL Server works inside & interoperates with the Windows environment, this is an excellent guide & reference.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
67 of 70 people found the following review helpful By Soumitra Banerjee on May 14, 2004
Format: Paperback
This is one of the best books that I have read so far on Windows and SQL Server. It gives the user a good understanding of some of the basic windows concept that are so fundamental to SQL Server internal workings.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 0 people found the following review helpful By J Jacob Jingleheimer Schmidt on January 18, 2005
Format: Paperback
Nearly a half of this book consists of a rather detailed (almost on the programming level) exposition of the Windows NT/2000 operating system. Please reread the previous phrase and make sure it registered: I didn't say MS SQL Server, I said the *operating system*. Imagine the two latest Richter books (for Win2K) with most code excised, plus the Solomon/Russinovich one combined: that will be the first half of Henderson's book. I'm not sure I understand the reason for all this information to be in there.

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?
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
15 of 17 people found the following review helpful By A Customer on December 24, 2003
Format: Paperback Verified Purchase
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews