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,764 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,083 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,798 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Raya Kuta - CCR Telp:Cs.WA:0831•7943•7466
WhatsApp 0831•7943•7466 Jl. Raya Kuta No.55X, Kuta, Kec. Kuta, Kabupaten Badung, Bali 80361
BCA KCP Kas Antapani Telpon. 08388331767
WhatsApp 08388331767 Jl. Terusan Jakarta No.57, Cicaheum, Kec. Antapani, Kota Bandung, Jawa Barat 40282
BCA KCP Kas Pondok Labu No.telp:083834809483
Jl. RS. Fatmawati Raya No.1A, Pd. Labu, Kec. Cilandak, Kota Jakarta Selatan, Daerah Khusus...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers