Awareness

This week Steve Jones looks back at the T-SQL Tuesday blog part and its theme of monitoing.

Testing Simple Calculations and UDFs with tSQLt

This article will give you a basic look at how you can test your user defined functions with the tSQLt framework.

Why Test Table MetaData Tests with tSQLt

I wrote at SQLServerCentral about using tSQLt to check table metadata. In essence we are testing the API of our...

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