SQL Books



Bookstore > Books > SQL

SQL Server Advanced Troubleshooting and Performance Tuning

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

Beginning jOOQ

Beginning jOOQ

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

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

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

SQL in a Nutshell, 4th Edition

SQL in a Nutshell, 4th Edition

by Kevin Kline, Regina O. Obe, Leo S. Hsu

For programmers, analysts, and database administrators, this Nutshell guide is the essential reference for the SQL language used in today's most popular database products. This new fourth edition clearly documents SQL commands according to the latest ANSI/ISO standard and details how those commands are implemented in Microsoft SQL Server 2019 and Oracle 19c, as well as in the MySQL 8, MariaDB 10.5, and...

Price:  $52.95  |  Publisher:  O'Reilly Media  |  Release:  2022

Learn dbatools in a Month of Lunches

Learn dbatools in a Month of Lunches

by Chrissy LeMaire, Rob Sewell, Jess Pomfret, Claudio Silva

Written by a group of expert authors including dbatools creator Chrissy LeMaire, Learn dbatools in a Month of Lunches teaches you techniques that will make you more effective - and efficient - than you ever thought possible. In twenty-eight lunchbreak lessons, you'll learn the most important use cases of dbatools and the favorite functions of its core developers. Stabilize and standardize your SQL serv...

Price:  $49.99  |  Publisher:  Manning  |  Release:  2022

SQL Antipatterns, Volume 1

SQL Antipatterns, Volume 1

by Bill Karwin

SQL is the ubiquitous language for software developers working with structured data. Most developers who rely on SQL are experts in their favorite language (such as Java, Python, or Go), but they're not experts in SQL. They often depend on antipatterns - -solutions that look right but become increasingly painful to work with as you uncover their hidden costs. Learn to identify and avoid many of these c...

Price:  $47.95  |  Publisher:  The Pragmatic Programmers  |  Release:  2022

Practical SQL, 2nd Edition

Practical SQL, 2nd Edition

by Anthony DeBarros

Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. Anthony DeBarros, a journalist and data analyst, focuses on using SQL to find the story within your data. The examples and code use the open-source database PostgreSQL and its companion pgAdmin interface, and the con...

Price:  $30.94  |  Publisher:  No Starch Press  |  Release:  2022

Microsoft Excel VBA and Macros

Microsoft Excel VBA and Macros

by Bill Jelen, Tracy Syrstad

Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you wont find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere;...

Price:  $34.39  |  Publisher:  Microsoft Press  |  Release:  2022

CockroachDB: The Definitive Guide

CockroachDB: The Definitive Guide

by Guy Harrison, Jesse Seldess, Ben Darnell

Get the lowdown on CockroachDB, the distributed SQL database built to handle the demands of today's data-driven cloud applications. In this hands-on guide, software developers, architects, and DevOps/SRE teams will learn how to use CockroachDB to create applications that scale elastically and provide seamless delivery for end users while remaining indestructible. Teams will also learn how to migrate ex...

Price:  $51.06  |  Publisher:  O'Reilly Media  |  Release:  2022

Pages: 1, 2, 3 ... 42 | Next→

Subscribe to Newsletter

Be the first to know about new IT books, upcoming releases, exclusive offers and more.