A step-by-step guide to harness the power of Microsoft Fabric in developing data analytics solutions for various use cases
2025-01-15 (first published: 2024-11-25)
2,440 reads
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.
2025-01-13 (first published: 2023-08-18)
8,590 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.
2025-01-10 (first published: 2024-06-26)
3,671 reads
Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance.
2025-01-08 (first published: 2024-09-18)
2,459 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.
2025-01-06 (first published: 2023-08-18)
10,894 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,764 reads
Bring your data to life with this accessible yet fast-paced introduction to Power BI, now in color.
2025-01-02 (first published: 2023-06-19)
5,101 reads
Know how to track changes and key events in your SQL Server databases in support of application troubleshooting, regulatory compliance, and governance. This book shows how to use key features in SQL Server ,such as SQL Server Audit and Extended Events, to track schema changes, permission changes, and changes to your data. You’ll even learn how to track queries run against specific tables in a database. ss
2025-01-02 (first published: 2023-05-08)
7,046 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.
2025-01-02 (first published: 2023-07-13)
7,649 reads
The book begins with the basics, explaining what low-code and no-code are and showing how to maximize efficiency in creating business applications for one's organization. Next, the book describes the Microsoft Power Platform's foundation, as well as all its components and services. Readers will begin with practical exercises right away, beginning with provisioning a Power Platform environment. Next, the book delves deeper into the Power Platform components such as Power Apps, Power Automate, Power BI, and Power Virtual Agents. Towards the end, the book explains practical exercises for each feature or service where you will gradually build a small business solution for a fictitious organization, Project Wizards, Inc.
2024-12-18 (first published: 2023-10-18)
2,452 reads
By Steve Jones
The more I work with the Data API Builder (DAB), the more I lean...
By Steve Jones
It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...
By DataOnWheels
Wow I am so late in posting these notes! But this conference was amazing,...
We are self hosting sql servers, we are not using Azure for sql servers....
Hi everyone, Trying to get this data to the following format but I can't...
I am trying to implement a SSRS reporting dashboard similar to the SQL-performance-dashboard-reports that...
When does a column declared as SPARSE use no storage?
See possible answers