A Data Hub

The idea of a data hub in your company is interesting to Steve Jones. He talks about this concept, and how it might help you increase data quality, and perhaps get closed to a single view of the truth.

Excluding Schemas in SQL Compare

I saw this question posted the other day and thought it was a great idea.

I haven’t been a big...

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.