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

For a Limited Time: Use SSIS Catalog Browser to Manage DtsConfig Files

For a limited time, I am making DtsConfig Management – a feature of SSIS Catalog Compare – available in the latest (free) version of SSIS Catalog Browser. Am I awesome? Well, no. I am not awesome. This feature could use more testing. I can hear some of you thinking,… “Why Do I Need to Manage …
Continue reading For a Limited Time: Use SSIS Catalog Browser to Manage DtsConfig Files

SSIS Catalog Browser v0.9.2.1

I added Catalog Statistics to the latest version of SSIS Catalog Browser – version 0.9.2.1. I like the idea for a number of reasons but I am definitely biased; I built it. There are additional improvements over the previous release, but the improved performance from v0.9.1.0 is still there. Take SSIS Catalog Browser version 0.9.2.1 …
Continue reading SSIS Catalog Browser v0.9.2.1

Announcing SSIS Catalog Browser v0.9.1.0

I am excited to announce a fairly substantial update to SSIS Catalog Browser! What’s New? In a word, speed. The #1 complaint I received from customers using previous versions of SSIS Catalog Browser – especially customers with more than a few SSIS packages and projects in their SSIS Catalog – was related to the amount …
Continue reading Announcing SSIS Catalog Browser v0.9.1.0

Honored to Present Azure DevOps and the SSIS Development Lifecycle at Hampton Roads SQL Server User Group 15 Jan 2020!

I am honored to present Azure DevOps and the SSIS Development Lifecycle at Hampton Roads SQL Server User Group 15 Jan 2020! The primary goal of this session is an explanation – via demonstration – of the production release of an SSIS Project. We will walk this project through lifecycle management using Azure DevOps – …
Continue reading Honored to Present Azure DevOps and the SSIS Development Lifecycle at Hampton Roads SQL Server User Group 15 Jan 2020!

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! :{>

My PASS Summit 2019 Presentations

SSIS DevOps and Azure Containers I was honored to co-present SSIS DevOps and Azure Containers with Sreeja Pullagura and Elizabeth Baron. Liz and Sreeja work for Teach for America, a really cool non-profit headquartered in NYC. This was their very first time presenting at the PASS Summit. We were even featured on PASStv! . You …
Continue reading My PASS Summit 2019 Presentations

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

DILM Suite Applications

‘Twas the Saturday before the PASS Summit 2019 and all through Andy’s office… During my Azure DevOps and the SSIS Development Lifecycle presentation I may have an opportunity to demonstrate some DILM Suite applications: SSIS Catalog Browser, SSIS Framework Community Edition, SSIS Framework Browser, and Catalog Reports. All four applications are free. SSIS Framework Community …
Continue reading DILM Suite Applications

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