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)
20,821 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)
29,248 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)
30,880 reads
Blogs
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Forums
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Development Is Fun
Comments posted to this topic are about the item Development Is Fun
Optimized Locking in SQL Server 2025
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers