Perhaps the most important decisions business intelligence professionals make is determining which technologies to learn and to what extent or depth should they grow their
Category: T-SQL
Automated Index Partition Rebuilds
This post provides an example of a stored procedure which A) identifies the last two partitions of an Azure Synapse Analytics SQL pool table (which
Simple DirectQuery Performance Tips
This blog describes a few simple, easy-to-implement techniques that can be used to increase the performance and scalability of Power BI reports which utilize DirectQuery
Paginated Report Execution Time
One of the most common requirements for paginated reports, which are often printed or exported, is to note the date and time the report was
Dynamic Datasets Part I
The purpose of this post is to introduce a method of making the datasets embedded in paginated reports more dynamic. Specifically, multiple queries reflecting distinct
Analyze SQL Agent Job History with Power BI
The purpose of this post is to share and describe a Power BI-based solution for analyzing SQL Server Agent job history data. SQL Server Agent
Insight Quest 