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

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

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