Learn tSQLt and Unit Testing in Philadelphia

SQL Saturday #390 is in Philadelphia on June 6, 2015. This is my second time attending the event, and not...

Quick Installs with Chocolatey–Screen Capture

I have been looking for a new screen capture tool. I used to use Snagit, but it felt too heavyweight...

Searching for Plans

Would you want a query optimizer that searches for the best plan for your code? Steve Jones thinks this might not be a bad idea.

LEAD parameters

Getting Database Properties – DatabasePropertyEx()

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Opening Up Data

Tim O'Reilly, head of O'Reilly publishing, has been an advocate of better date movement in the world. Steve Jones has a few comments on an interview he gave earlier this year.

T-SQL Tuesday #66 – Monitoring SQL Server

This is a T-SQL Tuesday that not only makes me smile, but makes my boss happy. In fact, I’m sure...

Ragged Right

The Service Pack Fiasco

The recent SQL Server 2014 Service Pack fiasco wasn't the first, but hopefully it won't be the last.

A Week to SQL Saturday #393 – Redmond

Only my second SQL Saturday of the year (wow), but SQL Saturday #393 is next week in Redmond, WA. This...