Archive for January 2010

Goals for 2010

I’m a little late blogging about this but I have these goals in my mind for this year. Get more organised. I have days where I’m super productive, and others where I feel like a dog chasing his own tail. I’ve seen a few people recommend Getting things done by David Allen. So I’ve bought […]

The Sexiest DBA

Brent Ozar is the sexiest DBA when I’m not in my special pants!

Primary Keys do not always have to be ‘Id’!

We’ve all more than likely spotted tables in databases with no primary keys. But does a primary key always have to be defined something like… ?View Code TSQLALTER TABLE MyTable ADD Id INTEGER NOT NULL IDENTITY(1,1) PRIMARY KEY CLUSTERED; I think we have ORM to blame for this widespread practice of using auto-incrementing integers as […]