Triad SQL Business Intelligence User Group

Welcome

The Triad SQL Business Intelligence Users Group is a forum where any one interested in the Microsoft business intelligence stack can meet to learn more about the product, share ideas and make contact with other similar individuals. Our group is run by Microsoft BI professionals for the benefit of anyone interested in participating in the group.

All of our meetings are free and open to anyone who is interested in sharing their knowledge of SQL Server. Our meetings are generally held on the last Tuesday of every month, unless otherwise noted. Pizza and drinks are provided.

Please register on this site to be included on the latest newsletter and emails announcing our next meetings.


Next Meeting: Tue, Oct 30 2018

Faster SSIS

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.meetup.com/Triad-SQL-Server-BI-User-Group/events/255614059/

Join us on Oct 30th for Andy Leonard's presentation of Faster SSIS, hope to see you there! Pizza and drinks will be served.

When

iCal
UTC : Tue, Oct 30 2018 22:00 - 00:00
Event Time : Tue, Oct 30 2018 18:00 - 20:00 Eastern Daylight Time
Your Local Time: Tue, Oct 30 2018 22:00 - 00:00

Where

4821 Koger Blvd

Greensboro, North Carolina

Direction: None

Featured Presentation

Faster SSIS

Speaker: Andy Leonard, Chief Data Engineer Enterprise Data & Analytics

Summary: Ever wonder why SSIS runs so slowly? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data, and shows you how to tune SQL Server 2016 Integration Services (SSIS 2016) packages. We'll start by experimenting with SSIS design patterns to improve performance loading AdventureWorks data. We will implement different change detection patterns and compare execution performance for each. Then, we'll explain a Data Flow Task's bottleneck when loading binary large objects - or Blobs. Finally, we'll demonstrate a design pattern that uses a Script Component in a Data Flow to boost load performance to MySql, whether on-premises or in the cloud. Prerequisites: Familiarity with SQL Server Integration Services (SSIS).

About Andy: Andy Leonard is founder and Chief Data Engineer at Enterprise Data & Analytics, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS Trainer, Consultant, and developer, a Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of The Biml Book and SQL Server Integration Services Design Patterns and author of Managing Geeks - A Journey of Leading by Doing, Data Integration Lifecycle Management with SSIS, Building Custom Tasks for SSIS, and the Stairway to Integration Services. Andy blogs at andyleonard.blog where you can learn more on the About Andy page. He may be followed on Twitter @AndyLeonard.

Attachments

Please visit our sponsors at:
 
 



 

 

 

Contact Us:

Triadsqlbi@Gmail.com

 
 
 

 

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