Tag Archives: database design

T-SQL Tuesday #51 – Place Your Bets

Posted on February 11, 2014 by way0utwest

It’s T-SQL Tuesday time again and Jason Brimhall is hosting this month’s event. He used to live in Las Vegas, and with that theme in mind, he calls for you to Place Your Bets.  That’s a time when someone has … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment

Is Your Data Relational?

Posted on December 2, 2013 by way0utwest

When should you use MongoDB? I’ve asked that question a few times, and I haven’t gotten a good answer I understand. I’ve read about a few of the NoSQL, document databases, and I think they do have a place in … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Is Your Data Relational?

Always Abstract

Posted on August 21, 2013 by way0utwest

The way we build databases and design security is rarely done ideally. It doesn’t matter what your Utopian design is for schemas and objects; most of us make compromise as we deal with the pressures and diverse requirements thrust upon us in … Continue reading →

Posted in Editorial | Tagged | 1 Comment

The Identity Debate

Posted on November 21, 2012 by way0utwest

This editorial was originally published on Mar 5, 2008. It is being re-run as Steve is on vacation. The Identity property might be one of the most controversial constructs in SQL Server, or at least right up there with the … Continue reading →

Posted in Editorial | Tagged , | 6 Comments