Sherpa of Data

Tag: Keys

  • Even More Fun with Database Keys

    —

    by

    Kevin
    in

    Over the last few posts, we’ve went over Primary Keys, Foreign Keys, Candidate Keys, and Alternate Keys. Most of y’all are probably thinking – that’s too many keys already! Why do we need even more keys? Well, that’s because we sometimes need different ways to describe what we’ve got going on. Of the four different…

  • More Fun with Database Keys

    —

    by

    Kevin
    in

    If you’ve been following along with some of our previous blog posts, you’ll know that we’ve discussed some of the more used keys when dealing with databases. Lest you forget, we talked about keys in these two blog posts: Primary Keys – Good and Bad Foreign Keys – Are they worth it? Now, we can…

  • Primary Keys – Good and Bad

    —

    by

    Kevin
    in ,

    When it comes down to primary keys, most of us that have been working with databases for a while have come across a few million different ones. Some work fairly well. Some just don’t work at all and should be banned from ever being used as a primary key again. First, let’s delve into what…