FREE Delivery in the UK.
Temporarily out of stock.
Order now and we'll deliver when available. We'll e-mail you with an estimated delivery date as soon as we have more information. Your account will only be charged when we dispatch the item.
Dispatched from and sold by Amazon. Gift-wrap available.
Have one to sell?
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 – 22 Oct 2003

5.0 out of 5 stars 1 customer review

See all 2 formats and editions Hide other formats and editions
Amazon Price
New from Used from
£48.95 £15.54
Note: This item is eligible for click and collect. Details
Pick up your parcel at a time and place that suits you.
  • Choose from over 13,000 locations across the UK
  • Prime members get unlimited deliveries at no additional cost
How to order to an Amazon Pickup Location?
  1. Find your preferred location and add it to your address book
  2. Dispatch to this address when you check out
Learn more
click to open popover

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.

  • Apple
  • Android
  • Windows Phone

To get the free app, enter your mobile phone number.

Amazon Original Books on Sale
Browse a selection of over 160+ Kindle Books currently on sale from 99p. Learn more

Product details

  • Paperback: 1072 pages
  • Publisher: Addison Wesley; Pap/Cdr edition (22 Oct. 2003)
  • Language: English
  • ISBN-10: 0201700476
  • ISBN-13: 978-0201700473
  • Product Dimensions: 17.8 x 5.1 x 23.1 cm
  • Average Customer Review: 5.0 out of 5 stars 1 customer review
  • Amazon Bestsellers Rank: 2,363,132 in Books (See Top 100 in Books)
  • Would you like to tell us about a lower price?
    If you are a seller for this product, would you like to suggest updates through seller support?

  • See Complete Table of Contents

Product description

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.


Customer reviews

Share your thoughts with other customers
See all 1 customer reviews

Top customer reviews

14 January 2004
Format: Paperback
Comment| 6 people found this helpful. Was this review helpful to you? Report abuse

Most helpful customer reviews on Amazon.com

Amazon.com: 3.7 out of 5 stars 25 reviews
Elijah Li
5.0 out of 5 starsHighly recommanded for DBA/SQL Developers/System Admin
22 April 2005 - Published on Amazon.com
Format: Paperback|Verified Purchase
4 people found this helpful.
1.0 out of 5 starsDon't believe the hype
7 May 2004 - Published on Amazon.com
Format: Paperback|Verified Purchase
24 people found this helpful.
5.0 out of 5 starsOutstanding
3 November 2003 - Published on Amazon.com
Format: Paperback|Verified Purchase
17 people found this helpful.
M. Loftus
4.0 out of 5 starsA great book but not for everyone.
8 May 2007 - Published on Amazon.com
Format: Paperback|Verified Purchase
One person found this helpful.
Daniel A. Gyamfi
4.0 out of 5 starsFour Stars
9 December 2014 - Published on Amazon.com
Format: Paperback|Verified Purchase

Where's My Stuff?

Delivery and Returns

Need Help?