7 min read
BigQuery Mirroring Is GA: Zero-ETL Multicloud Has a Bill Too
Fabric mirroring for BigQuery is GA, but it moves cost to Google: CDC compute, egress, keyless reseeds and schema ownership decide when to mirror or copy.
Data Integration
10 articles
1 min read
Change Data Capture in Microsoft Fabric
CDC captures row level changes (inserts, updates, deletes) from source systems: The simplest option for supported sources: For more control over the CDC…
1 min read
Snowflake Mirroring to Fabric: Cross-Cloud Data Integration
Mirroring eliminates the need for complex ETL between these systems.
1 min read
External Data Access Patterns in Microsoft Fabric
Accessing external data is essential for hybrid and multi-cloud scenarios. Today I'm exploring external data access patterns in Microsoft Fabric.
1 min read
Cross-Database Queries in Fabric: Unified Data Access
Tomorrow we'll explore Query Insights for monitoring and optimization. Cross Database Queries OneLake Shortcuts Security Model
1 min read
Fabric Data Factory: Data Integration Reimagined
Tomorrow we'll dive deeper into Copy Activity patterns. Data Factory in Fabric Data Pipeline Documentation Pipeline Expressions
1 min read
OneLake Shortcuts: Connecting Data Without Copying
Of everything announced at Build 2023, OneLake shortcuts might be the feature I find most architecturally elegant. A shortcut is not a copy, not a linked…
1 min read
Data Factory in Microsoft Fabric: Modern Data Integration
Data Pipelines in Fabric are similar to Azure Data Factory pipelines but with deeper Fabric integration.
1 min read
Azure Data Factory Copy Activity: Moving Data at Scale
The Copy Activity in Azure Data Factory is the activity I configure more than any other—it's the data movement primitive that connects over 90 source and…
2 min read
SQL Database Indexing with Azure Cognitive Search
Azure SQL to Cognitive Search is a combination I've set up half a dozen times, and the reason it keeps appearing is that most enterprise organisations…