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,958 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,544 reads
Having Data Modeling Standards
Today Steve talks about data modeling and how standards can transfer knowledge between developers.
2023-11-22
406 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
167 reads
2020-09-15
178 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,380 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
T-SQL Tuesday #184–Mentoring
By Steve Jones
This month’s T-SQL Tuesday blog party is hosted by Deborah Melkin, and it’s a...
T-SQL Tuesday 184 - Mentorship
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
March 2025 SQL Challenge: Test Your Skills with Advanced SQL Scenarios
If you’re an experienced SQL user eager to sharpen your expertise with real-world challenges,...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
SSIS Execute Process Task forfiles not working
I'm trying to use forfiles in an Execute Process Task in my SSIS package...
Display Data
Hi I want below data to appear like below using query CREATE TABLE [dbo].[Test](...
Question of the Day
Partial Backups II
What is a partial backup for a read-write database?
See possible answers