A DBA manager doesn't need immense technical knowledge to be effective - that's what the DBA's are for. The manger's role is to make sure the way is clear for...

You probably need to search for rows that contain the unicode codes for Arabic. Search Books Online for the functions related to Unicode string handling.

I've had decent results using MS Access to compare data from different sources. Link tables to each of the databases, then use Access queries to do the comparisons. As long...

Jeff, I had wondered that as well. If the new IP's are stored in a table with the old IP's, it would seem simpler to just do an update statement...

Why would a developer have the ability to drop a table in a production database? As others have mentioned, proper grants of authority are the appropriate way to control access...

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.