Trying to get that structure normalized as much as possible (Having two or more child tables mutually exclusive linked on the same parent table) while preserving a "DRY" column approach...

Is my description unclear? Is there something missing?

Renaming badly named objects in the first place, outside the standard naming convention are done to support generic support scripts when things goes bad (because it's not if it will...

I agree with you on a theoretical point on view. But I feel, the reality is, unfortunately, different.

without recriminations

Most of time this does not occurs, but it's not always the...

IMHO I follows theses:

1- The DBA job was posted for a business reason. What it is? What management worries the most right now from their own eyes.

2- Next depending of...

To my eyes (and it's just my opinion) it's a lack of willingness to understand what's going on under the hood. (and this apply for everything in this world not...

Steve, if you want to get more time for something else (or just getting plain lazy), automate stuff 😀

To my eyes it's just another tool which I included in my tool box.

When designing stuff, I have the flexibility to have another option at hand (CLR)

If it suits a...

I was excited at first to read what others used (to learn new trick) but I feel we mainly all rely on the same ways to debug.

When I had the...

I had that in mind while reading this morning article:

Not exactly right on the article but I guess you understand the point, whatever the situation.

(Image taken from :

However I decided this year that I should buckle down and get this done. I'm proud to say that I spent about an hour working on the task and got...

To my eyes it's an old debate yet nothing has changed much since.

It often gets down to "it depends".

1- Blaming a company for an individual act is no good

2- The...

To my eyes:

1- Willingness to learn

2- Open mind to a new way of coding (a programmer think procedurally instead of sets)

3- Understand that there's no "one size" fit all solution

If...

Oh Yeah! I got the 700th entry!

Not a breaking barrier in the thousands but still a step ahead!

You beat me to it Sean Pearce!

I was also in the process of writing a script to end the discussion.

In case of doubt, let SQL do the talking!