Dimensional Modeling Case Study Part 3 - Dynamic Days Dimension
In this next installment of the date dimension series, learn how to create a table that supports different types of banding.
2025-06-13
1,548 reads
In this next installment of the date dimension series, learn how to create a table that supports different types of banding.
2025-06-13
1,548 reads
Ever wonder all the reasons that we use databases instead of file systems? While we don’t think of it too much anymore, the first reason that databases came into existence was to remove redundancies.
2024-04-12
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,076 reads
Learn how you can handle dimensional modeling in a data warehouse when your data uses different categorization for ages.
2024-01-12
2,712 reads
Today Steve talks about data modeling and how standards can transfer knowledge between developers.
2023-11-22
432 reads
Our design and modeling is often done with some level of uncertainty. Steve has a few guidelines today.
2022-10-26
169 reads
2020-09-15
182 reads
A proper relationship between two people, places or things improves the communication between them. In every real-world based application, this logic holds and a database is no different. This article discusses the different relationship types possible between database objects. The designing of these relationships between them is called modeling, and the three types of relationships […]
2020-08-31
7,435 reads
To design, or redesign, a database of any complexity, the Entity-Relationship modelling tool becomes essential. The specialized tools that have dominated the industry for a long while are expensive and are installed on a workstation. Now that browser technology has progressed so rapidly, the online database modelling tools have become viable and are starting to attract the attention of database designers. Are they good enough to use now? Robert Sheldon finds out.
2016-03-11
4,547 reads
In today’s Software Development Life Cycle (SDLC), having a robust build pipeline is very...
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
By Kevin3NF
Things your cloud vendor may not tell you Here’s a common theme I...
Hi, I have a requirement to fetch the year from an imported .csv file...
I will have to test this next week, but will not have a chance...
I want to add a condition in the joining columns part of the merge...
I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?
SELECT * FROM dbo.Products WHERE ProductID BETWEEN 4 AND 7;See possible answers