You may have checked on this but I'll put it out there just in case: When you modify a DTS package, you need to becareful that the GUID created by...

This is a fun topic to talk about but I'd have to say I feel removed from the love or hate. Like any tool or any product from a company,...

I've found UNIONs particularly useful in views developed for Crystal Reports when summarizing data that I couldn't figure out an easy or correct way to do the JOINs. You can't...

I'm not sure if you have to do this to lots of different tables but one work around would be to look into an equivalent to MS SQL's Identity property...

In addition to the naming standards does anyone use or attempt to enforce descriptions of the objects in the meta-data? For example, when creating a database diagram, viewing properties of...