Pro SQL Server Internals
Pro SQL Server Internals by Dmitri Korotkevitch
English | 18 Dec. 2016 | ISBN: 1484219635 | 840 Pages | EPUB (True) | 13 MB
English | 18 Dec. 2016 | ISBN: 1484219635 | 840 Pages | EPUB (True) | 13 MB
Improve your ability to develop, manage, and troubleshoot SQL Server solutions by learning how different components work “under the hood,” and how they communicate with each other. The detailed knowledge helps in implementing and maintaining high-throughput databases critical to your business and its customers. You’ll learn how to identify the root cause of each problem and understand how different design and implementation decisions affect performance of your systems.
New in this second edition is coverage of SQL Server 2016 Internals, including In-Memory OLTP, columnstore enhancements, Operational Analytics support, Query Store, JSON, temporal tables, stretch databases, security features, and other improvements in the new SQL Server version. The knowledge also can be applied to Microsoft Azure SQL Databases that share the same code with SQL Server 2016.