I keep reading posts about how agile died. And I get it. All I ask is one small favor: Please don’t confuse agile with mis- implementations that go by the same name. Is agile for everyone? Every business? Every project? Goodness no! But… Agile recognizes some uncomfortable facts about delivering software. For some projects, the …
Continue reading Agile Bashing
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.
Time and Money in the Cloud
What Could Your Enterprise Do With Extra Time? Benjamin Franklin is credited with saying, “Time is money.” The 2011 movie, In Time, depicts an entire economy based on time. (A friend pointed out that time is not fungible, but I digress…) So, what could your enterprise do with more time? When you think about it, …
Continue reading Time and Money in the Cloud
SSIS Catalog Browser and Azure Data Factory
I just posted this fun little video (77 seconds) to my LinkedIn feed! It was fun to make and I really like building solutions for the Community. Feedback much appreciated, including suggestions for functionality you’d like to see added to SSIS Catalog Browser. :{>
SSIS Catalog Compare Documentation is Available
I’m excited to announce the availability of SSIS Catalog Compare Documentation! And now, it’s free!
Getting Started Writing
I recently wrote a couple blog posts about writing. Is this meta-writing? I reckon. The posts are titled Writing a Technical Book and One Way to Write a Technical Book. Writing a Technical Book is a generic-ish look at the process of writing a technical book, while One Way to Write a Technical Book is …
Continue reading Getting Started Writing
Delete SSIS Catalog Folders With SSIS Catalog Compare
To delete a Catalog folder using SSIS Catalog Compare, right-click the folder and click Delete Folder: You are prompted to confirm folder deletion: If the folder contains additional Catalog artifacts, the user is prompted again to confirm the deletion of the folder and all contents: Let’s take a short break right here and consider some …
Continue reading Delete SSIS Catalog Folders With SSIS Catalog Compare
Anatomy of a Catalog Reference Script in SSIS Catalog Compare
A Catalog Reference script is automatically generated from several methods in SSIS Catalog Compare’s Catalog object named CatalogBase. Header Documentation The script begins with a header documentation similar to that shown here: When executed, the Project Reference script header documentation portion displays in the Messages output window of SQL Server management Studio (SSMS): The statements …
Continue reading Anatomy of a Catalog Reference Script in SSIS Catalog Compare
The Recording for Use Biml to Build a Local Copy of an Azure SQL DB is Available
Enjoy! :{>
Anatomy of an Environment Script in SSIS Catalog Compare
An SSIS Catalog Environment script is automatically generated from several methods in SSIS Catalog Compare’s Catalog object named CatalogBase. Declarations and Header Documentation The script begins with a declaration of Transact-SQL parameters that support SSIS Catalog Environment Variables contained within an SSIS Catalog Environment. These parameters are placed at the top of the script for …
Continue reading Anatomy of an Environment Script in SSIS Catalog Compare
Anatomy of an SSIS Catalog Connection Literals Script in SSIS Catalog Compare
An SSIS Catalog Connection Literals script is automatically generated using several methods in SSIS Catalog Compare’s Catalog object named CatalogBase. Declarations and Header Documentation The script begins with a declaration of Transact-SQL parameters that will be used to provide literal overrides. These parameters are placed at the top of the script for easy access by …
Continue reading Anatomy of an SSIS Catalog Connection Literals Script in SSIS Catalog Compare