So, to sum up the article... it depends.

That should be answer that DBA's use in most situations.

The thing is, there really are solutions (your example being one) where dynamic SQL...

Well, in answer to the question, I'm going to fall back on the DBA standard answer, it depends. What's your definition of a enterprise class tool? Last year when SQL...

Excellent article. Nice & thoughtful. I'm definately adding it to my tool box.

A question about your process though. You went about isolating the database object that was giving you coniptions....

Science is self-correcting, eventually. It's cool.

As to the seven year old, have fun. I started talking about it with my two eight year olds which lead to some explorations, together,...

Maybe I'm wrong, but this simply sounds like an upgrade. That said, we're going through all kinds of issues with upgrades at my company. Emphasis for IT planning is in...

Oh come on man... It'd be race. Can you get back to your desk faster than I can revoke your privileges. Could be entertaining.

Hey John: Lighten up Frances. Last time...

Just a couple of points, I'm already working as a Database Developer. I spend 90% of my time worrying about structural design and database coding. Backups, security, system settings, etc.,...

We've got a few, but not a lot. 9 production servers, 2 staging servers, 3 qa servers, a training server, 3 testing servers (different than qa), and something like 6...

Nice editorial. It's just too accurate.

I've never seen an app ported from platform to platform without major rewrites. Those rewrites have occurred, not simply because of the platform shift,...

May as well flog this horse skeleton into dust....

"Good" & "Correct" in terms of data integrity within a relational database system are absolutely not in the eyes of the beholder....

A little late to the party I realize, but we're in a similar boat to everyone else. We don't have a driving business need to move to 2005. 2000 is...

My story was absolutely not funny at the time...

I was working for a dot com where the Harvard grad president had a "think outside the box" epiphany. This computer stuff,...

Great article. Thanks for all the work. While I was aware that avoiding implicit converts resulted in better query plans, I didn't know about the data precedence. That's a great...

All darn good reasons to switch to 2005, but none of them really offer actual productivity gains (maybe the templates, but that's pretty slight). Thanks for the feedback.

That's very much in keeping with my experiences and research, but I was hoping I'd missed something. I've got two reasons for switching over, one good, one not so. The...