SPAM is a problem now, and it's not a simple one. I've filed a ticket to work with the third party on what is not catching more than it...

"Give 'em the razor; sell 'em the blades"

Thank all of you folks for the congrats and the well wishes.  I'm just one person, though.  This site wouldn't be worth a hill of beans without the rest of...

Wow!  Mr. R. Barry Young... source of the term "Pseudo Cursors" for me.  How the heck are ya,...

From the Article:

---

"I'd love to be able to insert data into a table, have it not available as a live value until committed on other nodes, and...

Something surprising shot people in the head on our AS400's prior to them upgrading to the new "Power Systems", also by IBM.  They lasted a really long time and, one...

Awesome.  Thank you for the comeback on your own post.  We may be going through something like what you did in the very near future and I've just book marked...

To add to what Brian said, I've been a Director of MIS, a Software Development manager, and a couple of other highfalutin sounding titles and I'm kinda good at SQL...

@jonfrisbee ,

I can't fault someone that took the time to write an article to help others.  Hat's off to you for that.  But have a look at the way Des...

All of those UNIONs are creating an insane query plan.

The following code will produce almost the same result, with a MUCH better query plan.

DECLARE @options int...

See...

With apologies to Calendar Table Lovers, I've grown to hate Calendar tables unless they're absolutely necessary (which is not the case here) because of their tendency to kill performance.  I'd...

Even I don't try to "split" address.  My recommendation would be for you to buy some C.A.S.S. Certification software.  You spend less money than you will trying to develop something...

About Fusion restaurants: it's pretty rare for them to do everything (or even most things) at a master chef level.

I've never worked with CosmosDB, so I don't speak from...

Knowledge of SQL is not enough to secure most DBA jobs. Established companies prefer to hire someone with a degree in a computer science field, experience and knowledge of...