Posts From September, 2015

-October 2018+
SMTWTFS
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910
  • RSS
  • Add To My MSN
  • Add To Windows Live
  • Add To My Yahoo
  • Add To Google

Statistics

  • Entries (105)
  • Comments (0)

Archives

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 - 2018 Fort Worth SQL Server Users Group | Powered by mojoPortal | HTML 5 | CSS | Original design by Andreas Viklund