Just a quick shout out that I’ll be at SQL Saturday Oklahoma City tomorrow to give an updated version of the following presentation.
SSIS Performance Tuning with BimlScript
You may heard that Biml can automate ETL loads, but what if your data warehouse is several terabytes with a tight load window. In this demo focused presentation, we’ll discuss how to use BimlScript to accomplish the following:
– Dynamically create multiple SISS packages for a data warehouse ETL load, each following a different best practice design pattern.
– Automatically execute each package multiple times and record the results for analysis.
– Determine which package version should be used in production.
The only way to be sure that your SSIS packages are performing optimally is to test them against multiple patterns. Make your life easier and let BimlScript do the work for you.
Presentation Code Download
Also, I’m bringing a big box of Biml schwag with me, courtesy of my friends at Varigence, including shirts, miniature footballs, laptop stickers, etc.
It’ll be a great time, and I can’t wait to see some of you there!