Programming Books C Java PHP Python Learn more Browse Programming Books
Microsoft SQL Server 2012 Internals (Developer Reference) and over one million other books are available for Amazon Kindle. Learn more
Buy New
  • List Price: $61.99
  • Save: $16.03 (26%)
In Stock.
Ships from and sold by
Gift-wrap available.
Add to Cart
Want it Tuesday, April 22? Order within and choose One-Day Shipping at checkout. Details
Trade in your item
Get a $16.68
Gift Card.
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 all 2 images

Microsoft SQL Server 2012 Internals (Developer Reference) Paperback

ISBN-13: 978-0735658561 ISBN-10: 0735658560 Edition: 1st

See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from Collectible from
"Please retry"
"Please retry"
$39.43 $33.99


Frequently Bought Together

Microsoft SQL Server 2012 Internals (Developer Reference) + Microsoft SQL Server 2012 T-SQL Fundamentals (Developer Reference) + Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions (Developer Reference)
Price for all three: $103.28

Buy the selected items together


Shop the new
New! Introducing the, a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Series: Developer Reference
  • Paperback: 982 pages
  • Publisher: Microsoft Press; 1 edition (November 25, 2013)
  • Language: English
  • ISBN-10: 0735658560
  • ISBN-13: 978-0735658561
  • Product Dimensions: 9 x 7.4 x 1.9 inches
  • Shipping Weight: 3.6 pounds (View shipping rates and policies)
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Best Sellers Rank: #92,820 in Books (See Top 100 in Books)

Editorial Reviews

About the Author

Kalen Delaney, a Microsoft MVP for SQL Server since 1993, provides advanced SQL Server training to clients worldwide. She is a contributing editor and columnist for SQL Server Magazine and the author of several highly regarded books, including Microsoft SQL Server 2008 Internals.

More About the Authors

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

Customer Reviews

4.5 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See both customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

6 of 6 people found the following review helpful By Mr. Ian W. Stirk on January 29, 2014
Format: Paperback

I have written a detailed chapter-by-chapter review of this book on www DOT i-programmer DOT info, the first and last parts of this review follow:

The introduction says "This book is intended to be read by anyone who wants a deeper understanding of what SQL Server does behind the scenes", so how does it fare?

This book has a revered pedigree, with previous editions containing some of the most detailed explanation of SQL Server internals available. Additionally, the list of authors reads like a Who’s Who of the SQL Server world.

Owing to the increasing size and complexity of the SQL Server software, this book is selective in its content, concentrating on the query processor and storage engine. It specifically excludes client programming, business intelligence, security, and other non-core engine areas.

Below is a chapter-by-chapter exploration of the topics covered.

Chapter 1 SQL Server 2012 architecture and configuration
This first chapter provides an overview of the database engine, its key components, what they are and how they interact. In essence it aims to put the subsequent chapters into context.

SQL Server editions and installation are briefly discussed. SQL Server metadata is examined in terms of compatibly views, catalog views, Dynamic Management Objects (DMOs), and other metadata (e.g. system functions and stored procedures). This metadata can be very useful in diagnosing problems e.g. identifying what SQL statements are blocking.

The major components of the engine are identified (i.e. protocol layer, query optimization, query execution, storage engine, and the SQL Server Operating System [SQLOS]) and briefly discussed. They are discussed extensively in later chapters.
Read more ›
1 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
Format: Kindle Edition Verified Purchase
As way of introduction, I am a CPA, MBA, MCSD, MCDBA - (for those of you who know, these are old credentials) I have made my living designing, coding, and supporting SQL based systems since Informix introduced Smartware. Most of my work has been done in MS SQL Server and Access.

I have spent countless hours trying to solve problems related to MS SQL Server because I never read this book or any like it. I don't care how long you have been working in MS SQL Server, if you do not understand the internals of how the engine works, you will waste vast amounts of time and most likely produce code and environments, which although they may function, are not optimized. You will spend hours trying to solve problems because you will not even know where to start looking.

This book is highly technical and extremely dry in many places. You will not take it to the beach for light reading. It will take a long time to work through this book and much of it may not seem relevant to you at the moment. I admit skimming some of the longer examples, but they are there for you to use in the future when you hit a wall.

This book is for persons who have a good amount of experience working with SQL Server and are moving up to 2012 and really want to understand the product from the inside out. You do need a good understanding of hardware system nomenclature and functionality to understand the references in the book.

If you are an T-SQL developer and you think you don't really need the information in this book, you are wrong. As all of us who have written a million lines of T-SQL code in our lives know that there are a thousand different ways to get from point A to point B. Although all of them may work, 99% of them are inefficient at least. This book will give you the background understanding to know when you are headed done the wrong road.
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

Product Images from Customers