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
153 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
153 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
144 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
304 reads
Today Steve looks at an article the migrates a relational model to CosmosDB.
2020-07-10
709 reads
2020-03-10
348 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,036 reads
2015-05-05
1,891 reads
EAV models have their uses but the costs are often hidden and if not hidden, more than anticipated.
2013-01-21
8,604 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,259 reads
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Comments posted to this topic are about the item A Challenge of Our Knowledge
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Comments posted to this topic are about the item Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers