There will inevitably come a day when you want to take a look at the metadata of the tables inside a database. This can be accomplished one of many ways, the quickest and easiest is to expand the columns node inside the Object Explorer in SQL Server Management Studio (SSMS).… Read more

Configurations in SSIS are a lovely tool that when implemented correctly can greatly reduce package maintenance.  It is very possible to over configure a package, so be sure that you only do what you need to in order to make life easier.  Sometimes too much configuration can equal confusion.  So… Read more

I want to say a huge thank you to everyone who attended the webinar from Pragmatic Works (website) that I did on Tuesday.  If you missed it the topic was Dynamic SSIS: Configurations, Expressions and Variables.  I got a lot of good feedback from people who attended saying… Read more

If you were able to make it out to SQL Saturday in Pensacola this past weekend I want to say a big thank you!  We had a great time at a very successful event.  I was able to help out a little and take on an extra session from Julie… Read more

I know it has been almost a month since I posted last and this is not really a “real” post, but I assure you that new content is on the way.  I have a couple things in the works that I hope to post this week.  It has been a… Read more