Thanks, Vets

Power Testing ETL with Power BI – The Process

This is a short blog series on using Power BI tools to support testing ETL processes. I have presented on...

T-SQL Tuesday #60 – Something New Learned

It’s been five years, and that’s amazing. Not many things last for a year, much less five, but the T-SQL...

I’m Still Not on the Board

I’m just back from the PASS Summit 2014. What a great event. But this year, it was a little different....

Join me in DC for a full day of Biml

I’m excited to announce that my Linchpin People colleague Reeves Smith and I will be delivering a full day Biml...

T-SQL Tuesday #60 Something New Learned

So, here it is. I put the challenge out to discuss something new learned last week. I was fortunate enough...

TSQL Tuesday #60: Something New Learned – What permissions does have?

What have I learned recently? Well as it happens I learned something rather interesting recently and was actually trying to...

How To Use the Unpivot Transform in SSIS

Moving data from columns to rows can be a tricky task and accomplished in a variety of ways. That may be...

PASS Summit 2014 – It’s not you, it’s me

After an exciting week at the PASS Summit, I’m back home with my family.  This was my first ever PASS...

Consuming the Output of an SSIS Package in a Client Application

Typically, making the output of an SSIS Package available to a client application for further processing is achieved by outputting...