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

SQL Server 2005 Diagnostic Information Queries (August 2012)

Here is the August 2012 version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements....

Tips For Minimizing Deadlocks in SQL Server

Database servers are configured in such a way that they can service multiple requests from multiple users. Obviously this increases...

Transparent Data Encryption (TDE) with Database Mirroring

Database security is essential for the organisations working in healthcare and financial sector because the databases in such organisations contain...

24 Hours of PASS, Fall 2012

It’s time to get your learn on again. The schedule for the Fall 24 Hours of PASS is up and...

I Think I Need A Writing Table

I’m writing this Friday evening in Cleveland at the hotel, relaxing after the speaker dinner and getting ready for SQLSaturday...