Documenting an SSIS Lift and Shift Project

I was honored to work on a cool SSIS lift and shift project in 2021. I will not mention project details or the client. I will share that I’ve worked with the team before and that they are awesome and talented and easy to work for (and with). The company is large. Like international-large. I, …
Continue reading Documenting an SSIS Lift and Shift Project

Video Coding and Loading Leonard Greenhouse Data

I had some time over the weekend to work on a process to capture weather measurements from an IoT instrument pack Stevie Ray recently constructed. You can learn more about what he did over at his blog – StephenRayLeonard.com – in a post titled The Modern Back Yard Greenhouse Begins With IoT. Although I did …
Continue reading Video Coding and Loading Leonard Greenhouse Data

Join Me for LIVE Online SSIS and ADF Training 29 Nov – 1 Dec

It’s been a while since I delivered training live and online. Let’s fix that! Join me for Master the Fundamentals of ADF and Expert SSIS 29 Nov – 1 Dec.

Q & A: Learning ETL. Where Should I Focus?

A viewer on my YouTube channel asked, “Never been too deep into SSIS, but the new role I’ll be taking on involves ETL, should I be focusing on Azure Data Factory, or do you recommend I keep a foot in each of those worlds?” My response? At this time, it’s prudent to cultivate options in …
Continue reading Q & A: Learning ETL. Where Should I Focus?