Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance.
2025-12-08 (first published: 2024-09-18)
5,302 reads
With built-in AI for application development and advanced analytics powered by Microsoft Fabric, SQL Server 2025 empowers you to innovate—securely and confidently. This book shows you how.
2025-12-05 (first published: 2025-11-10)
99 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.
2025-12-03 (first published: 2025-05-27)
3,496 reads
A step-by-step guide to harness the power of Microsoft Fabric in developing data analytics solutions for various use cases
2025-12-03 (first published: 2024-11-25)
10,330 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.
2025-12-03 (first published: 2025-05-27)
1,845 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.
2025-12-03 (first published: 2025-05-27)
1,102 reads
Now expanded and updated with modern best practices, this is the most complete guide to Microsoft’s DAX language for business intelligence, data modeling, and analytics. Expert Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization.
2025-12-03 (first published: 2024-09-18)
2,855 reads
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.
2025-12-01 (first published: 2025-10-14)
1,011 reads
Troubleshoot query performance issues, identify anti-patterns in your code, and write efficient T-SQL queries with this guide for T-SQL developers
2025-11-28 (first published: 2024-02-29)
4,463 reads
Murach's SQL Server 2022 for Developers is a comprehensive guide to database design and management. This computer book teaches essential SQL statements through clear examples and practical exercises. The book's unique paired-pages format makes learning database software concepts easier, while providing in-depth coverage of database management fundamentals. Ideal for both beginners and seasoned developers seeking to enhance their data management skills.
2025-11-26 (first published: 2025-10-14)
645 reads
The setup My day job involves babysitting a lot of Git repositories hosted on...
By John
Recently, the world was reminded of just how fragile the internet can be. Two...
By Brian Kelley
In Parts 1-3, I covered how I prepare for a certification exam. In this...
Hi So I have the below select query that won't return results if I...
Seeing this message repeated every 10 seconds in the RSHostingService_yyyy_mm_dd_hh_mm_ss.log file. Can anyone advise:...
I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers