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
131 reads
Data Warehousing\Business Intelligence
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,039 reads
2007-09-11
1,992 reads
2007-09-06
1,640 reads
2005-04-22
2,377 reads
2005-04-06
1,985 reads
2005-03-18
1,731 reads
2005-03-08
1,574 reads
2005-01-14
1,620 reads
2005-01-13
1,530 reads
Blogs
A Very Cool Benefit in SSMS 21
By Steve Jones
I saw a post from Erin that Preview 2 is available. I’d gotten a...
AI Helping with an API
By Steve Jones
Can an AI help me with some database API work? Let’s see. This is...
Creating a “Real” Copy of a View: #SQLNewBlogger
By Steve Jones
I saw a post where a developer was trying to read the Information Schema...
Forums
Getting blockage on Update Statement
Hi, Need your help. I've a SP that is using Update statement on a...
Query is filling Tempdb
I have query which is filling TEMPDB I need suggestion how to modify this...
Script is filling Tempdb
I have query which is filling TEMPDB I need suggestion how to modify this...
Question of the Day
The Hash Join III
In a hash join, if all the build input does not fit in memory, what type of hash join is this?
See possible answers