Getting Started with Azure Automation

Azure Automation has been around for a few years now. I just got started because my brother and friend, Aaron Nelson (@SQLvariant), shared some automation he’s been working on. Once I got my head around the piece I’m about to share with you, Azure Automation started to make sense to me. Set Up an Azure …
Continue reading Getting Started with Azure Automation

Presenting Master the Fundamentals of ADF at SQL Saturday Boston!

I am honored to deliver Master the Fundamentals of ADF at SQL Saturday Boston 2022 (#1031) 7 Oct 2022! Abstract Azure Data Factory, or ADF, is an Azure PaaS (Platform-as-a-Service) that provides hybrid data integration at global scale. Use ADF to build fully managed ETL in the cloud – including SSIS. Join Andy Leonard – …
Continue reading Presenting Master the Fundamentals of ADF at SQL Saturday Boston!

One Way to Create an Azure Integration Runtime

Many Azure Data Factory developers recommend creating an Azure Integration Runtime for use with Mapping Data Flows. Why? One reason is you cannot configure all the options in the default AutoResolveIntegrationRuntime supplied when an Azure Data Factory instance is provisioned. At the time of this writing, it’s not obvious how one creates an Azure Integration …
Continue reading One Way to Create an Azure Integration Runtime

My Black Friday 2020 Sale is On!

Do you read my blog? Would you like to save money on Azure Data Factory and SSIS training (from me!) for a full year? For a limited time, you can save $4,000 (67%) on my Live ADF and SSIS Class Season Pass! Visit Enterprise Data & Analytics Training to view upcoming public course deliveries and …
Continue reading My Black Friday 2020 Sale is On!

In 2020, Two Full Training Days, Two Continents

It dawned on me that I am honored to deliver two full-day conference training presentations in early 2020 on two continents! At the Difinity 2020 conference in Auckland New Zealand, Sandy Winarko and I are co-presenting Intelligent Data Integration with SSIS and Azure Data Factory 20 Feb 2020. Sandy is Principal Program Manager – Azure …
Continue reading In 2020, Two Full Training Days, Two Continents

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

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

PASS Summit 2019 Presentations

SSIS DevOps and Azure Containers I am preparing for an exciting week in Seattle! This year I have the honor of co-presenting SSIS DevOps and Azure Containers with Elizabeth Baron and Sreeja Pullagura, two (really) smart architects who work together at Teach For America – an awesome non-profit in New York. Catch us Wednesday, 6 …
Continue reading PASS Summit 2019 Presentations