The Data Model Matters
Is a data model important in modern software? Steve thinks it is and gives a few reasons why we might want to spend a little time on ensuring we have good models as we build software.
2026-06-05
160 reads
Database modelling
Is Data Modeling Common?
Today Steve tasks data modeling and wonders how many people still build and maintain models.
2025-11-24
151 reads
Being Mindful of Design Time
Do you take the time to model and design your database? Steve thinks this is important, even while trying to make changes quicker to adapt to changing requirements.
2025-11-14
144 reads
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
2,118 reads
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
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
2,272 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
3,018 reads
Having Data Modeling Standards
Today Steve talks about data modeling and how standards can transfer knowledge between developers.
2023-11-22
497 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
186 reads
2020-09-15
200 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
BCA KCU MENARA BIDAKARA Telp:0821-8200-203
Telp/WA 62 821-8200-203 Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt. 1,...
BCA KCU KEBAYORAN BARU Telp:0821-8200-233
Telp/WA 62 821-8200-233 Jl. Melawai Raya No.Blok B, RT.7/RW.5, Kramat Pela, Kec. Kby. Baru,...
BCA KCU PONDOK INDAH Telp:0821-8200-174
Telp/WA 62 821-8200-174 Wisma BCA Pd. Indah, Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers