Tag Archives: database design

Fun with Dates and Times

Posted on January 16, 2019 by way0utwest

The other day I got a Github issue that asked if we here at SQLServerCentral should set our dates as YYYYMMDD in the new SQLServerCentral site. The issue noted that there were some inconsistent dates. Article dates are in a similar format, … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Fun with Dates and Times

Understanding a Database

Posted on November 30, 2018 by way0utwest

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

Posted on October 15, 2018 by way0utwest

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 , | Comments Off on Modeling and Design Are More Important in DevOps

Give Up on Natural Primary Keys

Posted on October 1, 2018 by way0utwest

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