Use this practical guide to analyze and troubleshoot SQL Server performance using wait statistics. You'll learn to identify precisely why your queries are running slowly. And you'll know how to measure the amount of time consumed by each bottleneck so you can focus attention on making the largest improvements first. This edition is updated to cover analysis of wait statistics current with SQL Server 2022. Whether you are new to wait statistics, or already familiar with them, this book provides a deeper understanding on how wait statistics are generated and what they mean for your SQL Server instance’s performance.
- Printed book:
- Kindle book:
2025-07-04 (first published: 2023-08-18)
11,249 reads
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 correction, and other advanced features now available in SQL Server.
- Printed book:
- Kindle book:
2025-07-02 (first published: 2025-05-27)
937 reads
Learn how to write and design simple and efficient T-SQL code. This is a hands-on book that teaches you how to write better T-SQL with examples and straightforward explanations.
- Printed book:
- Kindle book:
2025-06-30 (first published: 2023-08-18)
13,287 reads
A step-by-step guide to harness the power of Microsoft Fabric in developing data analytics solutions for various use cases
- Printed book:
- Kindle book:
2025-06-27 (first published: 2024-11-25)
5,369 reads
Bring your data to life with this accessible yet fast-paced introduction to Power BI, now in color.
- Printed book:
- Kindle book:
2025-06-25 (first published: 2023-06-19)
10,330 reads
Business Intelligence (BI) tools like Power BI are used by a wide range of professionals, creating diverse and complex scenarios, and finding the right solution can be daunting, especially when multiple approaches exist for a single use case. The author distills his 17 years of experience on various data platform technologies in this book to walk you through various Power BI usage scenarios.
- Printed book:
- Kindle book:
2025-06-23 (first published: 2025-05-27)
1,015 reads
Adoption and use of PostgreSQL is growing all the time. From mom-and-pop shops to large enterprises, more data is being managed by PostgreSQL. In turn, this means that more data professionals need to learn PostgreSQL even when they have experience with other databases. While the documentation around PostgreSQL is detailed and technically rich, finding a simple, clear path to learning what it is, what it does, and how to use it can be challenging. This book seeks to help with that challenge.
- Printed book:
- Kindle book:
2025-06-20 (first published: 2025-02-06)
1,792 reads
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 executable examples in several flavors of SQL, including Oracle, DB2, SQL Server, MySQL, and PostgreSQL.
- Printed book:
- Kindle book:
2025-06-18 (first published: 2025-05-27)
659 reads
Big Data Analytics with Spark is a step-by-step guide for learning Spark, which is an open-source fast and general-purpose cluster computing framework for large-scale data analysis. You will learn how to use Spark for different types of big data analytics projects, including batch, interactive, graph, and stream data analysis as well as machine learning. In addition, this book will help you become a much sought-after Spark expert.
- Printed book:
- Kindle book:
2025-05-27 (first published: 2023-06-19)
4,674 reads
Directfrom Microsoft, this Exam Ref is the official study guide for the new MicrosoftDP-300 Administering Microsoft Azure SQL Solutions certification exam.
2025-05-27 (first published: 2023-12-10)
1,869 reads
