Dimensional Modeling Case Study, Part 4 – Dynamic Time Duration Dimension
In this next article, we look at creating balanced dimensions on demand.
2025-07-16
656 reads
In this next article, we look at creating balanced dimensions on demand.
2025-07-16
656 reads
What is your choice for data warehousing? Is it a cloud platform? Which one is attractive to you?
2025-06-23
211 reads
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
216 reads
Learn how you can model days in a dimension that might need to be aggregated in different ways for your data warehouse operations.
2024-02-07
2,172 reads
This article gives an overview of Amazon Redshift, the cloud data warehouse in AWS.
2023-07-24
25,585 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,130 reads
Agile data warehousing can be challenging. Pairing the right methodologies and tools can help. Here is how my team met the challenge by using Data Vault methodology and BIML scripting.
2014-09-04
2,595 reads
2014-07-24
1,634 reads
In this article, Arshad Ali goes intp detail about how a data warehouse is different from operational data store and the different design methodologies for a data warehouse.
2013-07-03
6,374 reads
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
By James Serra
A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
By Steve Jones
I saw an article recently about implicit transactions and coincidentally, I had a friend...
We’re running SQL Server 2019 with database compatibility level 150, and after recent tuning...
Comments posted to this topic are about the item Changing the Recovery Time
Comments posted to this topic are about the item Getting More Time from AI
I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?
ALTER DATABASE Finance SET TARGET_RECOVERY_TIME = 12 xxx;See possible answers