You might need an SSIS framework. “How can I tell if I need an SSIS framework, Andy?” I’m glad you asked. Does your enterprise: Practice DevOps? Execute lots of SQL Server Integration Services (SSIS) packages? Execute SSIS packages several times per day? Execute “SSIS in the Cloud” using the Azure Data Factory version 2 Integration …
Continue reading You Might Need an SSIS Framework
My Books
I’ve authored and co-authored a bunch of books! Truth be told, I enjoy writing. I think my love of writing stems from a love of learning. I’m just trying to share the joy! It’s a huge honor to write. I’m humbled and thrilled (all at the same time – a feeling I describe as “all …
Continue reading My Books
Dude, Where’s My Controls? (Visual Studio 2017 Behavior)
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)
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