8 min read
GPU-Accelerated Fabric Warehouse: How to Read the 7x Claim
Fabric Data Warehouse GPU query acceleration is in preview. Why the 7x benchmark won't predict your bill, and how to run a fair A/B test on your own queries.
Data Warehouse
19 articles
9 min read
Publish Only Verified Loads with Fabric Warehouse Snapshots
A write-audit-publish pattern for Fabric Data Warehouse: load, run SQL checks, then roll a warehouse snapshot forward so analysts only see verified data.
8 min read
Fabric Warehouse Tables or Lakehouse Shortcuts: Where Each Table Lives
A placement rule for Fabric: when data belongs in a Warehouse table you own, and when reading a lakehouse shortcut through the SQL analytics endpoint is enough.
8 min read
When Two Fabric Reports Disagree: A Metric Drift Runbook
A triage runbook for disputed numbers in Fabric: check definition, timing, filters and logic in order, using time travel, snapshots and Semantic Link.
8 min read
One Metric, One Home: Ownership Rules That Stop Drift in Fabric
How to stop metric drift in Fabric by giving every metric one home layer and one named owner, then enforcing both rules with schemas, grants and versions.
8 min read
SQL in Fabric: Give Analysts a View Layer, Not Your Tables
How I design an analyst-facing schema in Fabric Data Warehouse: views as the contract, permissions scoped to it, and SQL checks that catch breaks first.
7 min read
Fabric Warehouse: Decide Fact Table Grain Before You Tune Anything
Why fact table grain, not clustering or statistics, sets the performance ceiling in Fabric Data Warehouse, and how to declare and test it in T-SQL.
6 min read
Drafting a Star Schema with GPT-4o and Structured Outputs
Use GPT-4o structured outputs to draft a star schema from requirements, check it with plain code, and generate Fabric Warehouse DDL that respects its limits.
1 min read
Copilot for SQL in Microsoft Fabric Data Warehouse
Copilot for SQL transforms natural language into T-SQL queries. Today I'm exploring how to leverage AI for data warehouse development in Fabric.
1 min read
T-SQL in Fabric: Patterns and Best Practices
If you're coming to Fabric Warehouse from a SQL Server or Azure SQL Database background, the T-SQL compatibility is reassuring — CTEs, window functions…
1 min read
Fabric Warehouse: Cloud-Native SQL Analytics
The Fabric Warehouse is the part of Microsoft Fabric that surprised me most in hands-on testing. I expected it to be the Lakehouse's SQL analytics endpoint…
1 min read
Synapse Data Warehouse in Microsoft Fabric: Cloud-Native SQL Analytics
The Fabric Data Warehouse provides enterprise SQL analytics without infrastructure management. Tomorrow, I will cover Synapse Real-Time Analytics for…
1 min read
Synapse Pathway: Accelerating Data Warehouse Migration
Synapse Pathway translates SQL code from various sources to Azure Synapse Analytics SQL syntax: Teradata to Synapse Netezza to Synapse Snowflake to Synapse…
1 min read
Azure Synapse Analytics Updates: Ignite 2022 Highlights
Azure Synapse Analytics continues to mature as a comprehensive analytics platform. The improvements in serverless SQL, Spark integration, and data lake…
2 min read
Databricks SQL: Analytics Warehousing on the Lakehouse
Databricks SQL offers: SQL Endpoints : Serverless compute for SQL queries Query Editor : Web based SQL IDE Dashboards : Built in visualization and reporting…
2 min read
Azure Synapse Dedicated SQL Pool Best Practices
Synapse Dedicated SQL Pool (formerly Azure SQL Data Warehouse) is the massively parallel processing (MPP) engine for structured, petabyte-scale analytical…
1 min read
Azure Synapse Dedicated SQL Pools for Enterprise Data Warehousing
Dedicated SQL pools distribute data across 60 distributions for parallel processing: Control node : Orchestrates queries and manages metadata Compute nodes…
1 min read
Azure Synapse Dedicated SQL Pools (Preview): Enterprise Data Warehousing
Note: While dedicated SQL pools are mature (evolved from Azure SQL DW), the Synapse unified experience is still in preview.
7 min read
Azure Synapse Analytics in Preview: What's GA and Where to Start
A first-day tour of Azure Synapse Analytics in August 2020: which parts are GA, which are preview, and why I start with SQL on-demand before a SQL pool.