Posted in data modeling, SQL Server

How I Really Feel about Surrogate Primary Keys

When someone goes on a rant about something they truly feel strongly about – good or bad, my typical joking response is “You’re being a little wishy-washy about this. Tell me how you really feel.” I recently had a conversation with co-workers about surrogate primary keys and realized I need to use that line on myself.

So let me tell you how I really feel about surrogate primary keys. Where’s my soapbox?

soapbox

Continue reading “How I Really Feel about Surrogate Primary Keys”

Posted in SQL Saturday

SQL Saturday Boston #797 Reflections

Now that SQL Saturday Boston is over (along with the rest of my insane September), I’m finally able to reflect on the whole event.

my speaker badge
My badge and its ribbons

My first SQL Saturday Boston was as an attendee when it was held out at one of the colleges in Wellesley, MA (either Wellesley College or Regis College – I don’t remember which one.) I missed one or two of the SQL Saturdays after that because I was late registering and SQL Saturday Boston fills up quickly. I managed to volunteer at SQL Saturday #500 helping in the morning at the speaker and sponsor check-in table. I had spoken at my first SQL Saturday before the SQL Saturday Boston BI 2017 but I didn’t submit my T-SQL 101 session because it was a BI Edition SQL Saturday and I didn’t think it met the criteria for a BI session.

This year, I had the honor to be on the organizing committee. It was an interesting experience to see the same event from so many different perspectives.

Continue reading “SQL Saturday Boston #797 Reflections”