Monthly Archive: June 2011

Jun 23

Query Table Metadata

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). What if you want to …

Continue reading »

Jun 14

SSIS Configurations: When and How

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 the big questions, what is …

Continue reading »

Jun 09

SSIS Webinar Recording Is Up

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 it was helpful.  It’s always nice to …

Continue reading »

Jun 07

Free Dynamic SSIS Webinar Today

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 (Twitter | Website) who wasn’t …

Continue reading »

Jun 01

SQL Saturday Pensacola

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 crazy month and I have …

Continue reading »