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
Category: Azure Synapse Analytics
Synapse Columnstore Index Analysis Template
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
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
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.
