I spent a lot of time this year writing and managing a book project. I will blog about that later, I promise. While I enjoy writing it really cuts into my play time. What do I do when I play? I write software. This weekend I cracked open the code for SSIS Catalog Compare and …
Continue reading Coming Soon: SSIS Catalog Compare Updates
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.
(Some of) Why We Do What We Do, an Opinion
I encounter different personalities in the Technology Communities to which I belong. I’m not merely a consumer, I contribute a different personality as well. I’ve been playing and working in technology since 1975. One thing I’ve learned is: people believe the things they believe for a reason. Or reasons. I can hear some of you …
Continue reading (Some of) Why We Do What We Do, an Opinion
Remain Standing
Why am I writing about this on a technical blog (instead of my personal blog where I discuss faith and culture)? In this post I discuss personal and professional perseverance. I make no apology for my faith or for sharing it in every setting – personal and professional. People are singletons; you cannot decouple components of …
Continue reading Remain Standing
Catalog Reports Update
I recently updated the Data Integration Lifecycle Management Suite (DILM Suite) Catalog Reports solution! Here’s a summary of the changes: I re-arranged fields on the Executions Report: I moved the links to the Overview, Messages, and Performance reports to the left in each (execution) row to support easier navigation. I added Previous and Next Execution …
Continue reading Catalog Reports Update
Congratulations Kent Bradshaw – Certified Data Scientist!
I am honored to announce Kent Bradshaw, who works with me at Enterprise Data & Analytics, is now a Microsoft Certified Data Scientist! Kent worked hard for several months to achieve this honor. He worked through ten courses, including a five-week Statistics course taught by Columbia University faculty. Congratulations Kent! :{> Learn more: Enterprise Data …
Continue reading Congratulations Kent Bradshaw – Certified Data Scientist!
A Basic SSIS Catalog Dashboard in Power BI
Announcing the latest addition to the DILM Suite: Basic SSIS Catalog Dashboard in Power BI! This free download includes a T-SQL script to create a view in the SSIS Catalog database (SSISDB) and a Power BI template for viewing SSIS Catalog executions by Year, Month, Folder, Project, Package, and/or Execution Status. The Basic SSIS Catalog Dashboard …
Continue reading A Basic SSIS Catalog Dashboard in Power BI
Please Change the Color of the SSIS Progress Tab “Finished” Icon
I’m tuning SSIS for better performance for a large client. The SSIS package I’m working with runs for over an hour and generates thousands of entries on the Progress / Execution Results tab. I wrote a small demo package, executed it, and show the results here to demonstrate: Why is the Finished icon red? This …
Continue reading Please Change the Color of the SSIS Progress Tab “Finished” Icon
Updates to Integration Services Deployment Wizard
I’m doing a little writing and I noticed something different about the Integration Services Deployment Wizard. Specifically, the Select Destination page now looks like this: The Authentication dropdown – along with the User name and Password textboxes – are recent additions. I’m not sure if they’re part of the SSMS 17.2 installation or one of …
Continue reading Updates to Integration Services Deployment Wizard
Intelligent Data Integration, SSIS Design Patterns, and Biml
On occasion I have the privilege and honor of delivering a full-day precon titled Intelligent Data Integration: SSIS Design Patterns and Biml as part of SQL Saturday events. “Isn’t This The Same Presentation You Delivered Before, Andy?” Yes and no. It has the same title but… I’ve focused on Biml presentations for the past two years. Over the …
Continue reading Intelligent Data Integration, SSIS Design Patterns, and Biml
A Custom Biml Framework in Action!
Watch this short video (2:32) of a custom Biml Framework in action.