- Paperback: 804 pages
- Publisher: Apress; 2nd ed. edition (December 1, 2016)
- Language: English
- ISBN-10: 1484219635
- ISBN-13: 978-1484219638
- Product Dimensions: 7 x 1.7 x 10 inches
- Shipping Weight: 3 pounds (View shipping rates and policies)
- Average Customer Review: 5.0 out of 5 stars See all reviews (3 customer reviews)
- Amazon Best Sellers Rank: #62,241 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Pro SQL Server Internals 2nd ed. Edition
Use the Amazon App to scan ISBNs and compare prices.
Prepare for your professional certification with study guides and exam prep tools from Wiley. See more
Frequently bought together
Customers who bought this item also bought
From the Back Cover
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.
Pro SQL Server Internals is a book for developers and database administrators, and it covers multiple SQL Server versions starting with SQL Server 2005 and going all the way up to the recently released SQL Server 2016. The book provides a solid road map for understanding the depth and power of the SQL Server database server and teaches how to get the most from the platform and keep your databases running at the level needed to support your business. The book:
Provides detailed knowledge of new SQL Server 2016 features and enhancements
Includes revamped coverage of columnstore indexes and In-Memory OLTP Covers 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 log
About the Author
If you are a seller for this product, would you like to suggest updates through seller support?