Fox Valley Microsoft Data Platform

Next Meeting: Wed, Feb 05 2014

FoxPASS February 2014 Meeting

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: None

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

When

iCal
UTC : Wed, Feb 05 2014 23:30 - 01:00
Event Time : Wed, Feb 05 2014 17:30 - 19:00 (UTC-06:00) Central Time (US & Canada)
Your Local Time: Wed, Feb 05 2014 23:30 - 01:00

Where

100 W Lawrence St, Suite 100 Appleton Center
Appleton, Wisconsin

Direction: None

Featured Presentation

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

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

Summary: 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.

Attachments

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