Fox Valley Microsoft Data Platform

Next Meeting

Wednesday,

February

05

FoxPASS February 2014 Meeting

  • In-Person @ 100 W Lawrence St, Suite 100 Appleton Center Appleton, Wisconsin, United States (map)
  • 17:30 - 19:00 (UTC-06:00) Central Time (US & Canada)
  • Language: English
  • RSVP URL: None

Our very own Ken Stuber is presenting real-life lessons learned about ETL. Join us! 

Featured Presentation:

Performance-Tuning for Extract/Transform/Load (ETL) Operations

Ken Stuber, Owner and Principal Consultant Drop Clean Buffers Consulting, LLC

Much has been written about performance tuning transactional systems and reports, but what about those huge queries used to populate your data warehouse, data marts or large data extracts? What good are reports if you can’t deliver the underlying data in a timely manner? What can be done to make handling millions of rows at a time go faster? In this talk, we’ll go over how to architect an ETL solution that will use every trick in the SQL-Server engine to make data move faster! We’ll be focusing on T-SQL based ETL stored procedures (and a little SSIS) rather than expensive tool-based ETL. We’ll also discuss hardware issues and how to tune processes that you can’t “change”.

About Ken:
Ken Stuber is the Data Architect at Jewelers Mutual Insurance in Neenah, WI as well as being an independent consultant with Drop Clean Buffers Consulting, LLC. Ken has been working with SQL Server since v6.5 in 1997 and has broad experience in the Microsoft Data Platform. His primary interests are in the performance tuning, enterprise architecture, DevOps, database design and database development. When not fighting the query optimizer, he can be found RVing around North America, backpacking, cooking, gardening, reading, and studying for whatever will replace the MCM program.

Bronze Sponsors

 

Hosts

 

Other Sponsors

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif 

 

Brent Ozar Unlimited

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids