2019 – A Blog in Review

I write this 12 Dec 2019. Thus far in 2019 – 348 days in, counting this post – I’ve posted 124 posts at andyleonard.blog(). Roughly, that’s one post every three (~2.8) days. According to the WP-Statistics plugin, this blog has had just under 60k visitors and you have visited over 155k pages year-to-date. From the …
Continue reading 2019 – A Blog in Review

Public Preview – SSIS Azure DevOps Build and Deploy Tasks

Microsoft announces the public preview for SSIS Azure DevOps Tools, which includes the SSIS Build and SSIS Deploy Azure DevOps tasks! I was honored to present Azure DevOps and the SSIS Development Lifecycle at the PASS Summit 2019 where I demonstrated these new tasks in action. Check them out! :{>

My PASS Summit 2019 Presentations

SSIS DevOps and Azure Containers I was honored to co-present SSIS DevOps and Azure Containers with Sreeja Pullagura and Elizabeth Baron. Liz and Sreeja work for Teach for America, a really cool non-profit headquartered in NYC. This was their very first time presenting at the PASS Summit. We were even featured on PASStv! . You …
Continue reading My PASS Summit 2019 Presentations

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

DILM Suite Applications

‘Twas the Saturday before the PASS Summit 2019 and all through Andy’s office… During my Azure DevOps and the SSIS Development Lifecycle presentation I may have an opportunity to demonstrate some DILM Suite applications: SSIS Catalog Browser, SSIS Framework Community Edition, SSIS Framework Browser, and Catalog Reports. All four applications are free. SSIS Framework Community …
Continue reading DILM Suite Applications

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

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