Synonyms can be used to simplify code when doing cross-database work. They are especially helpful for standardizing code when the external database name varies from environment to environment. ...

I have to work on lots of projects, doing lots of correspondence, some SQL, VB.NET, tracking down problems, reviewing other people's work, and determining the set of tools (internal and...

Unfortunately, some companies respond only when the community uproar is so strong they fear its effect on their reputation and sales. Insults (childish or otherwise) are not an essential...

Looks nice, Please restore featured content; you're more likely to get article views if we don't have to scroll to see what they are. Making better use of...

msaleem-583379 has a pretty good function. I modified it to return varchar instead of int values. As such, it needed a couple of improvements:

1. Empty strings or spaces...

Roasting marshmallows over the backyard "camp fire". Scrounging Half Price Books or yard sales for books. A walk to the ice cream store.

EXCEPT and INTERSECT are especially useful for comparing multiple columns of data where (a) there is no primary key or (b) having the same primary key does not guarantee that...