What’s the Best Book for Learning SSIS?

I am often asked the question, “Andy, what’s the Best Book for Learning SSIS?” There are some really good books out there that will help you learn SSIS (and I am co-author of several). The book from which I learned the most about SSIS is Extending SSIS 2005 with Script by Donald Farmer. Why do …
Continue reading What’s the Best Book for Learning SSIS?

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

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

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

100 Dumb Little Things

Software development is hard. It takes time, yes. But more than that, software development takes patience and thought and blood and sweat and love and tears. My friends at Varigence recently released an update to their Business Intelligence Markup Language (Biml) products. If you’re into business intelligence or data science, integration, or engineering, you should …
Continue reading 100 Dumb Little Things

It’s Biml 2018 Release Day!

Scott Currie and the team at Varigence announce the release of BimlFlex 2018, BimlStudio 2018, and BimlExpress 2018! This much-anticipated release includes awesome features for experienced Biml professionals as well as for data engineers new to automating processes! BimlFlex 2018 BimlFlex is a mature and complete data engineering automation framework. Out of the box, BimlFlex …
Continue reading It’s Biml 2018 Release Day!

SSIS Catalog Browser v0.6.4.0 Released

“There I was…” happy as a clam, rolling right along in my free webinar titled “Introduction to Lifting and Shifting SSIS to the Cloud” (you can view the recording if you missed it [registration required]). I opened Catalog Browser to show off this free utility from DILM Suite and “Guess what my code did?” “Exactly what you …
Continue reading SSIS Catalog Browser v0.6.4.0 Released

Free Webinar – The Azure Data Factory Controller Design Pattern – 28 Jun

Andy’s Summer-o’-ADF continues with another free (yes, FREE) webinar!   Abstract Join me as I begin to explore a brand new topic: Azure Data Factory Design Patterns. This first webinar in the series is titled The Azure Data Factory Controller Design Pattern. In this demo-tastic session I show how to apply the pattern described in …
Continue reading Free Webinar – The Azure Data Factory Controller Design Pattern – 28 Jun

The Recording for Introduction to Lifting and Shifting SSIS to the Cloud is Now Available

  The recording of my free webinar – Introduction to Lifting and Shifting SSIS to the Cloud – is now available (registration required). Abstract How does an enterprise lift and shift SSIS projects from SSIS Catalogs on-premises to the Azure Data Factory Integration Runtime? What are the best practices? Do SSIS lifecycle management tools exist to …
Continue reading The Recording for Introduction to Lifting and Shifting SSIS to the Cloud is Now Available