Posts From September, 2015

-March 2024+
SMTWTFS
252627282912
3456789
10111213141516
17181920212223
24252627282930
31123456
  • RSS
  • Add To My MSN
  • Add To Windows Live
  • Add To My Yahoo
  • Add To Google

Statistics

  • Entries (106)
  • 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 - 2024 Fort Worth SQL Server Users Group | Powered by mojoPortal | HTML 5 | CSS | Original design by Andreas Viklund