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

PowerShell and Azure: AzureRM vs. Az

Earlier this year Microsoft announced the new Azure PowerShell Az Module. I recently encountered the following reminder when doing research: The part that caught my attention is: You can still use the AzureRM module, which will continue to receive bug fixes until at least December 2020. from https://docs.microsoft.com/en-us/azure/storage/blobs/storage-quickstart-blobs-powershell#prerequisites Consider this a 13-month heads-up… :{>

Embed an SSIS Package in an Azure Data Factory Pipeline

The Azure-SSIS Team has done it again; they’ve added more cool SSIS execution functionality to Azure Data Factory! Execute SSIS Package Activity Update First, add an Execute SSIS Package Activity in an Azure Data Factory pipeline. On Settings, select an Azure-SSIS Integration Runtime. Set Package Location to “Embedded package”: The Execute SSIS Package activity’s properties …
Continue reading Embed an SSIS Package in an Azure Data Factory Pipeline

Learn Azure Part 0 – Create an Azure Account

If you are interested in learning Azure, cool! I am here to help.™ Let’s begin by thinking about this journey accurately: Azure is not easy. Azure is not simple. Learning Azure will take time. You will experience frustration. Sounds awesome, right?! The preceding list is the bad news. There is good news, though: If learning …
Continue reading Learn Azure Part 0 – Create an Azure Account

Presenting Moving Data with ADF at TriPASS 20 Aug

I am honored to deliver Moving Data with ADF to the Triangle SQL Server Users Group (TriPASS) 20 Aug 2019 starting at 6:00 PM EDT! This event will be streamed live via Twitch. Abstract Azure Data Factory – ADF – is a cloud data engineering solution. ADF version 2 sports a snappy web GUI (graphical …
Continue reading Presenting Moving Data with ADF at TriPASS 20 Aug

SSIS Is Not Dead (Or Dying)

A few weeks ago I began hearing a rumor that SSIS had a couple years of life remaining. “In two years or so,” according to the rumor, “SSIS will die and be replaced with Azure Data Factory.” Is Microsoft capable of such a move; deprecating a technology? Yep. Remember SQL Server Notification Services? I can …
Continue reading SSIS Is Not Dead (Or Dying)

“It’s Past 10 July 2019 and We Still Have SSIS 2008 in Production…”

I am writing this post 10 Jul 2019. Yesterday, support ended for SQL Server 2008 and 2008 R2. Many are still running SQL Server 2008 and 2008 R2 in production, and many are using SSIS 2008 and 2008 R2 in production as well. If you are reading this post and thinking or saying, “Yep. He’s …
Continue reading “It’s Past 10 July 2019 and We Still Have SSIS 2008 in Production…”

Azure-Enabled SSIS Projects

The Azure-SSIS Team recently released an update to the Integration Services Extension. The update includes a new project template named “Integration Services Project (Azure-Enabled)”. The functionality is driven by another recent addition to Azure-SSIS; the ability to execute SSIS packages from Azure File Shares. I refer to this as “Azure-SSIS (Files)”. I’ve written and presented …
Continue reading Azure-Enabled SSIS Projects

Free Webinar: Azure Data Factory, Azure-SSIS, and Pipeline Parameters

UPDATE: You may view the recording of this webinar at Azure Data Factory, Azure-SSIS, and Pipeline Parameters Recording. Enjoy! :{> Join me 8 Jul 2019 at 12:00 PM EDT for another free Enterprise Data & Analytics webinar titled Azure Data Factory, Azure-SSIS, and Pipeline Parameters! In this free webinar, we build on the demonstration from …
Continue reading Free Webinar: Azure Data Factory, Azure-SSIS, and Pipeline Parameters