I am honored to present Moving Data with Azure Data Factory at SQL Saturday 806 in Charlotte, NC 20 Oct 2018. This is the first time I am delivering this session. It still has that new presentation smell! Abstract Azure Data Factory – ADF – is a cloud data engineering solution. ADF version 2 sports …
Continue reading Presenting Moving Data with Azure Data Factory at SQL Saturday Charlotte!
Category:ADF
The Recording for Using SSIS Framework Community Edition is Available
The recording of my free webinar titled Using SSIS Framework Community Edition is now available (registration required). You can obtain the free and open source SSIS Framework Community Edition at DILM Suite. Enjoy! :{>
Introducing Azure Data Factory Design Patterns
I was honored to write an article titled Introducing Azure Data Factory Design Patterns featured in this month’s PASS Insights newsletter! Introducing Azure Data Factory Design Patterns The article covers a couple execution patterns: Execute Child Pipeline Execute Child SSIS Package I demonstrate a cool SSIS Catalog Browser feature that helps ADF developers configure the Execute SSIS Package activity. To …
Continue reading Introducing Azure Data Factory Design Patterns
AndyWeather Internet of Things (IoT)
AndyWeather.com is a site I’ve maintained for about 10 years now. I use the site and related hardware, software, and services to test concepts and perform experiments. I then apply my experience in delivering Internet of Things (IoT) solutions for Enterprise Data & Analytics customers and for SSIS and Biml training, such as my upcoming course titled …
Continue reading AndyWeather Internet of Things (IoT)
Announcing the Fundamentals of Azure Data Factory Course!
I am excited to announce a brand new course (it still has that new course smell) from Brent Ozar Unlimited and honored to deliver it! This one-day, live, online course is titled Fundamentals of Azure Data Factory and it’s designed to introduce you to Azure Data Factory (ADF). There will be demos. Live demos. Lots …
Continue reading Announcing the Fundamentals of Azure Data Factory Course!
PASS Summit 2018 Starts in 10 Weeks!
Can you believe the PASS Summit 2018 begins only 10 weeks from today (27 Aug 2018)? I confess, this is sneaking up on me fast! I will be there. Will you? Where Can You Find Andy at the PASS Summit 2018? Precon! Monday 5 Nov 2018, I’m delivering a full-day pre-conference session titled Intelligent Data …
Continue reading PASS Summit 2018 Starts in 10 Weeks!
Lift and Shift an SSIS Catalog…
… to a different instance on-premises. … to Azure Data Factory SSIS Integration Runtime. This screenshot is from the SSIS Catalog Compare documentation. You can script an entire SSIS Catalog using SSIS Catalog Compare! This awesome functionality can save you hours (days, weeks, even!) when starting a new project or updating an existing project. This …
Continue reading Lift and Shift an SSIS Catalog…
Announcing SSIS Catalog Compare Version 3!
I’m so happy to announce the release of SSIS Catalog Compare version 3! SCCv3 Speaks Cloud In May, Microsoft announced the general availability of Azure Data Factory SSIS Integration Runtime. Customers immediately began deploying SSIS from on-premises servers to the cloud. Some quickly recognized some gaps in the process, such as: On-premises, enterprises have the …
Continue reading Announcing SSIS Catalog Compare Version 3!
DevOps and SSIS and Azure Data Factory
I wrote a book about practicing Data Integration Lifecycle Management with SSIS. In the book I explore tools I built to support DevOps with SSIS. Collectively, I call them the Data Integration Lifecycle Management Suite (DILM Suite). Many utilities at DILM Suite are free and some are open-source: SSIS Framework Community Edition – free, open-source, and …
Continue reading DevOps and SSIS and Azure Data Factory
Honored to Present Lift and Shift SSIS to ADF at #Azure DataFest Atlanta
The #Azure DataFest Atlanta Schedule has been posted and I am honored to be selected to present Lift and Shift SSIS to ADF! Check out this lineup of presenters and presentations. I describe this group as: “a bunch of smart people – plus me!” Lift and Shift SSIS to ADF Abstract Your enterprise wants to …
Continue reading Honored to Present Lift and Shift SSIS to ADF at #Azure DataFest Atlanta