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

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