T-SQL Tuesday #51: Is this a bet worth making?

On the second Tuesday of each month, the SQL Server universe all comes together to blog about a topic. Known...

SQL Prompt – new features in version 6.x

I’ve been using SQL Prompt for years. In September 2013, version 6 was released (quickly followed by 6.1 in late...

Assumptions and clusters – the double whammy

I was recently investigating an issue that stemmed from a database being in the recovery_pending state. A quick investigation through...

TSQL Tuesday #50 – Automation – Verifying the Backup Chain

I was recently just letting my mind wander. As it’s prone to do, all sorts of things just entered into...

Interview Questions – what to ask the company interviewing you

Previously, I posted a list of interview questions that I ask job candidates. This post is about the questions that...

Are CHECKSUMs being performed with a Compressed Backup?

Now, why in the world would I be asking a question like this?

Well, in BOL (BACKUP) is this little blurb:
CHECKSUM

Specifies...

T-SQL Tuesday #48 – My take on the cloud

So here it is, the second Tuesday of the month. This means that it is time for our favorite Tuesday...

The Failed Job

I was looking into a failed job on a SQL Server 2008R2 instance. My first step was to check the...

Murder They Wrote

For those of you that know me, you know that I enjoy learning, and passing on what I have learned...

Retiring of the MCM Certifications, Part II

Image acquired from Twitter
In my recent blog post on “Retiring of the MCM Certifications”, there is a link to a...