Presenting at the kickoff Lynchburg Va SQL User Group meeting

There’s a new SQL Server user group starting up over in Lynchburg, VA. It’s first meeting is February 27, 2014...

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

Transaction Isolation Levels

An examination into how the various transaction isolation levels affect locking (and blocking)

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

Creating templates for use in BIDS (SQL Spackle)

Learn how to create and use templates in BIDS in this short SQL Spackle article.

Locking, Blocking and Deadlocking

Introduction into Locking, Blocking and Deadlocks in SQL Server, and why SQL Server uses these actions.