Connecting Power BI to Azure SQL Database using Private Endpoints
This was originally posted on my Datahai company blog in November 2021. This blog has now been updated as of…
Azure Synapse Analytics
This was originally posted on my Datahai company blog in November 2021. This blog has now been updated as of…
I’m currently in the process of building a Query and Workload Analyser Power BI report which queries several DMVs (Dynamic…
Recently I have been exploring an option to use an Azure SQL Database for a small footprint Data Warehouse and…
This blog is marked as intermediate knowledge as an understanding of Serverless SQL Pools is preferable, but not essential. Refer to Getting Started…
This blog is marked as intermediate knowledge as an understanding of Serverless SQL Pools is preferable, but not essential. Refer…
Welcome to the 3rd and final part in this blog series in which we’re looking at how Azure Synapse Analytics…
Welcome to part 2 in this blog series in which we’re looking at what happens when schema changes are made…
Serverless SQL Pools offers a straight-forward method of querying data including CSV, JSON, and Parquet format stored in Azure Storage.…
In part one we looked at a process in which a pre-aggregated dataset can be created by Azure Synapse Analytics…
Dedicated SQL Pools have a feature called Materialized Views which can generate a pre-calculated/processed dataset ready for consumption and is…