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

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

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

PASS Summit 2014 in Review

I’m finally completely recovered from a great week in Seattle last week for PASS Summit.  Now that it’s back to...

PASS Summit 2014 in Review

I’m finally completely recovered from a great week in Seattle last week for PASS Summit.  Now that it’s back to...

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

Thanks, Vets

Tracking Progress of SQL Server Index Builds and Rebuilds

Let’s say you build or rebuild an index in SQL Server. Your users and boss are anxious to know when...

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