High Performance SQL Server, 2nd Edition
Consistent Response for Mission-Critical Applications
| Price | $44.53 - $52.57
|
| Rating |  |
| Author | Benjamin Nevarez |
| Publisher | Apress |
| Published | 2021 |
| Pages | 397 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1484264908 |
| ISBN-13 | 9781484264904 |
Design and configure SQL Server instances and databases in support of high-throughput, mission-critical applications providing consistent response times in the face of variations in numbers of users and query volumes. In this new edition, with over 100 pages of additional content, every original chapter has been updated for SQL Server 2019, and the book also includes two new chapters covering SQL Server on Linux and Intelligent Query Processing.
This book shows you how to configure SQL Server and design your databases to support a given instance and workload. You will learn advanced configuration options, in-memory technologies, storage and disk configuration, and more, all aimed toward enabling your desired application performance and throughput.
Configuration doesn't stop with implementation. Workloads change over time, and other impediments can arise to thwart desired performance. High Performance SQL Server covers monitoring and troubleshooting to aid you in detecting and fixing production performance problems and minimizing application outages. You will learn about a variety of tools, ranging from the traditional wait analysis methodology to the query store or indexing, and you will learn how improving performance is an iterative process.
This book is an excellent complement to query performance tuning books and provides the other half of what you need to know by focusing on configuring the instances on which mission-critical queries are executed.
- Benjamin Nevarez (3 books)
Similar Books
Expert Performance Indexing in SQL Server, 2nd Edition 
by Grant Fritchey, Jason Strate
This book is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that ar...
Price: $56.42 | Publisher: Apress | Release: 2015
Microsoft SQL Server 2008 R2 Administration Cookbook
by Satya Shyam K Jayanty
Provides Advanced Administration techniques for SQL Server 2008 R2 as a book. Covers the essential Manageability, Programmability, and Security features. Emphasizes important High Availability features and implementation. Explains how to maintain and manage the SQL Server data platform effectively....
Price: $32.99 | Publisher: Packt Publishing | Release: 2011
by Edward Pollack
Take a deep dive into the many uses of dynamic SQL in Microsoft SQL Server. This edition has been updated to use the newest features in SQL Server 2016 and SQL Server 2017 as well as incorporating the changing landscape of analytics and database administration. Code examples have been updated with new system objects and functions to impro...
Price: $30.40 | Publisher: Apress | Release: 2019
by Anthony Molinaro, Robert de Graaf
You may know SQL basics, but are you taking advantage of its expressive power? This second edition applies a highly practical approach to Structured Query Language (SQL) so you can create and manipulate large stores of data. Based on real-world examples, this updated cookbook provides a framework to help you construct solutions and execut...
Price: $44.41 | Publisher: O'Reilly Media | Release: 2020
Node.js in Action, 2nd Edition
by Alex Young, Bradley Meck, Mike Cantelon, Tim Oxley, Marc Harter, T.J. Holowaychuk, Nathan Rajlich
You already know JavaScript. The trick to mastering Node.js is learning how to build applications that fully exploit its powerful asynchronous event handling and non-blocking I/O features. The Node server radically simplifies event-driven real-time apps like chat, games, and live data analytics, and with its incredibly rich ecosystem of m...
Price: $25.18 | Publisher: Manning | Release: 2017
Securing SQL Server, 2nd Edition
by Peter A. Carter
Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy for your database enterprise. This new edition covers threat analysis, common attacks and countermeasures, and provides an introduction to compliance that is useful for meeting regulatory requirements such as the GDPR. The multi-layered...
Price: $29.47 | Publisher: Apress | Release: 2018
Nginx HTTP Server, 2nd Edition
by Clement Nedelcu
Nginx is a lightweight HTTP server designed for high-traffic websites, with network scalability as the primary objective. With the advent of high speed Internet access, short loading times and fast transfer rates have become a necessity. This free, open source solution will either come as a full replacement of other software such as Apach...
Price: $26.99 | Publisher: Packt Publishing | Release: 2013
Beginning SQL Queries, 2nd Edition
by Clare Churcher
Get started on mastering the one language binding the entire database industry. That language is SQL, and how it works is must-have knowledge for anyone involved with relational databases, and surprisingly also for anyone involved with NoSQL databases. SQL is universally used in querying and reporting on large data sets in order to genera...
Price: $23.95 | Publisher: Apress | Release: 2016