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
806 reads
In this next article, we look at creating balanced dimensions on demand.
2025-07-16
806 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
2,160 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,332 reads
Learn how you can handle dimensional modeling in a data warehouse when your data uses different categorization for ages.
2024-01-12
3,103 reads
By James Serra
(This is the second post in a three-part series on how AI is changing...
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
Comments posted to this topic are about the item Pay for Performance, which is...
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers