North Texas SQL Servers Users Group

Next Meeting

Thursday,

September

21

NTSSUG 21 SEPTEMBER 2017

  • In-Person @ 7000 North Highway 161 Irving, Texas, United States (map)
  • 18:00 - 19:30 Central Daylight Time
  • Language: English

RSVP Here: https://www.meetup.com/North-Texas-SQL-Server-User-Group/events/241100663/

SSIS and the Cloud, Yes! They Can Get Along! 

Summary: SQL Server Integration Services (SSIS) has been around since the cloud was just a term to describe the weather. SSIS is great at handling most any on-premises data load need, but that doesn't mean that it can't be used for cloud or on-prem/cloud hybrid architectures. With the flexibility in its legacy behaviors and the new cloud-specific tasks and components, Integration Services is versatile enough to wrangle both traditional on-prem and cloud-based ETL needs.In this session, we will cover how SQL Server Integration Services can play well with the cloud. We'll review and demonstrate how existing SSIS tasks and components can be used for cloud or hybrid load scenarios, and will walk through some of the newest tools built specifically for cloud endpoints. We will also discuss the role SSIS plays in the enterprise alongside other cloud data integration tools, including Azure Data Factory (ADF). 

Presenter: Tim Mitchell

Bio: 

Tim Mitchell is a business intelligence consultant, author, and trainer.  He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting.  He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and is recognized as a Microsoft Data Platform MVP.  Tim is the founder and principal data architect at Tyleris Data Solutions.

As an active member of the community, Tim has spoken at international, regional, and local venues including the SQL PASS Summit, SQLBitsSQL ConnectionsSQL Saturday events, and various user groups and webcasts.  Tim is coauthor of the book SSIS Design Patterns, and is a contributing author on the charity book project MVP Deep Dives 2.  He is an active group member and speaker at the North Texas SQL Server User Group in the Dallas area.

You can visit his website and blog at TimMitchell.net or follow him on Twitter at twitter.com/Tim_Mitchell.

Meeting starts: 6:00 pm with food and a QA session

Presentation: 6:30 pm to 7:30 pm

Address: 
Microsoft Las Colinas Offices  
7000 North Highway 161 , Building LC-1  
Irving Texas 75039  
Map: https://goo.gl/maps/h9aWDZ6Z3wK2

Afterward socializing: If there is interest, we will gather at NYLO (1001 W Royal Ln, Irving, TX 75039) to casually socialize

Featured Presentation:

SSIS and the Cloud, Yes! They Can Get Along!

Tim Mitchell, Principal Data Architect Tyleris Data Solutions

SQL Server Integration Services (SSIS) has been around since the cloud was just a term to describe the weather. SSIS is great at handling most any on-premises data load need, but that doesn't mean that it can't be used for cloud or on-prem/cloud hybrid architectures. With the flexibility in its legacy behaviors and the new cloud-specific tasks and components, Integration Services is versatile enough to wrangle both traditional on-prem and cloud-based ETL needs.In this session, we will cover how SQL Server Integration Services can play well with the cloud. We'll review and demonstrate how existing SSIS tasks and components can be used for cloud or hybrid load scenarios, and will walk through some of the newest tools built specifically for cloud endpoints. We will also discuss the role SSIS plays in the enterprise alongside other cloud data integration tools, including Azure Data Factory.

About Tim:
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions. Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQL Saturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.


Thank You to the 

PLATINUM

SPONSORS 

of our May 2018 

SQL Saturday!











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