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

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

Alter Table Not Permitted

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

Dedicated Administrator Connection

By David Postlethwaite

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

Colorado SQL Events for April 2014

SQL Meetings are training events for SQL Server professionals and those wanting to learn about SQL Server. Please note that...

T-SQL Tuesday #53 – Work Hard, Play Hard, Joke Hard

It is April and April Fools has only just begun.  Well, or so Matt Velic (blog | twitter) would have us believe. Matt decided that this month for TSQL...

T-SQL Tuesday #53 – Work Hard, Play Hard, Joke Hard

It is April and April Fools has only just begun.  Well, or so Matt Velic (blog | twitter) would have us...