Watson Plays Jeopardy

I watched the documentary on Nova about the IBM project to build Watson, a computer that could play Jeopardy. The...

Basic SSIS Equivalents to T-SQL's LIKE

There are some things that we do in one SQL Server tool, but can't seem to figure out how to do in another.  One of those for you might...

Converting to the SSIS 2012 Project Deployment Model

The new project deployment model in SSIS 2012 is the new standard for how packages are created, configured and deployed. ...

Denali – Day 22: SQL Server Developer Tools SSDT (Aka “Juneau”)

Denali – Day 22: SQL Server Developer Tools SSDT (Aka “Juneau”)
 
As stated earlier on blog on “LocalDB” discussion, developers are involved...

LinkedIn Group Recommendations-Not Quite Useful

I received an email from LinkedIn suggesting that I might find these groups useful:
 

I’m sure those map back to someone...

Planning the Development, Testing, Staging, and Production Environments for SQL Server part 1.

When asked about how to plan the ideal dev, test, staging and production SQL Server environments it’s easy to get...

Shredding a simple xml structure to a single row flat table

I was helping out a user on the forums the other day where they were asking questions about shredding an...

Slowing Changing Dimension (SCD) demystified – Part 3

I am wrapping up this series by finally considering the rarely used type 3 SCD.
( i.e.  in most business scenarios)
Unlike...

The Tally Table and Expanding Rows

Suppose you had some data like this:
Class           Limit
————— ———–
Calculus        5
History         4
Physics         2
But what you really want is this:

Class          ...

Being careful in SSAS to not make a cube/dimension unprocessed

A big headache in SSAS, especially when dealing with a large cube, is making a change that when deployed, causes...