T-SQL: Performance of SQL Agent Duration Calculations

In my article published yesterday on using Powershell for SQL Durations (Working with SQL Agent Durations), I proposed using a...

Amazing Margaritas in Austin – SQL in the City US Tour

The last time I was in Austin was last year, for a weekend trip with my wife to see Stevie...

Another Execution Plan… In the Cloud!

A couple of weeks ago I posted about how different execution plans look when using the Azure Management Portal. I...

Don't Disconnect Your Common Sense

This falls in line with a previous post about common sense in IT.
I was having lunch with a co-worker,...

Intel Haswell-EP Processor Rumors

Intel releases a new processor microarchitecture every two years, which is called a Tock release. One year later, they take...

Learning about Driving with Big Data

This is nice, a year long safety pilot from the University of Michigan. Quite extensive, using 3,000 cars to gather...

Man Vs Machine

Man Vs Machine
Man Vs Machine

Are you a fan of the television show Man Vs Food starring foodie Adam Richman? In...

Microsoft Store vs Apple Store

Yesterday I went to the new Microsoft store at Florida Mall, mostly out of curiosity and something to do at...

Rant: Applying Common Sense in IT

I was watching a training video last night and the instructor made the statement we hear all the time:
"Test this...

Script to find orphaned/unreachable job steps within your SQL jobs

SQL jobs are great as the SQL agent job engine allows for very granular control over jobs that are created...