Tag Archives: database design

Making Complex Table Changes

Tables are a problem for anyone trying to grow and modify software. Views, stored procedures, functions, all of these objects are easy to modify, but when we start to deal with actual data, where we need to maintain state, we … Continue reading

Posted in Editorial | Tagged | Leave a comment

Email or Username

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?

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

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

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

Relational By Default

I’ve read a few pieces from Vladimir Khorikov and I tend to like the thoughtful way in which he approaches building software. When I saw a link to his SQL v NoSQL databases, I was intrigued to see what his thoughts would … Continue reading

Posted in Editorial | Tagged ,

Poor Data Modeling – T-SQL Tuesday #72

This month Mickey Stuewe hosts the T-SQL Tuesday and she has a great topic. Data Modeling is something few people seem to do, especially developers, and it often can go wrong. That’s the topic, and I have a short story. … Continue reading

Posted in Blog | Tagged , ,

Positive or Negative

While watching a presentation recently on a SQL Server topic, I was surprised by a design technique that the speaker used. I hadn’t ever thought of the issue, but it caught my eye and made me rethink the way I … Continue reading

Posted in Editorial | Tagged ,

Logging Tables

I was chatting in one of our DLM webinars and someone asked a question about logging data. I mentioned a few things, but this individual followed up and wanted more information. Specifically, how do you build a logging table? It’s an open … Continue reading

Posted in Editorial | Tagged

ER Modeling

I saw someone recently note that an Entity-Relationship model is important for your database development project. That UML is important, and the model should be actively maintained. I agree. However, I’ve usually not seen this done. Typically when I’ve seen … Continue reading

Posted in Editorial | Tagged ,