Slowly Changing Facts
This article describes a design pattern for storing “effective dated" changes to fact tables.
2013-10-18 (first published: 2010-12-22)
17,712 reads
Mark Murphy
Incremental Data Loading Using CDC
Describes a design pattern for using CDC to power fast and efficient incremental data loads.
2013-06-07 (first published: 2011-01-17)
20,808 reads
Using FULL JOINs to Compare Datasets
This article describes a technique of using FULL JOINs to compare two datasets within a numerical tolerance.
2013-04-23 (first published: 2010-09-27)
29,181 reads
Blogs
Transforming JSON data with the help of Azure Data Factory - Part 3
By Rayis Imayev
(2020-Apr-06) Traditionally I would use data flows in Azure Data Factory (ADF) to flatten (transform)...
Disks performance in Azure
By nelsonaloor
In our earliest post, we have discussed in detail about the factors that affect...
A Smattering of Thoughts About Applying Site Reliability Engineering principles
By Sheldon Hull
What's This about I figured I'd go ahead and take this article which I've gutted...
Forums
fetcth aggregate data
Hi All, I am having table where below list of columns OrderNo ActualHours...
Who is the best person for the job?
Comments posted to this topic are about the item Who is the best person...
Create Custom Functions in Power Query
Comments posted to this topic are about the item Create Custom Functions in Power...
Ask SSC