The featured image for this post is a shot of my Logitech Brio webcam. It has a cover. The cover is open. Why is the camera cover open? If an individual or entity, be they public or private, accesses my webcam, I want them to catch me working or praising God. Or better yet, Catch …
Continue reading My Cameras Are Uncovered
Author:Andy Leonard
Christian, husband, dad, grandpa, Data Philosopher, Data Engineer; Azure Data Factory, Fabric Data Factory, and SSIS guy; and farmer. I was cloud before cloud was cool. :{>
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?
Thank You, Members of the PASS Board of Directors
Today, 15 Jan 2021, is the last day of PASS. I’d like to thank everyone involved in the creation, management, and administration of the organization over its 20+ year history. PASS impacted my career in a very positive way. I didn’t always agree with the decisions of PASS leadership, and I was vocal about a …
Continue reading Thank You, Members of the PASS Board of Directors
Updated “Did You Deactivate Your Twitter Account, Andy?”
Update: I have reactivated my Twitter account. “Yes.” If you are interested in my blog posts and thoughts please sign up for my mailing list of follow me on Twitch.
Getting Started With ADF (Azure Data Factory)
Here’s a sample of a live stream I recorded today about Getting Started with ADF (Azure Data Factory)! You can view the full video here. Be sure to click Follow to be alerted when I stream live! :{> Need Help With ETL or Your Enterprise Data Warehouse? At Enterprise Data & Analytics, we believe you should ask …
Continue reading Getting Started With ADF (Azure Data Factory)
SSIS 2019 Extension v3.11.1 Now Available
The Microsoft SSIS Team released an update to version 3.11 of the Integration Services extension for Visual Studio 2019: SQL Server Integration Services Projects extension for Visual Studio 2019! Release Notes: Version 3.11.1 (Current Version): Release Date: December 28th, 2020 Build Version: 15.0.2000.150 Tested against Visual Studio 2019 16.8 Bug fixes: Fixed an issue that …
Continue reading SSIS 2019 Extension v3.11.1 Now Available
Wrapping Up 2020
It’s that time of year again; that time when bloggers and others share their thoughts about the year that was and the year to come. “2020 was ____.” I complete this sentence three ways, listed below. Feel free to add your thoughts in the comments. “Different” …is the first word that leaps to mind. The …
Continue reading Wrapping Up 2020
Azure DevOps, Git, and SSIS
After a couple false starts, I was able to live-stream one way to use Azure DevOps with Git to source-control the contents of an SSIS Catalog folder – including SSIS Catalog Folder, Projects, Packages, Environments, Environment Variables, Configured Literals, References, and Reference Mappings. In the video, I create an Azure DevOps project configured to use …
Continue reading Azure DevOps, Git, and SSIS
SSIS and the Future – December 2020 Edition
My friend, Sandy Winarko, recently published a fantastic summary of the efforts of the Microsoft SSIS Team to mitigate friction for enterprises seeking to lift and shift SSIS workloads to Azure. In my humble opinion, their work is outstanding. Looking In From the Outside As we say in Farmville Virginia, “Data integration and I go …
Continue reading SSIS and the Future – December 2020 Edition
SSIS 2019 Extension v3.11 Now Available
The Microsoft SSIS Team sent SSIS developers an early Christmas present this year: a new SQL Server Integration Services Projects extension for Visual Studio 2019! Release Notes: Version 3.11 (Current Version): Release Date: December 23th, 2020 Build Version: 15.0.2000.149 Tested against Visual Studio 2019 16.8 Whats’ new: Make creating SSISDB optional in IR Creation Wizard. …
Continue reading SSIS 2019 Extension v3.11 Now Available