Microsoft SQL Server 2012 Internals Author: Kalen Delaney | Language: English | ISBN:
B00GT3K7XM | Format: EPUB
Microsoft SQL Server 2012 Internals Description
Dive deep inside the architecture of SQL Server 2012
Explore the core engine of Microsoft SQL Server 2012—and put that practical knowledge to work. Led by a team of SQL Server experts, you’ll learn the skills you need to exploit key architectural features. Go behind the scenes to understand internal operations for creating, expanding, shrinking, and moving databases—whether you’re a database developer, architect, or administrator.
Discover how to:
- Dig into SQL Server 2012 architecture and configuration
- Use the right recovery model and control transaction logging
- Reduce query execution time through proper index design
- Track events, from triggers to the Extended Event Engine
- Examine internal structures with database console commands
- Transcend row-size limitations with special storage capabilities
- Choose the right transaction isolation level and concurrency model
- Take control over query plan caching and reuse
- File Size: 14417 KB
- Print Length: 982 pages
- Simultaneous Device Usage: Unlimited
- Publisher: Microsoft Press; 1 edition (November 20, 2013)
- Sold by: Amazon Digital Services, Inc.
- Language: English
- ASIN: B00GT3K7XM
- Text-to-Speech: Enabled
X-Ray:
- Lending: Not Enabled
- Amazon Best Sellers Rank: #126,041 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
- #44
in Books > Computers & Technology > Microsoft > Development > SQL Server - #83
in Kindle Store > Kindle eBooks > Computers & Technology > Databases
- #44
in Books > Computers & Technology > Microsoft > Development > SQL Server - #83
in Kindle Store > Kindle eBooks > Computers & Technology > Databases
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...