Next Meeting: Tue, Oct 21 2014
NJSSUG October Meeting
Event Type: In-Person
Online Meeting URL: None
Join Us to hear James Phillips speak on SSIS Performance Tuning Tips and tricks. Will be meeting at our regular location at the Parsippany Library in Parsippany NJ.
6:30 Chapter Updates
6:40 Speaker Presentation
UTC : Tue, Oct 21 2014 22:00 - 00:30
Event Time : Tue, Oct 21 2014 18:00 - 20:30 Eastern Daylight Time
Your Local Time: Tue, Oct 21 2014 22:00 - 00:30
449 Halsey Rd
Parsippany, New Jersey
SSIS Performance Tuning Tips and Tricks
James Phillips, Sr. BI Consultant Pragmatic Works
So you have developed SSIS packages and your now banging your head against the wall on how to get the performance increased. Stop by this session and I will share some of my tips and tricks on how to properly set the Buffer size and engine threads, as well as go over how threading in SSIS works. I will also share with you some common mistakes that are made when picking the wrong source or destination driver and some helpful components you can use to reduce the number of operations and get your packages on the right track.
James Phillips works at Pragmatic Works as a Sr. BI Consultant and has over 15 years of experience with SQL technologies with the last 10 years focused on Business Intelligence. He has worked in a wide array of industries including finance and insurance. Regularly speaks about SSIS and Power BI topics. Also an avid softball player and father to two beautiful daughters.