SQL in the City Goes Mobile

This week is the kickoff of the third year of SQL in the City from Red Gate. As we have...

Natural Born Killers (The series)

To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...

Pivoting weird data in SSIS – Sort of…

Sometimes we get data in some bad forms. For example look at the below table:

The names and the amounts are...

ORDER BY the numbers

Have you ever needed to order by a calculated column? You might have written it something like this:
SELECT LoginID, YEAR(HireDate)...

Sql Server 2014…….What!!!

Yes, its true. Microsoft vice president has announce  that new version of sql server 2014, will release on 2014… do...

PASS Data Architecture VC presents Steve Simon–Challenges Designing Finance Data Warehouse

Steve Simon will join us on Thursday June 20th at noon central to help us understand some challenges with designing...

Tracing Introduction

SQL Server tracing is essential for troubleshooting performance issues, yet it can put loads on your server that would cause...

Shifting of the Tides and my Career

Watching my career progression over the last year, an outside observer would think that I’m playing career path hop-scotch, or...

Reblog: June 7 to June 13

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer...

Presentation Slides for Building an Effective Data Warehouse Architecture

Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” for Pragmatic Works.  There were over 500 attendees!  The abstract...