I am honored to deliver Moving Data with Azure Data Factory to two User Groups next week! Abstract Azure Data Factory – ADF – is a cloud data engineering solution. ADF version 2 sports a snappy web GUI (graphical user interface) and supports the SSIS Integration Runtime (IR) – or “SSIS in the Cloud.” Attend this session …
Continue reading Two ADF Presentations Next Week!
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. :{>
Twenty years of watching SSIS catalog drift, environment mismatches, and deployment chaos finally has a name: Data Integration Lifecycle Management. I build tools for it at DILM Suite. Start with SSIS Catalog Compare.
Want to Learn More About Azure Data Factory?
From me? I am honored to announce Fundamentals of Azure Data Factory – a course from Enterprise Data & Analytics! The next delivery is 04 Mar 2019, 9:00 AM – 4:30 PM ET. Azure Data Factory, or ADF, is an Azure PaaS (Platform-as-a-Service) that provides hybrid data integration at global scale. Use ADF to build …
Continue reading Want to Learn More About Azure Data Factory?
Testing SSIS Catalog Compare v4.5
I just posted a preview of the next version of SSIS Catalog Compare at the brand new DILM Suite blog. You can head on over and check out the video is you have five minutes to spare. I’ll let you in on a secret: the star of the show is the new SCCPAC Deployment Wizard: …
Continue reading Testing SSIS Catalog Compare v4.5
Thinking of You…
The holidays are a joyous and happy time of year. Almost everyone struggles in some way with the holidays, though. There are numerous posts about how to have difficult conversations with family who disagree with you on some matter or other – usually politics or religion. For some folks, though, it’s worse. Some struggle with …
Continue reading Thinking of You…
How May I Serve You?
2018 is drawing to a close. Some readers recently shared requests for more blog posts on certain topics. I thought I’d put the question to my audience (both of you, hi Mom!) to gather your thoughts. Feel free to leave a comment or reach out via email. Here are some topics I plan to blog …
Continue reading How May I Serve You?
Q: “What are Pitfalls for Software Developers to Avoid?”
I speak with up-and-coming software developers often. A couple junior / intermediate software developers work with me at Enterprise Data & Analytics. As I’ve navigated four decades (plus) of software development I have witnessed – and experienced – places on my career-trajectory-map marked, “Here be dragons.” “I Can Learn All the Things” “My name is …
Continue reading Q: “What are Pitfalls for Software Developers to Avoid?”
Q: “What is the Number One Skill All Software Developers Need?”
A: “Testing.”
Q: “Is It Possible to Get Software Development Right the First Time?”
A: “Almost.” Q: “Why Almost?” I’m glad you asked. There’s an awesome, albeit somewhat dated, article titled They Write the Right Stuff. The article is about implementing a process to manage software development. In the article, the following metrics are mentioned: 3 Previous Builds: 420,000 lines of code 1 error each 11 Previous Builds: 17 total …
Continue reading Q: “Is It Possible to Get Software Development Right the First Time?”
Fundamentals of Azure Data Factory
This past week I delivered Fundamentals of Azure Data Factory twice. Once for Brent Ozar Unlimited and once for a client – a private training delivery. The course introduces Azure Data Factory and covers: Azure Data Factory Essentials – including provisioning an ADF instance Azure Data Factory Pipelines – in which introduce pipeline activities and source …
Continue reading Fundamentals of Azure Data Factory
SSIS, Docker, and Windows Containers, Part 0 – Getting Started
To begin tinkering with SSIS in containers, you first need to install Docker. There are some prerequisites. I will not exhaust the prerequisites here. I strongly suggest you familiarize yourself with the requirements for Docker prior to attempting to install the software. Since I use a PC (a Lenovo P51S) running Windows 10 Pro, I chose …
Continue reading SSIS, Docker, and Windows Containers, Part 0 – Getting Started