Data Modeling Information
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
269 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
269 reads
Today Steve looks at an article the migrates a relational model to CosmosDB.
2020-07-10
664 reads
2020-03-10
321 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
1,968 reads
2015-05-05
1,861 reads
EAV models have their uses but the costs are often hidden and if not hidden, more than anticipated.
2013-01-21
8,063 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)
21,847 reads
Hierarchical structures have an inherent ability for significant data value increases beyond the data collected. This will be shown to exist in hierarchical structures and even more powerfully in their natural hierarchical processing capabilities. These will demonstrate flexible and efficient ways to increase data value automatically and will be discussed in this article. SQL will be used to perform a wide range of hierarchical processing operations that easily demonstrate these increasing data value capabilities.
2011-03-23
3,291 reads
The capability of extending the limits of combining multiple node hierarchical structures has not been fully explored. Michael M. David presents a solution to advanced structure combining that is simple to use, generic and freely extends the way hierarchical structures can be semantically combined to produce advanced new hierarchical data structure mashups that dynamically increase the value of the data.
2010-07-16
3,196 reads
Data quality is important in a database, but so many people fail to implement good referential integrity. New author Marvin Elder brings us an article that looks at surrogate keys for ensuring data quality.
2009-09-08
7,640 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Testing with AG on Linux with Cluster=NONE. it was all going ok and as...
Hi, I have two tables: one for headers with 9 fields and another for...
We're trying to understand how quick new versions of SQL server can be. Obviously...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers