I see your point about goals and don't really disagree, but I do see quite a few people set unrealistic goals and wind up entirely unhappy. For this article if...

Thanks Zubeyir! Though maybe I should post it too, might get more interesting posts that way

I tend to overcomment. I agree with the philosphy of documenting why, but in practice it's often helpful to have a short comment that describes what you're doing because we...

I'll try to make this my last post, since I've already admitted that I didnt do as good as job as I'd wished making my point - but I will...

SMDL files the xml source files for a model.

Does the model appear to be intact, you can view it? How about just copying the file to a new project and...

Good follow up. Often happens when someone tried to make changes without redoing the snapshot. Nothing wrong with that, but easy to miss something when doing it.

Could go either way. Triggers are great for making sure no one does an end run on your data process, but if its just something being done from code I'd...

I'd like to think Im not advocating in favor of cursors, or even a leaning towards them. I agree that we should try to write clean scalable code up front...

I grew up with hungarian naming of variables and I still tend to do it!

One of the questions I like to pose for candidates goes something like this:

You've just taken...

Dont think I've ever seen it not finish up a batch like that. When I can find some time I will try to duplicate just out of curiousity! It sounds...

Sorta, maybe wasnt the best question either. Are there things you're able to change this way that you can't using SMO or DMO?

Interesting stuff. Couple questions though. Can you post some examples of why you've needed registry access from within SQL? I'm not a PERL user, so is there any advantage to...

Jeff, not sure if you're disagreeing with the intent of the article or just enjoying some humor?

Lynn, thats a great comment about changing jobs!

I use status fields typed as bit or tinyint quite frequently with good results. I like the space savings of the bit and if its the right data type fo...