Azure Synapse Analytics & Microsoft Fabric
A question that is often asked about Azure Synapse Analytics is how it handles Delta tables that are partitioned. Delta…
In a recent Synapse Analytics Serverless SQL Pools QnA session, the Serverless SQL Pools team stated that using External Tables…
This blog is marked as intermediate knowledge as an understanding of Serverless SQL Pools is preferable, but not essential. Refer to Getting Started…
Welcome to part 2 in this blog series in which we’re looking at what happens when schema changes are made…
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…
When data is stored in Azure Data Lake Gen2, we can use Azure Active Directory and Access Control Lists (ACLs)…
Serverless SQL Pools includes 2 SQL functions, filepath and filename, that can be used to return the folder path/name and…
Welcome to part one of a four part blog series where we’ll be looking at one of the main scenarios…