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
Have one to sell? Sell on Amazon

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

ISBN-13: 978-0201700473 ISBN-10: 0201700476
Buy used
$2.65
Buy new
$57.82
Used & new from other sellers Delivery options vary per offer
50 used & new from $2.65
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Hero Quick Promo
Save up to 90% on Textbooks
Rent textbooks, buy textbooks, or get up to 80% back when you sell us your books. Shop Now
$57.82 FREE Shipping. Only 4 left in stock (more on the way). Ships from and sold by Amazon.com. Gift-wrap available.

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: $142.99

Buy the selected items together

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
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: 7 x 2.1 x 9 inches
  • Shipping Weight: 3.4 pounds (View shipping rates and policies)
  • Average Customer Review: 4.3 out of 5 stars  See all reviews (28 customer reviews)
  • Amazon Best Sellers Rank: #770,836 in Books (See Top 100 in Books)

More About the Author

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

Customer Reviews

4.3 out of 5 stars

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
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
11 of 12 people found the following review helpful By Dmitry Dvoinikov on August 1, 2006
Format: Paperback
Alas, this book was a VERY disappointing reading.

Its one of the biggest sins is having a misleading title. "SQL Server Architecture and Internals" ? Forget it.

The first whole third of the book is Win32 in a nutshell. It tells you about memory, processes, I/O and everything. But I already have my Richter dog-eared all right, I wouldn't need a reminder in a book on SQL Server.

Then, about the SQL Server. Internals ? What a joke. The only internals that you would find are names of the DLLs where this or that SQL Server subsystem resides and a few hardcore debugger sessions to show you those DLLs actually get loaded. Uh-huh, thanks.

Can you imagine a book on SQL Server internals which doesn't mention pages and/or extents ? In-depth description of different execution plans ? This is the one.

What this book really is, is 20 chapters worth of overviews for more or less known SQL Server features. Average-to-good overviews of a less known features. Uhm, architecture, internals ? Nope - SQLXML, DTS, notification services, cursors, transactions. Take cursors - it says there are four types of cursors, you know, static, etc. and shows an SQL snippet for each. That's basically it. Take transactions - ACID, isolation levels and usage hints. Oh well, it could be worse...

Difficult to say without reading other books by the same author (not that I have an urge any more), but it appears he has written a whole series of them. You find sentences like "In my other book..." all over the place. Just love it:

[quote]

I must confess that I was conflicted when I sat down to write this chapter.
Read more ›
3 Comments 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

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
The Guru's Guide to SQL Server Architecture and Internals
This item: The Guru's Guide to SQL Server Architecture and Internals
Price: $57.82
Ships from and sold by Amazon.com