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?
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: “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
Packaging SSIS Catalog Deployments
I love the SSIS Catalog. It’s an elegant piece of data integration engineering and I cannot say enough positive things about it. Packaging SSIS Catalog deployments can be tricky, though. The SSIS Catalog is a framework. Frameworks manage execution, configuration, and logging; and the SSIS Catalog handles each task with grace. Like I said, I …
Continue reading Packaging SSIS Catalog Deployments
PASS Summit 2018 Session Feedback
I was honored to participate in three presentations at the PASS Summit 2018. I delivered a full-day pre-conference session titled Intelligent Data Integration and another session titled Faster SSIS. I also participated on a panel titled BI & Data Visualization. A great big THANK YOU to everyone who attended my presentations! As I’ve shared (numerous …
Continue reading PASS Summit 2018 Session Feedback
Biml, Book Reviews, and Metadata-Driven Frameworks
I occasionally (rarely) read reviews at Amazon of books I’ve written. If I learn of a complaint regarding the book I often try to help. If a reader experiences difficulty with demos, I often offer to help, and sometimes I meet with readers to work through some difficulty related to the book (as I offered …
Continue reading Biml, Book Reviews, and Metadata-Driven Frameworks
Catalog Browser v0.7.8.0
I’ve been making smaller, more incremental changes to SSIS Catalog Browser – a free utility from the Data Integration Lifecycle Management suite (DILM Suite). You can use SSIS Catalog Browser to view SSIS Catalog contents on a unified surface. Catalog Browser works with SSIS Catalogs on-premises and Azure Data Factory SSIS Integration Runtime, or Azure SSIS. It’s …
Continue reading Catalog Browser v0.7.8.0