New Page - "How to Get Involved With the SQL Server Community"

I recently composed an email (on the side) for a client DBA looking for info on getting involved with the...

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

Special Recognition For Top Community Leaders In India

I got a special recognition from Microsoft, India as one of the top community leaders.
My sincere thanks to SQLServerCentral (my...

SSAS Data Mining – Time Series Algorithm

At TechEd 2013, I attended a few sessions on the topics of Data Mining and Predictive Analytics.  I thought I’d...

The Changing World of BI, A New White Paper for Magenic

In the ever changing landscape that is Business Intelligence (or is that Business Analytics?), a fellow business analyst from Magenic,...

Low-rate recruiters – The bane of my existence

There is nothing more annoying to me in my profession than getting calls and emails from recruiters who are looking...

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

Reading Traces

Capturing information is useless unless you know how to use it. Here’s what I use to get the most out...

Speakers: Rehearsals Help

Today was a rehearsal day. Actually the last 2-3 days of work have been split between rehearsing talks that I’m...

SQL Server – Update Table with INNER JOIN

Often we may need to update a column in a table based of another column in another table.
In SQL Server...