Help! I'm stuck in Single User Mode and can't get out!

So, here’s a silly little take on a serious end-user issue where no-one could access the production database.

Got a call...

I’m a Traveling Man

We are coming into quite a busy time for my speaking schedule. I’m hitting the road. It does one thing...

Rolling back transactions with cursors and local variables.

I’ve been doing some work on a credit card payment system lately. Obviously this needs to be robust and consistent...

Smart Moves with SQL Server VMs – Data Movement

Today marks another installment in my ‘Smart Moves with SQL Server VMs’ blog post series. Today we are going to...

Webcast Follow-Up: Introduction to Columnstore Indexes

Similar to yesterday’s post, I have a follow-up for another Pragmatic WorksTraining on the T’s session that I delivered last month....

Analyzing CXPACKET waits

One of the most common wait types you will see on a SQL Server is the CXPACKET wait type.
This...

Dedicated Administrator Connection

By David Postlethwaite

At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...

this isn’t thunderdome

When I received my first MVP award for SQL Server it was fairly abstract to me until I went to...

Vote for me at SQLBits

SQL Bits XII is coming this July to Telford in the UK and voting is underway for sessions. I’ve submitted...

Webcast Follow-Up: Introduction to Clustered Indexes and Heaps

Last month, I presented a session for Pragmatic WorksTraining on the T’s titled Introduction to Clustered Indexes and Heaps.  I’d meant to...