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...

Tricky, I failed to realize the synonym would be pointing to the view instead of the table that had been dropped.

Great question!

GilaMonster (6/19/2014)

---

On dev servers, I'm very happy to give developers db_owner of the DB they're working in, alter...

Great scripts, thanks a lot! I've added them to my personal library, with you as the source.

Great article, very useful for getting started with MDX.

Fun questions, thanks!

Be sure to spend at least one day doing nothing but fishing!

In that case, I'd temporarily give the login the access it needs to connect, then run a sql trace on the login and see everything it's touching. There must...