Learn T-SQL Querying
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-05 (first published: 2024-02-29)
3,918 reads
Books
Learn Microsoft Fabric: A practical guide to performing data analytics in the era of artificial intelligence
A step-by-step guide to harness the power of Microsoft Fabric in developing data analytics solutions for various use cases
2025-11-03 (first published: 2024-11-25)
10,240 reads
Introduction to PostgreSQL for the data professional
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.
2025-10-31 (first published: 2025-02-06)
4,279 reads
Architecting Power BI Solutions in Microsoft Fabric
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-10-29 (first published: 2025-05-27)
3,158 reads
The Phoenix Project
In this newly updated and expanded edition of the bestselling The Phoenix Project, co-author Gene Kim includes a new afterword and a deeper delve into the Three Ways as described in The DevOps Handbook.
2025-10-27 (first published: 2024-02-20)
3,212 reads
Microsoft Power BI Quick Start Guide: The ultimate beginner's guide to data modeling, visualization, digital storytelling, and more, 3rd Edition
Bring your data to life with this accessible yet fast-paced introduction to Power BI, now in color.
2025-10-24 (first published: 2023-06-19)
12,960 reads
Refactoring Databases: Evolutionary Database Design
Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance.
2025-10-20 (first published: 2024-09-18)
4,983 reads
The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel
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-10-17 (first published: 2024-09-18)
2,843 reads
Murach's SQL Server 2022 for developers
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-10-14
39 reads
SQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques
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-10-14
35 reads
Blogs
SQL Server Database Migration Pitfalls
SQL Server Database Migration Pitfalls (and How to Fix Them) Database migrations are where great...
Scooby Dooing Episode 10: The Case of the Copy-and-Paste Consultant
Every Scooby-Doo episode has one thing in common — there’s always a fake ghost....
Regression Testing: DAX User Defined Functions
User Defined Functions is a new feature in PowerBI currently in public preview. There...
Forums
Large posts full of code not allowed anymore?
Several times now, I've seen a post asking for a solution. I've replied, and...
Data > Hype
Comments posted to this topic are about the item Data > Hype
Create and Read the Analysis Services Flight Recorder
Comments posted to this topic are about the item Create and Read the Analysis...
Question of the Day
Slipstream parameters
What parameters are needed to enable a slipstream installation for setup.exe (SQL Server setup)?
See possible answers