Free Downloads

Microsoft SQL Server 2012 Internals (Developer Reference)

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

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: 7.3 x 2.1 x 8.9 inches

Shipping Weight: 3.6 pounds (View shipping rates and policies)

Average Customer Review: 4.3 out of 5 stars  See all reviews (11 customer reviews)

Best Sellers Rank: #340,316 in Books (See Top 100 in Books) #53 in Books > Computers & Technology > Programming > Microsoft Programming > SQL Server #160 in Books > Computers & Technology > Databases & Big Data > SQL #182 in Books > Computers & Technology > Business Technology > Management Information Systems

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 are given here. For my review of all chapters, search i-programmer DOT info for STIRK together with the book's title.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 configurationThis 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.

SQL: Learn SQL In A DAY! - The Ultimate Crash Course to Learning the Basics of SQL In No Time (SQL, SQL Course, SQL Development, SQL Books, SQL for Beginners) Microsoft SQL Server 2012 Internals (Developer Reference) Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions (Developer Reference) Hands-on Study Guide for Exam 70-411: Administering Windows Server 2012 R2 (Exam 70-411, 70-411, Exam Ref 70-411, MCSA Windows Server 2012 R2, MCSE Windows Server 2012 R2) SQL: QuickStart Guide - The Simplified Beginner's Guide To SQL (SQL, SQL Server, Structured Query Language) Pro SQL Server 2012 BI Solutions (Expert's Voice in SQL Server) SQL Server 2012 Integration Services Design Patterns (Expert's Voice in SQL Server) Windows® Internals: Including Windows Server 2008 and Windows Vista, Fifth Edition (Developer Reference) Beginning SQL Server 2008 Express for Developers: From Novice to Professional (Expert's Voice in SQL Server) Pro SQL Server 2008 Failover Clustering (Expert's Voice in SQL Server) Red Hat Enterprise Linux (RHEL) 7 Server Installation and Administration: Training Manual: Covering CentOS-7 Server, Cloud computing, Bind9 DNS Server and Fedora 23 Server Red Hat Enterprise Linux (RHEL) 6 Server Installation & Administration: Training Manual: Covering CentOS-6, OpenSUSE 11.3 Server, Mandriva Enterprise Server, and Fedora 14 Server Microsoft Windows Internals (4th Edition): Microsoft Windows Server 2003, Windows XP, and Windows 2000 The Guru's Guide to SQL Server Architecture and Internals Professional SQL Server 2008 Internals and Troubleshooting Windows Server 2012 R2: How to install and add roles?: (Desktop Experience) (Windows Server 2012 R2: From installation to configuration) MCSA Guide to Microsoft SQL Server 2012 (Exam 70-462) (Networking (Course Technology)) Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX Beginning Microsoft SQL Server 2012 Programming Microsoft Surface Pro 4 & Microsoft Surface Book: The Beginner's Guide to Microsoft Edge, Cortana & Mail App on Microsoft Surface Pro 4 & Microsoft Surface Book