Please note: our site will be undergoing scheduled maintenance on April 21, 2019, starting at 07:00 UTC and ending at April 22, 2019 04:00 UTC. During this period, you will not be able to log in to your PASS account. To register for PASS Summit, select the Register as Guest option. If you require assistance, please email helpdesk@pass.org. Thank you for your patience.

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