Azure Synapse Analytics – Insight Quest

Automated Index Partition Rebuilds

July 4, 2020 Brett Powell

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

Synapse Columnstore Index Analysis Template

June 9, 2020 Brett Powell

This blog post describes a Power BI template that analyzes the quality of rowgroups within columnstore indexes in Azure Synapse Analytics. The template provides two

Power bi pro guide to Azure synapse analytics

May 31, 2020 Brett Powell

The Power BI Professional’s Guide to Azure Synapse Analytics, a white paper I wrote describing the Synapse Analytics platform and its benefits and use cases

Synapse SQL Monitoring Template

May 11, 2020 Brett Powell

This blog post provides two Power BI templates (one import, one DirectQuery) which query common dynamic management views (DMVs) used to monitor Azure Synapse Analytics.