Department of Redundancy Department
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
Database modelling
Dimensional Modeling Case Study Part 2 - Days Dimension
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
1,923 reads
Dimensional Modelling Case Study Part 1 - Age Group
Learn how you can handle dimensional modeling in a data warehouse when your data uses different categorization for ages.
2024-01-12
2,497 reads
Having Data Modeling Standards
Today Steve talks about data modeling and how standards can transfer knowledge between developers.
2023-11-22
400 reads
Cone of Uncertainty
Our design and modeling is often done with some level of uncertainty. Steve has a few guidelines today.
2022-10-26
166 reads
2020-09-15
177 reads
Database Modeling - Relationships
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,309 reads
Five Online Database Modelling Services
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
Blogs
Capturing Ideas for Blogs
By Steve Jones
As we close out the year, I decided to drop this post here and...
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Forums
Problem installing SQL Server 2022
Hello, I currently have an instance of SQL Server 2019 Developer installed on my...
How to Attach and Detach Databases in SQL Server
Comments posted to this topic are about the item How to Attach and Detach...
What is Terraform?
Comments posted to this topic are about the item What is Terraform?
Question of the Day
What is Terraform?
What is Terraform (from Hashicorp) used for in technology?
See possible answers