Search
Post Calendar
My Tweets
- I just entered to win a $50 Miniature Market Gift Card with help from @TheGameBoyGeek ! gameboygeek.com/contest 4 years ago
- Help Sydney travel Abroad gofundme.com/help-sydney-tr… 5 years ago
- Got to meet zee @dtconofficial https://t.co/m0YUdcLVOr 5 years ago
- RT @SQLChicken: #SQLSat476 BI on 11/14/2015 feat. myself,@idigdata,@mikedavisSQL,@pamshaw,@sharepointmikea,@sql_r and more https://t.co/3qc… 6 years ago
- 10 things #leaders can do to drive results today #leadership bit.ly/1hnO0Fb via @wadamj 6 years ago
Pass Summit 2011
SQL Rally
Meta
Monthly Archives: October 2013
SSIS Pivot on bad data
The pivot transform in SSIS is already a pain to use. When you have bad data it makes it even worse. In this blog I am going to show how to handle bad data when using the pivot transform. You … Continue reading
SSRS Nulls in a matrix
In a recent SSIS class one my students ask me, if you are reporting off a table and using it in a matrix, does the matrix show null rows. The answer is yes. Here is an example table and the … Continue reading
Missing Foreign Keys in SSAS DSV
When creating report models you might run into bad database designs where the tables have no foreign keys and/or no primary keys. This can be resolved in the report model DSV. I have created two tables, one with first names, … Continue reading
SSIS Records on the Same Row – kind of like pivot
If you have two or more records on the same row, and need to write each record on its own row in a destination, you have two choices. You can do this in series or parallel in a single data … Continue reading