Modern Data Warehouse explained
I created a short YouTube video (20 minutes) that is a whiteboarding session that describes the five stages (ingest, store, transform, model, visualize) that make up a modern data...
2021-04-27
1 reads
I created a short YouTube video (20 minutes) that is a whiteboarding session that describes the five stages (ingest, store, transform, model, visualize) that make up a modern data...
2021-04-27
1 reads
An extension to the Modern Data Warehouse (MDW) that I have heard a bit about lately is called “Reverse ETL”. Before I describe what that is, first I wanted...
2021-04-14 (first published: 2021-04-12)
777 reads
An extension to the Modern Data Warehouse (MDW) that I have heard a bit about lately is called “Reverse ETL”. Before I describe what that is, first I wanted...
2021-04-12
4 reads
As you can tell, I have switched to a new WordPress theme for this blog site. I have now been blogging for ten years! It seemed like a good...
2021-03-20
20 reads
As you can tell, I have switched to a new WordPress theme for this blog site. I have now been blogging for ten years! It seemed like a good...
2021-03-20
1 reads
Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform and...
2021-03-10 (first published: 2021-03-04)
750 reads
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)
685 reads
Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform and...
2021-03-04
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
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)
688 reads
By Steve Jones
We added a solar system to the ranch as a way to hedge against...
TLDR; The code to do this is below but it’s a bit hokey and...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Comments posted to this topic are about the item Shared Work Spaces: Hell, Heaven,...
Hello, Consider the following table that gives the validity dates of an item :...
Comments posted to this topic are about the item Migrate the SSIS Catalog in...