Posted on January 13, 2010, 9:14 pm, by Rhys, under
DBA.
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 [...]
Posted on January 11, 2010, 10:12 pm, by Rhys, under
DBA.
Brent Ozar is the sexiest DBA when I’m not in my special pants!
Posted on January 3, 2010, 3:41 pm, by Rhys, under
Data,
DBA.
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 [...]