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

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

Delivering Intelligent Data Integration through SSIS in Dallas 31 May 2019!

I am honored to announce I will be delivering Intelligent Data Integration through SSIS – a day-long SQL Saturday 841 – Dallas pre-conference session 31 May 2019! Description: What is Intelligent Data Integration? SSIS (SQL Server Integration Services) packages developed using tried and true design patterns, built to participate in a DevOps enterprise practicing DILM (Data …
Continue reading Delivering Intelligent Data Integration through SSIS in Dallas 31 May 2019!

Biml, Book Reviews, and Metadata-Driven Frameworks

I occasionally (rarely) read reviews at Amazon of books I’ve written. If I learn of a complaint regarding the book I often try to help. If a reader experiences difficulty with demos, I often offer to help, and sometimes I meet with readers to work through some difficulty related to the book (as I offered …
Continue reading Biml, Book Reviews, and Metadata-Driven Frameworks

Presenting Moving Data with Azure Data Factory at SQL Saturday Charlotte!

I am honored to present Moving Data with Azure Data Factory at SQL Saturday 806 in Charlotte, NC 20 Oct 2018. This is the first time I am delivering this session. It still has that new presentation smell! Abstract Azure Data Factory – ADF – is a cloud data engineering solution. ADF version 2 sports …
Continue reading Presenting Moving Data with Azure Data Factory at SQL Saturday Charlotte!

On Data Engineering in 2018

A few years ago I had a conversation with Scott Currie, the CEO of Varigence and inventor of Biml. Scott is one of the smartest people I know and I know a lot of very smart people. Whenever I have the opportunity to communicate with the very smart people I know, I often ask them – …
Continue reading On Data Engineering in 2018

Introducing Azure Data Factory Design Patterns

I was honored to write an article titled Introducing Azure Data Factory Design Patterns featured in this month’s PASS Insights newsletter! Introducing Azure Data Factory Design Patterns The article covers a couple execution patterns: Execute Child Pipeline Execute Child SSIS Package I demonstrate a cool SSIS Catalog Browser feature that helps ADF developers configure the Execute SSIS Package activity. To …
Continue reading Introducing Azure Data Factory Design Patterns

Announcing the Fundamentals of Azure Data Factory Course!

I am excited to announce a brand new course (it still has that new course smell) from Brent Ozar Unlimited and honored to deliver it! This one-day, live, online course is titled Fundamentals of Azure Data Factory and it’s designed to introduce you to Azure Data Factory (ADF). There will be demos. Live demos. Lots …
Continue reading Announcing the Fundamentals of Azure Data Factory Course!

Honored to Present Faster SSIS at SQL Saturday Boston 22 Sep 2018!

I am honored to present Faster SSIS at SQL Saturday Boston 22 Sep 2018! Check out this schedule – there are a bunch of smart people presenting – plus me! Abstract Ever wonder why SSIS runs so slow? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data and shows …
Continue reading Honored to Present Faster SSIS at SQL Saturday Boston 22 Sep 2018!

PASS Summit 2018 Starts in 10 Weeks!

Can you believe the PASS Summit 2018 begins only 10 weeks from today (27 Aug 2018)? I confess, this is sneaking up on me fast! I will be there. Will you? Where Can You Find Andy at the PASS Summit 2018? Precon! Monday 5 Nov 2018, I’m delivering a full-day pre-conference session titled Intelligent Data …
Continue reading PASS Summit 2018 Starts in 10 Weeks!