Tag Archives: database design

The Lost Time

Posted on January 22, 2019 by

Last year when Daylight Savings Time moved clocks back, I was wondering how the time change might affect different devices and situations in the world. One area that I wondered about was medicate and health care devices. While I’m sure … Continue reading →

Posted in Editorial | Tagged | Leave a comment

Ensuring Designs have Flexibility

Posted on January 17, 2019 by

One of the biggest complaints from developers about RDBMSs is that they are inflexible and hard to change. This has led to many developers in the past using existing fields for a variety of purposes, sometimes putting data from multiple … Continue reading →

Posted in Editorial | Tagged , | Leave a comment

Fun with Dates and Times

Posted on January 16, 2019 by

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 , | Leave a comment

Understanding a Database

Posted on November 30, 2018 by

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