Tag Archives: database design

Email or Username

Posted on June 29, 2016 by way0utwest

Quite a few of us will work with application databases where we need to identify a particular user for working with the various parts of the application. I’m not talking about the authentication and verification of identity, but just having … Continue reading →

Posted in Editorial | Tagged | 2 Comments

Have You Designed a Database from Scratch?

Posted on June 24, 2016 by way0utwest

One of the things that I try to regularly promote is the #SQLNewBlogger project from Ed Leighton-Dick (and #SQLNewBlogger hashtag on Twitter). In keep a column open scanning for the tag and try to respond to those that post. I … Continue reading →

Posted in Editorial | Tagged , | 2 Comments

The Clustered Index is not the Primary Key

Posted on May 24, 2016 by way0utwest

I was reading through a list of links for Database Weekly and ran across this script from Pinal Dave, looking for tables where the clustered index isn’t the PK. It struck me that this is one of those facts I … Continue reading →

Posted in Editorial | Tagged , | 1 Comment

Naming Is Hard

Posted on April 7, 2016 by way0utwest

I ran across Aaron Bertrand’s naming post recently, which I liked overall. Your team needs to agree how things are named, and be consistent, but I agree that some of the rules I’ve seen put down by people aren’t practical. However I also … Continue reading →

Posted in Editorial | Tagged | 1 Comment