Books > Computing & IT > Computer software packages > Database software
|
Buy Now
Pro SQL Server Internals (Paperback, 2nd ed.)
Loot Price: R1,914
Discovery Miles 19 140
You Save: R534
(22%)
|
|
Pro SQL Server Internals (Paperback, 2nd ed.)
Expected to ship within 10 - 15 working days
|
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 What You Will Learn Design
and develop database solutions with SQL Server. Troubleshoot
design, concurrency, and performance issues. Choose the right
database objects and technologies for the job. Reduce costs and
improve availability and manageability. Design disaster recovery
and high-availability strategies. Improve performance of OLTP and
data warehouse systems through in-memory OLTP and Columnstore
indexes. Who This Book Is 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.
General
Is the information for this product incomplete, wrong or inappropriate?
Let us know about it.
Does this product have an incorrect or missing image?
Send us a new image.
Is this product missing categories?
Add more categories.
Review This Product
No reviews yet - be the first to create one!
|
|
Email address subscribed successfully.
A activation email has been sent to you.
Please click the link in that email to activate your subscription.