Microsoft Fabric
Microsoft Fabric Data Store Guide: Lakehouse, Warehouse, KQL or SQL?
Confused about what to choose for your Microsoft Fabric data store? Compare Lakehouse, Warehouse, KQL, and SQL to determine your best option.
Microsoft MVP · Data architect, Brisbane
Practical guides to Microsoft Fabric and the Azure data platform
Step-by-step tutorials from real projects: admin settings, capacity and costs, pipelines, CI/CD and architecture. I've worked in data analytics since 2011, and I write things down so you don't have to work them out twice.
- 131guides published
- 2011in data analytics since
- MVPMicrosoft Most Valuable Professional
New
Latest on Microsoft Fabric
Most read
What people come here for
-
01
Azure Synapse Analytics Executing Azure Synapse Analytics Pipelines With Azure Logic Apps
- 02
- 03
-
04
Microsoft Fabric Admin Settings You Must Configure in Microsoft Fabric Part 1
-
05
Azure Synapse Analytics Azure Data Factory or Synapse Analytics Self-Hosted Integration Runtime Cluster
-
06
Azure Data Factory Documenting Azure Data Factory
Browse
Guides by topic
18 guides
Microsoft Fabric
Admin settings, capacity, costs, CI/CD, mirroring and the medallion architecture.
35 guides
Azure Data Factory
Pipelines, integration runtimes, linked services, Key Vault and monitoring.
31 guides
Azure Synapse Analytics
Workspaces, serverless SQL, Spark pools, dedicated pools and pipelines.
8 guides
Azure SQL Database
Security, data classification, masking and auditing in Azure SQL.
6 guides
Azure Storage Accounts
Blob and Data Lake Storage tiers, lifecycle rules and replication.
6 guides
Azure DevOps
CI/CD for SQL, Analysis Services, Data Factory and Synapse.
Community
Sharing is caring
I lead the Azure Data Services user group, organised the Brisbane AI Bootcamp from 2018 to 2020, co-founded the Brisbane AI User Group and speak at events in Australia, New Zealand and the US.
Talks and user groups- Azure Data ServicesUser group lead since 2019
- Brisbane AI BootcampOrganiser, 2018 to 2020
- SpeakerAustralia, New Zealand and the US
New guides, as I write them
I share every new post on LinkedIn, with what I'm working on in Fabric that week. Follow along, or ask me a question there.