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
Data Warehousing\Business Intelligence
The Load of Real Time Data Warehouses
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
163 reads
How do you secure sensitive data in a modern Data Warehouse?
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,088 reads
2007-09-11
1,993 reads
2007-09-06
1,641 reads
2005-04-22
2,378 reads
2005-04-06
1,986 reads
2005-03-18
1,732 reads
2005-03-08
1,575 reads
2005-01-14
1,622 reads
Blogs
Securing Kubernetes With External Secrets Operator on AWS
Here’s a way to centralize management, rotate secrets conveniently without downtime, automate synchronization and...
Save Azure PostgreSQL Backup to Storage
This may or may not be helpful in the long term, but since I’m...
The Book of Redgate: What’s Great about Redgate?
By Steve Jones
“I’m sick of hearing about Red Gate.” The first article in the book has...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Pitfalls to avoid while feeding events into CrowdStrike
Comments posted to this topic are about the item Pitfalls to avoid while feeding...
Column Adds and Drops
Comments posted to this topic are about the item Column Adds and Drops
Question of the Day
Column Adds and Drops
I run this batch on SQL Server 2022. What happens?
ALTER TABLE dbo.Accounts ADD AccountAccessType INT GO ALTER TABLE dbo.Accounts DROP AccountAccessType GOSee possible answers