Microsoft SQL Server 2012 Internals Author: Visit Amazon's Kalen Delaney Page | Language: English | ISBN:
0735658560 | Format: PDF
Microsoft SQL Server 2012 Internals Description
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.
Conor Cunningham is principal architect of the SQL Server Core Engine Team at Microsoft.
Paul S. Randal is a Microsoft MVP, trainer, and contributing editor for TechNet Magazine.
- Paperback: 982 pages
- Publisher: Microsoft Press (December 9, 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)
Hi,
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.
Microsoft SQL Server 2012 Internals Preview
Link
Please Wait...