Tag Archives: database design

Understanding a Database

I ran across a post that asked a good question, one which I want to ask you today: how do you learn about a database? I’ve run into quite a few databases in my career. Some were third party systems, like Dynamics and JD … Continue reading

Posted in Editorial | Tagged , | 2 Comments

Modeling and Design Are More Important in DevOps

I’ve run across a few customers that are adopting DevOps processes for the database. This makes sense as I deal with Redgate Customers, many of whom are doing this. As they adopt a Compliant Database DevOps process, it seems often … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Give Up on Natural Primary Keys

There is plenty of debate over how to design your database. At SQLServerCentral we have a Stairway Series as well as a few articles that cover design topics. I think it’s important for anyone that builds tables to spend some time learning what others … Continue reading

Posted in Editorial | Tagged | 3 Comments

The Master of the Schema

“The database … should be the master of the schema”. It’s not often I see an application developer talk about the importance of the database, or at least that the database (and data) are very important to the success of … Continue reading

Posted in Editorial | Tagged ,

Who Likes NULL?

The title says it all: who Likes NULL values in their tables? I have tended to allow NULLs in quite a few places in my design, often because I view the world as messy and incomplete. I also find that … Continue reading

Posted in Editorial | Tagged | 2 Comments

Where’s the schema?

Across the last few years, I’ve read many articles and listened to quite a few talks that discuss the advantages of NoSQL databases. I’ll admit that I’m often skeptical of the advantages of other datastores overcoming the disadvantages with a … Continue reading

Posted in Editorial | Tagged

Singular or Plural

There are all sorts of interesting debates that developers will have about programming. One of those I’ve written about in the past is Spaces v Tabs. There’s a lot of discussion about that one, and certainly no share of strong opinions. … Continue reading

Posted in Editorial | Tagged ,

The Relational Database is the Default

It seems that I regularly meet people in the SQL community that are asked about moving their datastore to a NoSQL type of database. In a mature system, that might be a conversation worth having, especially if there are issues … Continue reading

Posted in Editorial | Tagged ,

A Database Design Test

I was watching a presentation recently on database design and the speaker talked about how he hires developers. These are full stack developers, for whom the database is a portion of their responsibility. One of the tasks he gives them … Continue reading

Posted in Editorial | Tagged , | 6 Comments

Null Defaults

One of the things that becomes important in a distributed, team environment is the interface that you present to other systems. In a Devops environment, we really need to have an API for every system, including the database. This means a … Continue reading

Posted in Editorial | Tagged | 1 Comment