Question: How do I make sure everyone at my company is using the same SSIS framework and design patterns? SSIS Design Patterns and frameworks are […]
Slides from SSIS Performance Design Patterns | TechDays Hong Kong 2013
The slides from my 3rd presentation at the TechDays Hong Kong event are now available. As I mentioned during the talk, design patterns are one […]
Dynamic Execution of Child Packages with Different Parameters
SSIS 2012 introduces the concept of Parameters – a more explicit way of configuring your SSIS packages that you can use with the Project deployment […]
PASS Summit 2012 – SSIS Pre-Conference Event
Well, I guess Andy, Tim & I did a good job at PASS last year, as we’ve been invited back to present another SSIS pre-conference […]
SSIS Performance Design Patterns
Here are the slides (all 177 of them) for the SSIS Performance Design Patterns talk that I’ve delivered at three different pre-conference events over the […]
Speaking at SQL Saturday #105 in Dublin, Ireland
I’m honored to be presenting at SQL Saturday #105 in Dublin, Ireland on March 24th. They recently added a 4th session track to keep up […]
Design Pattern: Avoiding Transactions
SSIS has built-in support for transactions, but their use isn’t ideal for all scenarios. This post covers how SSIS transactions work at a high level, […]
Upcoming Book – SSIS Design Patterns
Over the past few months I’ve been working on a book for SQL Server 2012 entitled – SSIS Design Patterns. I’m co-authoring the book with […]