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?”
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. :{>
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
Two (or More) Kinds of Developers
I’ve made statements about “two kinds of developers” for years. These statements are false inasmuch as all generalizations are false. The statements are not designed to be truisms. They are designed to make people think. Last week – while presenting a full-day pre-conference session at the PASS Summit 2018 and again when delivering a session …
Continue reading Two (or More) Kinds of Developers
Want a Free #DILM Book? See Me at the #PASSsummit 2018!
I’ll be at the PASS Summit 2018 next week. I’m delivering a full-day precon Monday, presenting Faster SSIS and participating in the BI & Data Visualization Panel Wednesday, and Enterprise Data & Analytics is exhibiting Wednesday through Friday. “You Mentioned a Free Book…” Oh. Yeah. That. I will be giving away free copies of my latest book: Data Integration …
Continue reading Want a Free #DILM Book? See Me at the #PASSsummit 2018!
DILM Tiers for Enterprise Data Integration
“How many Data Integration Lifecycle Management tiers (DILM tiers) do I need to manage enterprise data integration, Andy?” If I had a nickel for every time I am asked this question, I would have a lot of nickels. My answer is, “Four.” Why Four? I’m glad you asked. Before I answer, I have a question …
Continue reading DILM Tiers for Enterprise Data Integration