We told our main vendor that sa was no longer an option. Period. They complained, but finally changed their install and update routines to work just fine with dbo equivalence...

I used to give blood regularly, but after living in Equatorial Africa for 3 years in the early 90's, I am ineligible. I have never had a good explanation as...

From a conversation yesterday about one of our vendor apps that moves way too much data across the network "That app isn't a fat client, it's a morbidly obese client"

Don't need pork chop grease, just shine a sure fire flashlight, or other bright light source, at the camera, and all that will appear is a very bright light overwhelming...

For SQL2000, looking at the status column in sysobjects, it appears (no guarantee) that the 12th bit from the right is set when a trigger is disabled. This means masking...

Would replacing the UDF's with tables containing the necessary data improve performance? I am thinking of the UDF that returns a 1 if the transaction is a peak time transaction....

I would probably be back to being an accountant, although I can't imagine how much work that would be without databases. Otherwise, I would want to retire and learn how...

A nonelegant way to do this is to use a series of replace statements that make a set of 4 spaces 1 space, then 3 spaces 1 space, then 2...

PostXript (9/1/2009)

---

I totally agree, this was a few years back. In my current environment it's no longer possible for me to make these kind of mistakes.

Ross McMicken (9/1/2009)

---

PostXript (9/1/2009)

---

Oops... that...

Sounds like the HR guy would have been right at home in the environment portrayed in the series Mad Men.

That's a major reason we don't allow scripts to be run against production unless...

We have to get an exception approved to use a SQL login, and those are only granted for vendor proivded applications. In house developed apps must use windows authentication. I...

I'm somewhat skeptical that birth date, zip code, and gender are enough to uniquely identify 87% of Americans. That may be true in more rural areas, but not in cities,...

For ID's that are powerful, like admin's, and are authenticated by Active Directory, we use a smart card, or require that the ID be checked out from an application that...

Andrew (8/26/2009)

---

Hopefully DBAs would be much more careful, but as I read this I was reminded of all the jobs I've had where a supervisor had to enter verification (via...