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)
18,324 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)
21,771 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,436 reads
Blogs
Goal Progress–November 2020
By Steve Jones
This is my report, which continues on from the Oct report. It’s getting near...
Azure Synapse Analytics is GA!
By James-Serra
(Note: I will give a demo on Azure Synapse Analytics this Saturday Dec 5th...
5 Things You Should Know About Azure SQL
By John
Azure SQL offers up a world of benefits that can be captured by consumers...
Forums
Database, RAM and processor Information
Hi, I need to find the size of all db's and server's processor and...
reference for writing stored procedures (especially spatial) in DB2
I can write stored procedures in SQL Server ... is there a guide somewhere...
A Technology Collapse
Comments posted to this topic are about the item A Technology Collapse
Ask SSC