I heard through the grapevine that for some of those big retailers that got hacked, it was actually third party vendors that created the security loophole. Either way as...

Markus (9/26/2014)

---

Pricing... yea... Microsoft is starting to think they are Oracle.... soon they will be pricing themselves out of the small applications space. There are starting to be a...

Primarily it's a cost factor for us. 2008 R2 fills all our needs, so we'd see very little ROI with an upgrade to a newer version.

Nice question, I learned something. I assumed the ISNULL function would make it non-Sargable.

1% have gotten it correct? Clearly too complex for QotD. It would have been helpful know the number of correct answers to choose.

Gary Varga (8/1/2014)

---

This editorial highlights a key reason why I believe in using stored procedures. All I want from a stored procedure is to answer some question (no, not query)...

Would there be any security concerns with allowing remote admin connections? Seems like it would be ok as long as you have your sysadmin logins controlled appropriately.

That story about David Helkowski was pretty crazy. It reminds me of the Seinfeld episode where Jerry's mechanic goes nuts because Jerry isn't babying his car enough, so the...

Fun article, this takes me back to my college days studying math and economics. I really wish I knew everything about SQL Server then that I do now -...

Wife and I had our third baby (that's relaxing, right?), and got in a good amount of fishing. Our busy season for sales here at work is fall through...

I completely agree with this. A...

Easy one, thanks. I needed an easy one after getting the last four in a row wrong.

I was also at that SQL Saturday and was really excited to see "the pros" in person. Hearing Ozar, Fritchey, and Machanic (and all the other great teachers) teach...

A couple thoughts came to me as I read the editorial:

1. In at least one case, when designing views, I think creating using tsql is so much easier than using...

sestell1 (6/24/2014)

---

You can save your custom colors with specific connections if you use 'registered' servers in SSMS.

I like to set all my production server connections to red, to cut down...