PASS Summit 2008: SSIS Scripting

It’s That Time of Year Again…  I am honored to again be presenting at the PASS Summit! I’m even more honored to be co-presenting SSIS Scripting with Jessica Moss, SQL Server MVP! Errata Somewhere in the abstract for this presentation I listed the following three goals: Explore SSIS Script Objects Best practices for script coding …
Continue reading PASS Summit 2008: SSIS Scripting

K. Brian Kelley on Leadership

My friend K. Brian Kelley has an excellent post this morning on leadership. Brian is one of the SQL Server bloggers I follow regularly. He is a cross-trained technology professional – and able to apply lessons learned from technology to another. He does that with work / life things too – applying lessons from his …
Continue reading K. Brian Kelley on Leadership

Database Edition and You – Some Cool Changes

Greg Low mentioned the new licensing model for Database Edition is his post on the topic a few days ago. What does this mean for you? Here’s my take: Now that Database Edition is included (free as in beer) with Developer Edition, application developers can take advantage of some of the awesome features built into Database …
Continue reading Database Edition and You – Some Cool Changes

My 2008 PASS Summit Sessions

I am honored to be selected to present at the 2008 PASS Summit! I’m presenting two sessions: Test-Driven Development For Database Professionals and SSIS Scripting. I’ve been working on the presentations recently and realize there will be a few minutes left in the SSIS Scripting talk unless I talk slow. (Some people say I talk slow …
Continue reading My 2008 PASS Summit Sessions

SSIS Design Pattern – Collect Enterprise SQL Server Database Metadata With SSIS

Introduction A few months back I received an email from a nice lady who was beginning to work with SSIS. She was trying to use SSIS to automate metadata collection in her enterprise and she had made a good start in the package she attached to the email. She had a few questions so I opened …
Continue reading SSIS Design Pattern – Collect Enterprise SQL Server Database Metadata With SSIS