Collation: Correction -> Expression, Column, Database

I had a recent run in with collation problems and it got me started reading about them. As I read...

First Birthday to My Blog

Today is the First year anniversary of my blog. After thinking a lot and going through many un-imaginable resource available over...

First Birthday to My Blog

Today is the First year anniversary of my blog. After thinking a lot and going through many un-imaginable resource available over...

Heartbleed bug: immediate security threat for both IT, and consumer sites and services

“An encryption flaw called the Heartbleed bug is already being called one of the biggest security threats the Internet has...

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