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
146 reads
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
146 reads
Steve had to deal with a customer that changed data types in columns often. Is that something you experience?
2026-03-18
114 reads
Today Steve asks which data model issues are most annoying to you.
2025-02-28
142 reads
Data modeling can be challenging for many reasons. Steve talks about the choices you make in how you store data should be a part of that.
2023-04-19
300 reads
Today Steve looks at an article the migrates a relational model to CosmosDB.
2020-07-10
707 reads
2020-03-10
345 reads
A data model is far more powerful than simply a set of build instructions for DBAs. It can be used to shape business thought and actions for the benefit of all.
2017-02-14
2,033 reads
2015-05-05
1,885 reads
EAV models have their uses but the costs are often hidden and if not hidden, more than anticipated.
2013-01-21
8,596 reads
Changing the structure of a very large table doesn't need to require a maintenance window.
2012-10-05 (first published: 2011-04-26)
22,250 reads
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Comments posted to this topic are about the item Managing Incidents and Fighting Fires
Comments posted to this topic are about the item Backing Up a DMK
Comments posted to this topic are about the item The Quiet Part
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers