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 ...

IMPORTCSV can do the same job faster.

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.

As developers look to harness the power of AI in their applications, one of the most exciting advancements is the ability to enrich existing databases with semantic understanding through vector search ...

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 ...

Despite its steep licensing costs, SQL Server continues to prove its worth over open-source alternatives in some key areas. SQL Server is an expensive part of your IT stack -- SQL Server Enterprise ...

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 ...