Removing a DDL Trigger

In a recent post I talked about how to create a DDL trigger. You’d think to drop that trigger, I’d...

Stupid Interviewer Tricks

Today's editorial was originally published on Feb 7, 2008. It is being re-published as Steve is on vacation.
What do you do when the interviewer is obviously wrong? Steve Jones offers a perspective.

Identity Insert and Table Variables – CONNECT issue

I was running some code the other day and was surprised by the result.
DECLARE @tmp TABLE (myID INT IDENTITY,MyChar VARCHAR(200))

INSERT...

Who’s Responsible

This is really scary. Someone being sued for downloading a porn movie illegally. I have nothing against porn, and I...

No Limits

There are some very interesting projects being performed with cloud services. Steve Jones talks about a few and the new computing without limits claim from Google.

Forty Five Minutes

Excellent: Dilbert on data analysts
The best part is the last quote: I like how you punctuate your ignorance with certainty.

Filed...

Out of the Frying Pan Into the Fire

Today Steve Jones talks about the accidental DBA and how they can find themselves in a position where they are responsible, but not well trained. In those cases, it's up to the individual to learn, but also the manager to ensure it gets done.

Password Resets

I read this piece from Troy Hunt, which is a long look at the password reset process for a web...

The DBA Database

One very handy item Steve Jones found as a DBA was a DBA only database on each instance. Today he asks you if you have one and if not, why not. There are good reasons to have one, and security is usually not a problem.

#GetHawt – The Summer 2012 Edition

Jen McCown started a #GetHawt set of posts last year and I think it went well. It must have, so...