I can tell you what NOT to do: Don't be tempted to go down the OPENROWSET wormhole.

I spent hours trying to figure out why stored procedures that use OPENROWSET...

I don't think I'd be as quick to dismiss the restaurant business or landscaping as simple. I probably couldln't remember the orders of all the people at a table...

I think the best perk management could give me and my fellow propeller-heads would be a small "skunk works" R&D project to develop something really leading edge (on the understanding...

I'm reminded (and I'm dating myself here) of comedian Lily Tomlin's character Geraldine the Telephone Operator and her famous line "We're the Phone Company, sir. We don't have to...

Developers become recalcitrant only because experience has shown them that

(1) As soon as they develop a quick and dirty Windows app to run on a handful of workstations, management...

By all means, let's rebrand our weaknesses as strengths. Personally I aspire one day to be my company's CIS - Chief Idiot Savant. 😀

Robb

The issue is not so much the specific vulnerability as the fact that some developer at Microsoft didn't think it was a problem to store passwords in memory as plaintext....

Take toasters, for example. You just can't buy a good toaster any more (where 'good' is defined as one that evenly browns bread and lasts more than a couple...

Gotta watch out for those "rouge" administrators, after all there's a "rouge" under every bed!

I think you meant "rogue". 😛

I believe subscriptions run under the user id of the person who creates them, so you may have to recreate the subscriptions if the terminated person used his/her own id...

The Cloud is a lovely analogy, but that's all it is - an analogy. You're still forced to deal with realities like 'What are the privacy laws in the...

If the iif test is true, you're returning the sum over ALL rows. What I think you meant to do was to sum only those records which pass the...

Are you hiring, Steve? 😀

Self-congratulatory bollocks.

Pick almost any career (architects, police, trades, heck even pot growers) and the people doing it will claim to be stable, family-oriented, hard-working, community-minded.

Robb

I'm afraid I have to disagree. As a developer, I've seen too many source code files filled with revision history cruft to the point that a twenty line procedure...