Kindle vs Library

Since I bought a Nexus 7 (two of them, I broke the first one) I’ve been interested to see if...

Is $160 Per Day a Lot?

Recently I was in a small coffee/sandwich shop for early morning coffee and while waiting watched one of the employees...

Interesting Approach-One Time Tools

Recently I ordered a Paolini Pocket Rule from Woodpecker. It is one of a series of OneTime Tools they’ve produced...

Azure First

Microsoft has been pretty clear about their commitment to the entire Azure infrastructure. The updates to Azure come out on...

Last Weeks Top “Reading” Links #37

For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...

Natural Born Killers (The series) – Day 1 Statistics

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

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