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 ,

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 ,