My Day – Thursday, 19 Jul 2018 – #SQLCareer

#SQLCareer post for Thursday, 19 Jul 2018 4:26 – 5:30 AM – Wake up (beating the alarm), weigh in, pray, read the Bible, coffee, check the burn barrel. Christy and I have been on a keto diet since 5 Mar. I started out at 238 pounds. This morning I weigh 199 pounds. I’ve been bouncing …
Continue reading My Day – Thursday, 19 Jul 2018 – #SQLCareer

One Solution to Presentation Categories

I’ve shared suggestions for improving presentation categories: One Solution to Presentation Levels One Solution to Presentation Tracks My chief concern is the scalar nature of the selections (the “Naked Scalar”). As I pointed out in both posts, I’ve been delivering presentations to the SQL Server Community for more than a decade and I’ve never – …
Continue reading One Solution to Presentation Categories

Announcing SSIS Academy!

I’m pleased to announce the availability of SSIS Academy! I have a confession: Late last year when I wrote a post titled The Second-Best Time, I was writing to yours truly. I was inspired by some friends and presenters I met at the PASS Summit 2017. I jotted down some notes – just like I …
Continue reading Announcing SSIS Academy!

Biml Academy – Using Biml to Build a Target Database

Using Biml to Build a Target Database is the latest unit available at Biml Academy. You can see a description of Using Biml to Build a Target Database at the link above, but I ask you to consider Basic Biml Training – which includes: Using Biml to Build a Target Database Adding Your First BimlScript Build …
Continue reading Biml Academy – Using Biml to Build a Target Database

DILM Suite + Azure Data Factory Integration Runtime

DILM Suite was designed to support enterprise data engineering / data integration with SSIS. But the solutions, utilities, and tools work well with Azure Data Factory Integration Runtime (ADF IR, or “SSIS in the cloud”). As I mentioned in my post titled The Cloud Costs Money, leaving ADF Integration Runtime running can get pricey – …
Continue reading DILM Suite + Azure Data Factory Integration Runtime

The Recording for Designing a Custom ADF SSIS Execution Framework is Available

The recording the Summer-O’-ADF webinar titled Designing a Custom ADF SSIS Execution Framework is now available (registration required)! Enjoy! :{>  

SSIS Catalog Compare vNext Preview

I am happy to announce that the next version of SSIS Catalog Compare is officially in Preview! What exactly does “Preview” mean? I’m glad you asked. It means I am sharing copies of SSIS Catalog Compare with users of the current version to get their feedback, find bugs, and help identify improvements. Here’s a screenshot: …
Continue reading SSIS Catalog Compare vNext Preview

Updates to Three DILM Suite Applications

It’s been a busy couple weeks here at Enterprise Data & Analytics in Farmville. I just published updates to not one, not two, but three – yes, three! – applications that are part of the Data Integration Lifecycle Management Suite, or DILM Suite. SSIS Framework Community Edition To prepare for Thursday’s (12 Jul 2018) webinar titled …
Continue reading Updates to Three DILM Suite Applications

Free Webinar – Use SSIS Catalog Compare to Lift and Shift SSIS to ADF

I’m excited to announce the next free webinar in the Summer-O’-ADF series: Use SSIS Catalog Compare to Lift and Shift SSIS to ADF! Consider… Your enterprise uses Microsoft SQL Server so the powers-that-be asked the good people at Microsoft to demonstrate the latest and greatest Azure coolness. Due to competition on cost and time to …
Continue reading Free Webinar – Use SSIS Catalog Compare to Lift and Shift SSIS to ADF

The Recording for ADF Controller Design Pattern with the SSIS Integration Runtime is Available

The recording for the latest episode of the Summer-O’-ADF – ADF Controller Design Pattern with the SSIS Integration Runtime – is now available (registration required)! Enjoy!