Welcome to this data community blog all about Azure Synapse Analytics created by Andy Cutler covering Dedicated SQL Pools, Serverless SQL Pools, Pipelines, and Power BI . Click here to find out more.
Latest Blog
Keep updated with new blogs and videos.
Blog Categories
For all blogs, see the RECENT BLOGS section or jump into curated content directly below.
General Synapse
Serverless SQL Pools
- Getting Started with Serverless SQL Pools
- Serverless SQL Pools Learning Resources
- Serverless SQL Best Practices
- Creating a Logical Data Warehouse with Serverless SQL Pools
Conference & User Groups
DP-500 Enterprise Data Analyst
Hints and Tips
- Using CETAS in Serverless SQL Pools to write results to Azure Data Lake Gen2
- How Serverless SQL Pools deals with different file schemas
- Using Temporary Tables within Serverless SQL Pools
- Azure Storage Folder Filtering using the Filepath Function
- 10 Billion Rows: Parquet File Size and Distribution When using CETAS
RECENT BLOGS
- Azure Synapse Analytics Custom RolesRecently I had a challenge in terms of providing a least permissions possible security model for a Data Engineer persona … Read more
- Future Data Driven 2023 – Fabric SQLSession Abstract It all started with Parallel Data Warehouse, then came Azure SQL Data Warehouse…then Dedicated SQL Pools in Synapse! … Read more
- Synapse Link for Dataverse with Azure Synapse Analytics eBookIf you’re interested in using Synapse Link for Dataverse with a Dynamics 365 environment to export data for analysis in … Read more
- Transactions and Isolation Levels in Fabric WarehouseI trust everyone has been having fun with Fabric over the last few weeks, diving into various workload types like … Read more
- Temp Tables in Fabric Lakehouse SQL Endpoint and WarehouseThis blog has been adapted from an earlier blog about using temp tables in Synapse Serverless SQL Pools. As the … Read more
- Play Around: Deploy Database Projects to Fabric WarehouseI always like to have a dig around, try a few things and see if something works (most likely unsupported!) … Read more
- Fabric in ProductionThis is a placeholder blog which will be revisted many, many times over the coming months. This is a list … Read more
- Getting Started with Microsoft Fabric: Enabling 60-Day Trial and Analysing DataThere’s been an exciting new announcement at Microsoft Build in the form of Microsoft Fabric, a unified platform that brings … Read more
- Synapse Link for Dataverse: Delta Lake Export ConfigurationWelcome to part 2 in the Synapse Link for Dataverse Delta Lake series. In the recently released functionality in Synapse … Read more
Latest Videos
BLOG TAGS
A
B
C
D
E
F
G
J
L
N
O
P
R
S
T
U
V
W
LOGICAL DATA WAREHOUSE SERIES
- Creating a Logical Data Warehouse with Synapse Serverless SQL: Part 1 of 4 – Setting Up and Querying Source Data
- Creating a Logical Data Warehouse with Synapse Serverless SQL: Part 2 of 4 – Creating a Dimensional Model
- Creating a Logical Data Warehouse with Synapse Serverless SQL: Part 3 of 4 – Incremental Fact Loading and Slowly Changing Dimensions
- Creating a Logical Data Warehouse with Synapse Serverless SQL: Part 4 of 4 – Connecting Power BI to the Dimensional Model