Various Links-August 25, 2012

Great story about a client who didn’t under the different between Skype and Sharepoint – while doing a Sharepoint initiative! It’s...

Digging deeper into SQL Server

I’m nowhere near where I needed to be. I am not digging enough. I’m not learning enough. Learning opportunities are...

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

Mentoring

I’m putting my money where my mouth is, with respect to my last blog post.  I am officially a mentor...

Government and Transparency

I ran across this report that talks about the effectiveness of transparency requirements put in place around the Recovery Act...

Book Review: Troubleshooting SQL Server A Guide for the Accidental DBA

Over the past few years, Adam and I have won several books at the local MadPASS chapter meetings.  I’ve intended...

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

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

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