Kent Bradshaw and I had a blast delivering Loading Medical Data with SSIS earlier today! If you missed the webinar and, perhaps more importanly, coupon codes to save on upcoming Enterprise Data & Analytics Training. Enjoy the video! We demonstrated a handful of (free!) DILM Suite (Data Integration Lifecycle Management) utilities: Catalog Reports SSIS Catalog …
Continue reading The Recording for Loading Medical Data with SSIS is Available
Category:DILM Suite
Free Webinar – Enterprise SSIS Execution
Join Kent Bradshaw and me as we present (another) free Enterprise Data & Analytics webinar Tuesday, 23 Apr 2019 at 12:00 PM EDT: Enterprise SSIS Execution. Abstract SQL Server Integration Services (SSIS) is a powerful enterprise data integration tool that ships free with Microsoft SQL Server. Join Andy Leonard – Microsoft Data platform MVP, author, …
Continue reading Free Webinar – Enterprise SSIS Execution
Regarding SSIS Frameworks, Part 1 – Execution
Why Use a Framework? The first answer is, “Maybe you don’t need or want to use a framework.” If your enterprise data integration consists of a small number of SSIS packages, a framework could be an extra layer of hassle metadata management for you that, frankly, you can live without. We will unpack this in …
Continue reading Regarding SSIS Frameworks, Part 1 – Execution
Honored to Present Intelligent Data Integration at SQL Saturday – Virginia Beach!
SQL Saturday 839 – Virginia Beach has three precons scheduled for 07 June. That’s three opportunities for you to learn from, “A couple really smart people – plus me!” Who are these smart people? Andrew Kelly and John Morehouse will be speaking on Core Level Performance Monitoring and Managing and Architecting Azure Data Platform, respectively. …
Continue reading Honored to Present Intelligent Data Integration at SQL Saturday – Virginia Beach!
Honored to Present Intelligent Data Integration at SQL Saturday – Dallas!
SQL Saturday 841 – Dallas has four precons scheduled for 31 May. Four. If you have ever organized a SQL Saturday or similarly-sized event, you know this takes a lot of hard work. Hat’s off to the organizers! I describe the precon presenters as, “A bunch of really smart people – plus me!” Chris Hyde, …
Continue reading Honored to Present Intelligent Data Integration at SQL Saturday – Dallas!
Lift and Shift SSIS to Azure
Enterprise Data & Analytics‘ data engineers are experts at lifting and shifting SSIS to Azure Data Factory SSIS Integration Runtime. Our state-of-the-art DILM Suite tools in the capable hands of our experienced data engineers combine to drastically reduce the amount of time to manually migrate and apply SSIS Catalog configuration artifacts – Literals, Catalog Environments and Catalog Environment Variables, …
Continue reading Lift and Shift SSIS to Azure
Mean Time to Identify Failure
While managing a team of 40 ETL developers, I wanted to track lots of metrics. Some of the things I wanted to track were technical, like SSIS package execution times. Some metrics were people-centric. Andy’s First Rule of Statistics states: You can use statistics for anything about people, except people. Andy – circa 2005 It was …
Continue reading Mean Time to Identify Failure
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
Catalog Browser v0.7.8.0
I’ve been making smaller, more incremental changes to SSIS Catalog Browser – a free utility from the Data Integration Lifecycle Management suite (DILM Suite). You can use SSIS Catalog Browser to view SSIS Catalog contents on a unified surface. Catalog Browser works with SSIS Catalogs on-premises and Azure Data Factory SSIS Integration Runtime, or Azure SSIS. It’s …
Continue reading Catalog Browser v0.7.8.0
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