- 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 (View shipping rates and policies)
- Average Customer Review: 28 customer reviews
- Amazon Best Sellers Rank: #1,169,323 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.
This month's Book With Buzz: "The Lying Game" by Ruth Ware
From the instant New York Times bestselling author of blockbuster thrillers "In a Dark, Dark Wood" and "The Woman in Cabin 10" comes Ruth Ware’s chilling new novel, "The Lying Game." See more
Frequently bought together
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.
Browse award-winning titles. See more
Top customer reviews
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.
Thanks again, Ken
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.
Most recent customer reviews
Its one of the biggest sins is having a misleading title. "SQL Server Architecture and Internals" ? Forget it.Read more