I just finished removing the latest appointment to attend an event from my calendar. A lot of awesome community events are being postponed or canceled. Let’s face it: the news stinks these days. What can we do about it? We can have free webinars online! Let’s Do This! Enterprise Data & Analytics is excited to …
Continue reading Four Free ADF Webinars
Category:SSIS Catalog Compare
Overcome Challenges of Lifting and Shifting SSIS to Azure
Enjoy this recording of a free webinar titled Overcome Challenges of Lifting and Shifting SSIS to Azure! In this webinar, I demonstrated challenges of scripting SSIS Catalog Environments, Environment Variables, References, Reference Mappings, and Literals for deployment to another SSIS Catalog. These challenges are particularly troublesome when practicing Lifecycle Management or DevOps with SQL Server …
Continue reading Overcome Challenges of Lifting and Shifting SSIS to Azure
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
Honored to Present Lift and Shift SSIS to ADF at #Azure DataFest Reston
I am honored to deliver Lift and Shift SSIS to ADF at the Azure DataFest in Reston Virginia 11 Oct 2018! Abstract Your enterprise wants to use the latest cool Azure Data Analytics tools but there’s one issue: All your data are belong to the servers on-premises. How do you get your enterprise data into …
Continue reading Honored to Present Lift and Shift SSIS to ADF at #Azure DataFest Reston
Free Stuff for People Who Give Back: Announcing 2019 Scholarships
Do you work for a charity or non-profit organization? Submit your application today. I haven’t advertised this in the past and… I’m not sure why: I donate licenses for SSIS Catalog Compare and (non-free) SSIS Framework Editions – and subscriptions to Biml Academy and SSIS Academy – and Enterprise Data & Analytics Training – to individuals who …
Continue reading Free Stuff for People Who Give Back: Announcing 2019 Scholarships
Announcing the Fundamentals of Azure Data Factory Course!
I am excited to announce a brand new course (it still has that new course smell) from Brent Ozar Unlimited and honored to deliver it! This one-day, live, online course is titled Fundamentals of Azure Data Factory and it’s designed to introduce you to Azure Data Factory (ADF). There will be demos. Live demos. Lots …
Continue reading Announcing the Fundamentals of Azure Data Factory Course!
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
SSIS Catalog Compare Documentation is Available
I’m excited to announce the availability of SSIS Catalog Compare Documentation! And now, it’s free!
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
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