Data Warehouse Considerations - SCD Type 2 vs Overwrite Dimension Tables
How we handle data warehousing updates to dimension tables is crucial and this article covers Slowly Changing Dimensions versus overwriting tables.
2024-12-20
How we handle data warehousing updates to dimension tables is crucial and this article covers Slowly Changing Dimensions versus overwriting tables.
2024-12-20
How much load do real time updates place on a data warehouse? Steve has a few thoughts on the analysis of the Amazon Redshift dataset, Redset.
2024-10-07
219 reads
In 2019 Canadian Broadcasting Corporation (CBC) news reported a massive data breach at the Desjardins Group, which is a Canadian financial service cooperative and the largest federation of credit unions in North America. The report indicated, a "malicious" employee copied sensitive personal information collected by Desjardins from their data warehouse. The data breach compromised the […]
2022-03-30
3,135 reads
2007-09-11
1,996 reads
2007-09-06
1,643 reads
2005-04-22
2,380 reads
2005-04-06
1,988 reads
2005-03-18
1,734 reads
2005-03-08
1,578 reads
2005-01-14
1,623 reads
By Chris Yates
Trust is the currency of the data economy. Without it, even the most advanced...
By Steve Jones
Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This...
By Kevin3NF
If your production SQL Servers are still running 2016 (or older) you’re basically banking...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item SQL Server Ghosts
Comments posted to this topic are about the item The Selfish Case for Learning...