Power BI and a Star Schema
I sometimes get asked from customers if they should use a star schema or should they use one large single table/flatfile for their dataset in Power BI. The answer...
2021-03-05 (first published: 2021-03-01)
988 reads
James Serra's Blog
Power BI and a Star Schema
I sometimes get asked from customers if they should use a star schema or should they use one large single table/flatfile for their dataset in Power BI. The answer...
2021-03-01
9 reads
Data Mesh defined
The two latest trends in emerging data platform architectures are the Data Lakehouse (the subject of my last blog Data Lakehouse defined), and the Data Mesh, the subject of...
2021-02-19 (first published: 2021-02-16)
804 reads
Data Mesh defined
The two latest trends in emerging data platform architectures are the Data Lakehouse (the subject of my last blog Data Lakehouse defined), and the Data Mesh, the subject of...
2021-02-16
5 reads
Data Lakehouse defined
As a follow-up to my blog Data Lakehouse & Synapse, I wanted to talk about the various definitions I am seeing about what a data lakehouse is, including a...
2021-02-02 (first published: 2021-01-25)
589 reads
Data Lakehouse defined
As a follow-up to my blog Data Lakehouse & Synapse, I wanted to talk about the various definitions I am seeing about what a data lakehouse is, including a...
2021-01-25
5 reads
Syncing SQL databases
There are various ways to keep SQL Server databases and SQL Database/SQL Managed Instance (SQL MI) databases in-sync asynchronously that I will discuss in this blog. The main use...
2021-01-05 (first published: 2021-01-04)
821 reads
Syncing SQL databases
There are various ways to keep SQL Server databases and SQL Database/SQL Managed Instance (SQL MI) databases in-sync asynchronously that I will discuss in this blog. The main use...
2021-01-04
17 reads
DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Announced last week is a major new feature for Power BI: you can now use DirectQuery to connect to Azure Analysis Services or Power BI Datasets and combine it...
2021-01-01 (first published: 2020-12-23)
784 reads
DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Announced last week is a major new feature for Power BI: you can now use DirectQuery to connect to Azure Analysis Services or Power BI Datasets and combine it...
2020-12-23
4 reads
Blogs
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that...
Forums
Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
DBCC CHECKIDENT
Comments posted to this topic are about the item DBCC CHECKIDENT
Question of the Day
DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers