Last August, I had a blast at the Data Platform Summit 2018 in Bengaluru, India. One highlight of the trip was meeting and conversing with the Azure Data Factory SSIS Integration Runtime Product/Program Manager, Sandy Winarko. Sandy and I swapped coder stories and talked about data integration design patterns and I learned a few new …
Continue reading Start Azure-SSIS, Execute Package, Stop Azure-SSIS
Author:Andy Leonard
Christian, husband, dad, grandpa, Data Philosopher, Data Engineer; Azure Data Factory, Fabric Data Factory, and SSIS guy; and farmer. I was cloud before cloud was cool. :{>
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
Updates to the ADF Execute SSIS Package Activity
Last night I presented Moving Data with Azure Data Factory to a packed house at the Richmond Azure User Group. The crowd was engaged and asked awesome questions. I had a blast! Surprise! I rehearsed many of my demos before the presentation and even updated my slides. One thing I did not do was rehearse configuring an …
Continue reading Updates to the ADF Execute SSIS Package Activity
New Trusted Site Required when Connecting to Azure SQL DB
I got pinged about a new trusted site requirement when I tried to connect to Azure SQL DB this morning. https://aadcdn.msftauth.net is the URL. I added the URL to Internet Explorer’s Trusted Sites: I was then able to connect to Azure SQL DB and add a rule for my IP using SQL Server Management Studio (SSMS).
SSIS Catalog Compare Version 4 – Three Videos
I am excited to announce general availability of SSIS Catalog Compare version 4! I made three short-ish (~2 minutes each) videos demonstrating some of the capabilities of the product. I really like the SCCPAC files and SCCPAC Deployment Wizard, which are only available in the Enterprise Edition. Use SCCPAC Deployment Wizard to Lift and Shift …
Continue reading SSIS Catalog Compare Version 4 – Three Videos
T-SQL Tuesday #111 – What is Your “Why?”
“Why do you do what you do?” This month’s T-SQL Tuesday topic by Andy Leonard.
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!
Lift and Shift is Not a Strategy…
Lift and shift is a bridge. If your enterprise is considering migrating enterprise data and data integration workloads from on-premises to the cloud, lifting and shifting is not the end of the story. Lifting and shifting is, rather, the mechanism – the conversion project – that positions your enterprise to leverage the economies of scale …
Continue reading Lift and Shift is Not a Strategy…
Enterprise Data & Analytics Welcomes Shannon Lowder!
I am honored and thrilled to welcome Shannon Lowder (@shannonlowder | blog | LinkedIn) to the Enterprise Data & Analytics team! Shannon is a data engineer, data scientist, BimlHero (though not listed on the page at the time of this writing), and shepherd of the Biml Interrogator open source project. If you use Biml to generate SSIS …
Continue reading Enterprise Data & Analytics Welcomes Shannon Lowder!
Grant SSIS Catalog Read-Only Permissions
The SSIS Catalog has built-in security to manage permissions. SSISDB – the database behind the SSIS Catalog – is “just a database” in many respects. When it comes to security, the SSIS Catalog surfaces an internal mechanism that provides granular permissions management. In this post I intend to demonstrate how to use SSIS Catalog security to …
Continue reading Grant SSIS Catalog Read-Only Permissions