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-01-24 (first published: 2023-08-18)
8,866 reads
Build efficient and scalable batch and real-time data ingestion pipelines, DevOps continuous integration and deployment pipelines, and advanced analytics solutions on the Azure Data Platform. This book teaches you to design and implement robust data engineering solutions using Data Factory, Databricks, Synapse Analytics, Snowflake, Azure SQL database, Stream Analytics, Cosmos database, and Data Lake Storage Gen2.
- Printed book:
- Kindle book:
2025-01-22 (first published: 2023-07-13)
8,039 reads
Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance.
- Printed book:
- Kindle book:
2025-01-20 (first published: 2024-09-18)
2,930 reads
Data fabric, data lakehouse, and data mesh have recently appeared as viable alternatives to the modern data warehouse. These new architectures have solid benefits, but they're also surrounded by a lot of hyperbole and confusion. This practical book provides a guided tour of these architectures to help data professionals understand the pros and cons of each.
- Printed book:
- Kindle book:
2025-01-17 (first published: 2024-02-29)
4,503 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-01-17 (first published: 2024-11-25)
2,577 reads
Master Transact-SQL's fundamentals, and write correct, robust code for querying and modifying data with modern Microsoft data technologies, including SQL Server 2022, Azure SQL Database, and Azure SQL Managed Instance.
- Printed book:
- Kindle book:
2025-01-17 (first published: 2024-02-20)
2,965 reads
In The Unicorn Project, we follow Maxine, a senior lead developer and architect, as she is exiled to the Phoenix Project, to the horror of her friends and colleagues, as punishment for contributing to a payroll outage. She tries to survive in what feels like a heartless and uncaring bureaucracy and to work within a system where no one can get anything done without endless committees, paperwork, and approvals.
- Printed book:
- Kindle book:
2025-01-10 (first published: 2024-06-26)
3,682 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-01-06 (first published: 2023-08-18)
10,917 reads
Adapted from the acclaimed bestselling book, The Phoenix Project Graphic Novel Volume 1 introduces readers to a stalwart cast of characters as they are challenged by the four types of work that impact complex workflows.
2025-01-03 (first published: 2024-12-05)
1,769 reads
Bring your data to life with this accessible yet fast-paced introduction to Power BI, now in color.
- Printed book:
- Kindle book:
2025-01-02 (first published: 2023-06-19)
5,109 reads
