Jobs    Everything

Select a Metro Area
When:
May 17, 2022 @ 8:00 AM – 9:00 AM
2022-05-17T08:00:00-04:00
2022-05-17T09:00:00-04:00
Contact:
Microsoft Data and AI South Florida User Group
Azure Data Factory Lift and Shift by Torsten Strauss

How to Lift and Shift SSIS packages using Azure Data Factory?
By attending this session, you will learn how to migrate your SSIS integration project to Azure Data Factory – Lift and Shift by Torsten Strauss

– TITLE: Azure Data Factory Lift and Shift

– TOPICS COVERED:
* Azure Data Factory (ADF)
* Self-Hosted Integration Runtime (IR) setup and configuration
* Azure SSIS Integration Runtime
* Accessing on-premises data by the Self-Hosted IR or network peering
* Windows Authentication
* Protect sensitive connection information

– ABSTRACT:
Azure Data Factory Lift and Shift
In this session, you will learn how to migrate your existing on-premises Integration Services projects to Azure Data Factory. The challenge here is to access existing on-premises data sources such as a share or SQL Server in the Azure Data Factory cloud service. There is either the option of installing a self-hosted integration runtime and registering it as a proxy in the Azure SSIS integration runtime or enabling access through network peering and doing it without the self-hosted integration runtime. We will also look at how Windows authentication can be implemented through the Azure SSIS integration runtime.

– BIOGRAPHY:
Torsten Strauss (MVP, MCSE, MCT) has been working with Microsoft SQL Server since the turn of the millennium and is specialized in performance optimization for large SQL Server environments. He has been with bp as a database engineer for over two decades and collaborates closely with Sarpedon Quality Lab as a Principal Microsoft SQL Server Consultant. Torsten is the founder of inside-sqlserver.com and has given more than 170 presentations on Microsoft SQL Server performance optimization at national and international conferences and user groups. Torsten has been recognized as a Microsoft Most Valuable Professional for Data Platform since 2018.
Share the RSVP this event with friends:
Connect with our supporters who make it all possible

***

* Contact: Torsten Strauss

LinkedIn: https://www.linkedin.com/in/torsten-strauss/
Twitter: [@TorstenStrauss](https://twitter.com/TorstenStrauss) – [https://twitter.com/](https://twitter.com/adasilvatek)[TorstenStrauss](https://twitter.com/TorstenStrauss)

***

** Join DataAISF – Microsoft Data and AI South Florida User Group**

* YouTube – https://bit.ly/2RsbCgY – Subscribe Now
* Twitter – https://bit.ly/3crVYKe – Follow Us
* MeetUp – https://bit.ly/2QRjN8Q – Register

***

* DATE & TIME:

Title: Copy data from SQL Server to Azure SQL DB with Azure Data Factory
By : Torsten Strauss
Date: Tue. – May 17th, 2022
Time: 12:00 pm US EDT
RSVP:
* LOCATION:
* Online:

Subscribe to the channel & Click on the Bell
https://bit.ly/2RsbCgY

– RSVP and Bring a Friend:

* Join DataAISF – Microsoft Data and AI South Florida User Group
* YouTube – https://bit.ly/2RsbCgY – Subscribe Now
* Twitter – https://bit.ly/3crVYKe – Follow Us
* MeetUp – https://bit.ly/2QRjN8Q – Register

. .