Tag Archives: database design

The Lost Time

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

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

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

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