Pro SQL Server Internals
- 12h 52m
- Dmitri Korotkevitch
- Apress
- 2014
Pro SQL Server Internals explains how different SQL Server components work “under the hood” and how they communicate with each other. This is the practical book with a large number of examples that will show you how various design and implementation decisions affect the behavior and performance of your systems.
Pro SQL Server Internals covers a multiple SQL Server versions starting with SQL Server 2005 all the way up to the recently released SQL Server 2014. You’ll learn about new SQL Server 2014 features including the new Cardinality Estimator, In-Memory OLTP Engine (codename Hekaton), and Clustered Columnstore Indexes. With Pro SQL Server Internals, you have a solid roadmap for understanding the depth and power of the SQL Server database backend, regardless of the version and edition of SQL Server you use.
Pro SQL Server Internals does the following:
- Explains how to design efficient database schema, indexing, and transaction strategies.
- Shows how various database objects and technologies are implemented internally and when they should or should not be used.
- Demonstrates how SQL Server executes queries and works with data and transaction logs.
What you’ll learn
- Design and develop efficient database solutions utilizing SQL Server as the database backend.
- Troubleshoot and address design, concurrency, and performance issues in systems.
- Choose the right database objects and technologies for the job.
- Improve system availability and manageability and reduce implementation costs with data partitioning.
- Design efficient Disaster Recovery and High-Availability strategies for systems.
- Improve the performance of OLTP and Data Warehouse systems by utilizing new SQL Server 2014 features, such as the In-Memory OLTP Engine and Clustered Columnstore Indexes.
Who this book is for
Pro SQL Server Internals is a book for developers and database administrators who want to design, develop, and maintain systems in a way that gets the most from SQL Server. This book is an excellent choice for people who prefer to understand and fix the root cause of a problem, rather than applying a 'band aid' to it.
About the Author
Dmitri Korotkevitch is a Microsoft SQL Server MVP and Microsoft Certified Master (SQL Server 2008) with almost 20 years of IT experience including over 14 years of experience working with Microsoft SQL Server as an Application and Database Developer, Database Administrator, and Database Architect. Dmitri specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second around the clock.
Dmitri regularly speaks at various Microsoft and SQL PASS events, and he provides SQL Server training to clients around the world.
In this Book
-
Data Storage Internals
-
Tables and Indexes: Internal Structure and Access Methods
-
Statistics
-
Special Indexing and Storage Features
-
Index Fragmentation
-
Designing and Tuning the Indexes
-
Constraints
-
Triggers
-
Views
-
User-Defined Functions
-
XML
-
Temporary Tables
-
CLR
-
CLR Types
-
Data Partitioning
-
System Design Considerations
-
Lock Types
-
Troubleshooting Blocking Issues
-
Deadlocks
-
Lock Escalation
-
Optimistic Isolation Levels
-
Application Locks
-
Schema Locks
-
Designing Transaction Strategies
-
Query Optimization and Execution
-
Plan Caching
-
System Troubleshooting
-
Extended Events
-
Transaction Log Internals
-
Designing a Backup Strategy
-
Designing a High Availability Strategy
-
In-Memory OLTP Internals
-
In-Memory OLTP Programmability
-
Introduction to Columnstore Indexes
-
Clustered Columnstore Indexes
