Posts From September, 2015

Sept 16 Meeting - SSIS Performance Tuning with BimlScript - David Stein 

Sunday, September 13, 2015 10:23:00 PM Categories: Meeting
Abstract:
You know that Biml can automate ETL loads, but 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.
 
Bio:
David Stein - Data Warehouse Architect and Independent Consultant - has more than a decade of experience working in SQL Server Business Intelligence. He’s designed multi-terabyte, multi-tenant Data Warehouses from scratch as well as saved projects in serious jeopardy.
 
Site Map | Printable View | © 2008 - 2017 Fort Worth SQL Server Users Group | Powered by mojoPortal | HTML 5 | CSS | Original design by Andreas Viklund