Dear Speaker, Your Time is Up

Peeves make lousy pets, but I own a few nonetheless. One of my pet peeves is speakers who run long when presenting at conferences. I’m not sure what the speakers are thinking. I can share a few things I’ve heard them say: “I must share this thing I didn’t get to yet, it’s n slides …
Continue reading Dear Speaker, Your Time is Up

Free Webinar: Using the Azure Data Factory If Condition and Web Activities

The summer o’ ADF continues with another free webinar from Enterprise Data & Analytics Friday, 14 Jun 2019 at 12:00 PM EDT: Using the Azure Data Factory If Condition and Web Activities! Abstract Join Microsoft Data Platform MVP and author Andy Leonard for 30 minutes packed with demos. In this session, Andy walks through using …
Continue reading Free Webinar: Using the Azure Data Factory If Condition and Web Activities

Using Azure Resource Manager Templates with Azure Data Factory

Azure Resource Manager, or ARM, “allows you to provision your applications using a declarative template.” So says the Azure Quickstart Templates page. ARM templates are JSON and allow administrators to import and export Azure resources using varying management patterns. I really like ARM templates for implementing infrastructure as code in Azure. In this post I …
Continue reading Using Azure Resource Manager Templates with Azure Data Factory

Summer.ADF.2019(): Kicking off the Summer of Azure Data Factory 2019!

I’m excited to kick off the 2019 Summer o’ ADF! My plan is to tag each post Summer.ADF.2019 and update this post with links to the series: Using Azure Resource Manager templates with Azure Data Factory

The Recording of Build and Load a Staging Database with Biml

The recording of Enterprise Data & Analytics’ free webinar titled Build and Load a Staging Database with Biml is available! Get the Code! Download the SSIS solution files here: Load AdventureWorks2017_Stage – version 0 Load AdventureWorks2017_Stage – version 1 Load WideWorldImporters Want More? Learn more from Andy Leonard and the professionals at Enterprise Data & …
Continue reading The Recording of Build and Load a Staging Database with Biml

Free Webinar: Using the Azure Data Factory Lookup and ForEach Activities

Join me Wednesday 05 Jun 2019 for the next free webinar from Enterprise Data & Analytics titled Using the Azure Data Factory Lookup and ForEach Activities! Abstract In this demo-tastic presentation, Microsoft Data Platform MVP and author Andy Leonard walks through loading a dataset using the Lookup Activity, followed by iterating dataset values using a …
Continue reading Free Webinar: Using the Azure Data Factory Lookup and ForEach Activities

SSIS in Visual Studio 2019

If you’re using Visual Studio 2019 with SSIS, you may encounter an error or two when you start. One error is “incompatible” tacked onto the name of your SSIS project in parentheses: Another error you may encounter is found in the Migration Report, a local htm file that contains information about the the attenpted Visual …
Continue reading SSIS in Visual Studio 2019

SSIS in SSMS Version 18: Try SSIS in Azure Data Factory

There’s a new option when you right-click the Integration Services Catalogs node in SSMS v18: “Try SSIS in Azure Data Factory”: Clicking the “Try SSIS in Azure Data Factory” option in SSMS v18 opens the (new) Integration Runtime Creation Wizard (ISIRCreationWizard.exe, which is found in the <installation drive>:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\Binn directory): …
Continue reading SSIS in SSMS Version 18: Try SSIS in Azure Data Factory