I’m coding along on the next release of SSIS Catalog Compare, happy as a clam, when I realize it’s time to add a new menu item. I open the form and… nothing. To say my heart sank would be an understatement. I had questions. “Dude, where’s my controls?” “What happened?!” “Will I be able to …
Continue reading Dude, Where’s My Controls? (Visual Studio 2017 Behavior)
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.
On Output…
I’m going to be a little bold in this post and suggest if you are developing for SQL Server, the screenshot to the left and above shows something that is, well, wrong. I can hear you thinking, “What’s Wrong With That Output, Andy?” I’m glad you asked. I will answer with a question: What just …
Continue reading On Output…
Introduction to the SSIS Lifecycle – 7 Jun 2018
Join me Thursday, 07 Jun at noon EDT for a free webinar: Introduction to the SSIS Lifecycle! How should an enterprise promote SSIS projects from Development to Production? How many “levels” are required? What are the best practices? Do SSIS lifecycle management tools exist? Join Andy Leonard – SSIS author, trainer, and consultant – to …
Continue reading Introduction to the SSIS Lifecycle – 7 Jun 2018
“You Do Not Know What You Are Doing”
Peeves make lousy pets. Knowing this doesn’t help; I still keep a few pet peeves. One of my pet peeves is this statement, “You don’t know what you are doing.” Why is this a pet peeve? It denies the obvious fact that everyone one of us, everywhere, is still learning. “My Name is Andy and …
Continue reading “You Do Not Know What You Are Doing”
Introduction to Configuring SSIS in the SSIS Catalog – 24 May 2018
Join me Thursday, 24 May for a free webinar: Introduction to Configuring SSIS in the SSIS Catalog! The SSIS Catalog is a flexible data integration framework. What’s wrong with that last sentence? “Flexible” is dual-edged – it means there’s some complexity. Fear not! Andy Leonard – SSIS author, trainer, and consultant – is here to …
Continue reading Introduction to Configuring SSIS in the SSIS Catalog – 24 May 2018
How I Learn
This is a picture of how I learn. These are executions of an Azure Data Factory version 2 (ADFv2) pipeline. The pipeline is designed to grab data collected from a local weather station here in Hampden-Sydney Virginia – just outside Farmville – and piped to Azure Blob Storage via AzCopy. How do I learn? Fail …
Continue reading How I Learn
Catalog Browser, Version 0.6.2.0
If you’ve read this blog for a short time, you already know I have a passion for DevOps. You probably guessed I also have a passion for data engineering (My job title at Enterprise Data & Analytics is Chief Data Engineer). I believe successful software development is a combination of a software development platform, a …
Continue reading Catalog Browser, Version 0.6.2.0
T-SQL Tuesday 102: Giving Back
I enjoy the privilege and honor of participating in the SQL Server Community alongside many who read this blog. And I know from past experience that some reading this post will make the switch from consumers-only in our community to sharers and consumers one day. For my part, I consume more than I contribute. I …
Continue reading T-SQL Tuesday 102: Giving Back
Stack Overflow Wants to Change
This week Stack Overflow shared a blog post titled Stack Overflow Isn’t Very Welcoming. It’s Time for That to Change. I admire the courage and the transparency a great deal. It takes guts to admit mistakes and serious guts to publicly air the dirty laundry. Kudos to Stack Overflow. Why I Stopped Contributing to the Stack Overflow Conversation I …
Continue reading Stack Overflow Wants to Change
Who is Exhibiting at the PASS Summit 2018? Enterprise Data & Analytics, That’s Who!
I am honored and excited to announce that Enterprise Data & Analytics will be an exhibitor at the PASS Summit 2018! If you browse on over to the PASS Summit Sponsors page and scroll to the Exhibitors section, you’ll find us listed: Honored and excited – that’s me! I see – and have lived – …
Continue reading Who is Exhibiting at the PASS Summit 2018? Enterprise Data & Analytics, That’s Who!