by Bonny P McClain
Geospatial analysis is industry agnostic and a powerful tool for answering location questions. Combined with the power of SQL, developers and analysts worldwide rely on database integration to solve real-world spatial problems. This book introduces skills to help you detect and quantify patterns in datasets through data exploration, visualization, data engineering, and the application of analysis and spatia...
Price: $44.99 | Publisher: Packt Publishing | Release: 2023
by Stephen B. Morris
As legacy and other critical systems continue to migrate online, the need for continuous operation is imperative. Code has to handle data issues as well as hard external problems today, including outages of networks, storage systems, power, and ancillary systems. This practical guide provides system administrators, DevSecOps engineers, and cloud architects with a concise yet comprehensive overview on how to...
Price: $79.99 | Publisher: O'Reilly Media | Release: 2023
Expert Performance Indexing in Azure SQL and SQL Server 2022, 4th Edition
by Edward Pollack, Jason Strate
Take a deep dive into perhaps the single most important facet of query performance - indexes - and how to best use them. Newly updated for SQL Server 2022 and Azure SQL, this fourth edition includes new guidance and features related to columnstore indexes, improved and consolidated content on Query Store, deeper content around Intelligent Query Processing, and other updates to help you optimize query execut...
Price: $44.99 | Publisher: Apress | Release: 2023
by Marten Deinum, Daniel Rubio, Josh Long
This in-depth Spring-based Java developer code reference has been updated and now solves many of your Spring Framework 6 problems using reusable, complete and real-world working code examples. Spring 6 Recipes (5th Edition) now includes Spring Native which speeds up your Java-based Spring Framework built enterprise, native cloud, web applications and microservices. It also has been updated to now include Sp...
Price: $56.34 | Publisher: Apress | Release: 2023
by Andres Sacco
Use the popular Spring Data project for data access and persistence using various Java-based APIs such as JDBC, JPA, MongoDB, and more. This book shows how to easily incorporate data persistence and accessibility into your microservices, cloud-native applications, and monolithic enterprise applications. It also teaches you how to perform unit and performance testing of a component that accesses a database. ...
Price: $38.30 | Publisher: Apress | Release: 2023
SQL Server Advanced Troubleshooting and Performance Tuning 
by Dmitri Korotkevitch
This practical book provides a comprehensive overview of troubleshooting and performance tuning best practices for Microsoft SQL Server. Database engineers, including database developers and administrators, will learn how to identify performance issues, troubleshoot the system in a holistic fashion, and properly prioritize tuning efforts to attain the best system performance possible.Author Dmitri Korotkevi...
Price: $56.95 | Publisher: O'Reilly Media | Release: 2022
Trino: The Definitive Guide, 2nd Edition
by Matt Fuller, Manfred Moser, Martin Traverso
Perform fast interactive analytics against different data sources using the Trino high-performance distributed SQL query engine. In the second edition of this practical guide, you'll learn how to conduct analytics on data where it lives, whether it's a data lake using Hive, a modern lakehouse with Iceberg or Delta Lake, a different system like Cassandra, Kafka, or SingleStore, or a relational data...
Price: $52.99 | Publisher: O'Reilly Media | Release: 2022
by Tayo Koleoso
Learn to use the jOOQ library to manage SQL database operations in Java and JVM applications. This book walks you through what JOOQ is, how to install and get started with it, and then gets you working with it.Practical examples and case studies demonstrate how jOOQ offers a more efficient and versatile alternative to Object-Relational Mapping frameworks like Hibernate and JPA, while providing a natural, na...
Price: $39.69 | Publisher: Apress | Release: 2022
Analytics Optimization with Columnstore Indexes in Microsoft SQL Server
by Edward Pollack
Meet the challenge of storing and accessing analytic data in SQL Server in a fast and performant manner. This book illustrates how columnstore indexes can provide an ideal solution for storing analytic data that leads to faster performing analytic queries and the ability to ask and answer business intelligence questions with alacrity. The book provides a complete walk through of columnstore indexing that en...
Price: $40.69 | Publisher: Apress | Release: 2022
SQL Server 2022 Query Performance Tuning, 6th Edition
by Grant Fritchey
Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under pressure to provide more speed. This new edition has been redesigned and rewritten from scratch based on the last 15 years of learning, knowledge, and experience accumulated by the author. The book Includes expanded information on using extended events, automatic execution plan corr...
Price: $44.99 | Publisher: Apress | Release: 2022