Startup Jobs

Are there things you need to make sure are running when your SQL Agent starts? Did you know that you...

Wiggle Room

Consultants sometimes don't live up to their hype. To what extent should we expect them to know exactly what they're doing? This editorial was originally published on Nov 9, 2007. It is being republished as Steve is on vacation.

Creating a DDL Trigger

One of the most amazing features to an old SQL Server 4.2 guy was the addition of DDL triggers to...

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.