My story - I am getting ready to retire this year, after 40 years in IT, 25 of that as a DBA. I have been 'on call' for 40 years!...

Schemas can be a great tool as everyone has previously stated. But for the love of all humanity, do not use schemas such as 'DEV.', 'QA', and 'PROD' to identify...

Bane of my current job: not only are dev, test\QA and production database names different, the schemas within each are different as well. So inside the dev database I have...

Sorry - Luis - I was responding to your tag line, and not your comment.

Still....

This is code in a purchased app. I am not comfortable changing it. Just trying to...

Wow. That's just rude and unhelpful. You know nothing about me, my level of experience, my situation, or what I have done prior to getting to this point. I totally...