In my experience, people either love or hate triggers in Transact-SQL. As a consultant, I get to see some interesting solutions involving triggers. In one case, I saw several thousand lines of T-SQL in a single trigger. My first thought was, “I bet there’s a different way to do that.” I was right. The people …
Continue reading T-SQL Tuesday #106: Regarding Triggers
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. :{>
Change to the SSMS Create Catalog Dialog
I’m glad to see a change in the Create Catalog dialog for creating an instance of an SSIS Catalog using SQL Server Management Studio (SSMS) version 17.9. The “Enable this server as SSIS scale out master” checkbox is now unchecked by default: I’m not sure if this changed in SSMS version 17.9 or an earlier …
Continue reading Change to the SSMS Create Catalog Dialog
Enterprise Data & Analytics and Andy Leonard Consulting
I occasionally get questions about my companies (yes, plural) so I thought I’d write a post explaining them. Enterprise Data & Analytics Enterprise Data & Analytics is a boutique consulting firm. I own the company and I also deliver consulting services. We have a team of experienced engineers who deliver everything from cloud data migrations to …
Continue reading Enterprise Data & Analytics and Andy Leonard Consulting
Agile Bashing
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
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