Source-Control SSIS Catalog Contents in Azure DevOps

I did a thing – actually a couple things – that I’ve been dreaming about for a while. In a couple recent blog posts – SSIS Catalog Compare Enterprise Generates SCCPAC Files and Azure DevOps, Software Development, and Git Part 4 – Command-Line with Azure DevOps – I walked through one way to source-control the …
Continue reading Source-Control SSIS Catalog Contents in Azure DevOps

Azure DevOps, Software Development, and Git Part 4 – Command-Line with Azure DevOps

I’m writing about my journey with git, sharing my experiences along the way. The series to date: Azure DevOps, SSIS, and Git Part 0 – Getting Started Azure DevOps, Software Development, and Git Part 1 – Applied Azure DevOps, Software Development, and Git Part 2 – Distributed Version Control Azure DevOps, Software Development, and Git …
Continue reading Azure DevOps, Software Development, and Git Part 4 – Command-Line with Azure DevOps

Announcing SSIS Data Flows and Administration Live, Online, Training Courses

I’m excited to announce fresh deliveries of two courses: 08-09 Apr 2020: SSIS Administration 13-14 Apr 2020: SSIS Data Flows Essentially, these courses are the first and second half of From Zero To SSIS. As I type (14 Mar 2020), both courses are on sale! Register for SSIS Data Flows or SSIS Administration today!These courses …
Continue reading Announcing SSIS Data Flows and Administration Live, Online, Training Courses

Four Free ADF Webinars

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

Updating Default SSIS Values in the SSIS Catalog

A couple friends recently contacted me trying to solve a similar issue: how to update parameter values stored in the SSIS Catalog. One of my friends was interested in migrating their SSIS Catalog to a new server and needed to update several default SSIS parameter values stored in the SSIS Catalog. My answer here consists …
Continue reading Updating Default SSIS Values in the SSIS Catalog

In 2020, Two Full Training Days, Two Continents

It dawned on me that I am honored to deliver two full-day conference training presentations in early 2020 on two continents! At the Difinity 2020 conference in Auckland New Zealand, Sandy Winarko and I are co-presenting Intelligent Data Integration with SSIS and Azure Data Factory 20 Feb 2020. Sandy is Principal Program Manager – Azure …
Continue reading In 2020, Two Full Training Days, Two Continents

Honored to Present From Zero to ADF at SQLBits 2020 in London!

Honored to Present From Zero to ADF at SQLBits 2020 in London 1 Apr 2020! When I look at this list of SQLBits Training Day presenters, I think, “Wow! That’s a lot of really smart people… plus me!” Registration is open now. Register today! :{>

PASS Summit 2019, Coming Down

During the PASS Summit 2019, Frank and I worked hard to deliver several DataDriven *DataPoint*’s.Here’s a list: *DataPoint* Andy is on the Way to Seattle for PASS 2019 *DataPoint* Andy Arrives at PASS 2019 *DataPoint* PASS 2019 Welcome Reception *DataPoint* Hanging Out with #SQLGeeks at PASS 2019 *DataPoint* Andy Speaks with SentryOne CEO Bob Potter …
Continue reading PASS Summit 2019, Coming Down

Wrapping up the Summer o’ ADF 2019

As the 2019 Summer o’ ADF 2019 draws to a close, we look forward to shorter and cooler Autumn days (in the northern hemisphere, at least!), conference season, and the fast-approaching holidays. As always, I had an absolute blast sharing tips and tricks for using Azure Data Factory in the enterprise. I must admit that …
Continue reading Wrapping up the Summer o’ ADF 2019

Honored to Present From Zero to ADF at SQL Saturday Atlanta – BI Edition

I am honored to deliver my brand-spanking-new full day pre-conference titled From Zero to ADF at SQL Saturday Atlanta – BI Edition 18 Oct 2019! (It still has that new precon smell!) My precon will be delivered at:Microsoft Avalon8000 Avalon BoulevardSuite 900Alpharetta, GA 30009 Abstract From Zero to ADF is designed to jumpstart data engineering …
Continue reading Honored to Present From Zero to ADF at SQL Saturday Atlanta – BI Edition