I have been spending a lot of time recently investigating the new performance-related features that have rolled out in Fabric Dataflows over the last few months, so expect a lot of blog posts on ...

As I described here, Power BI can send SQL queries in parallel in DirectQuery mode and you can see from the Timeline column there is some parallelism happening here – the last two SQL queries ...

A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.

Have you ever stared at a beautifully organized table in Excel—rows and columns perfectly aligned—only to realize it’s a nightmare for analysis? Cross-tab layouts, while visually appealing, can feel ...

Power Query Copilot is redefining how you manage and analyze data in Excel. By using AI-driven automation, this innovative tool simplifies tasks such as importing, synchronizing, and analyzing data ...

Abstract: In the context of business analytics, the tax consultants and auditors face challenges when conducting data analysis for tax optimization based on big commercial databases extracted from the ...

Microsoft unveiled .NET Aspire at the Build 2024 developer conference, describing it as an opinionated, cloud-ready stack for building observable, production ready, distributed, cloud-native ...

Excel is a powerhouse at transforming and manipulating data, thanks to a wide variety of Excel formulas and in-app tools. Add Power Query to this already powerful mix, and you get an even more ...