How to enable Azure DevOps. A step-by-step tutorial for enabing Azure DevOps in Azure Synapse Analytics. Also works for Azure Data Factory.
Managed Identities and Azure Data Factory
Use Azure Managed Identities to stop embedding credentials when building solutions with Azure Service. How to use Managed Identities in ADF and ASA Workspaces.
Update Demo AdventureWorks DW Database with New Dates
Update the dates in your AdventureWorks Data Warehouse demo database with this script. Don’t get stuck with data from 2014!
Azure Data Factory SSIS
How to execute SQL Server Integration Services packages in Azure Data Factory and set up an Azure Data Factory SSIS Runtime (IR).
Azure Data Factory Refreshing Azure Analysis Services Model
Are you looking to easily refresh your Azure Analysis Service models from Azure Data Factory? Find out how easy it is in this post.
Azure Data Factory Pipelines
Learn about the key differences between Azure Data Factory Pipelines, data flows and SSIS Integration Runtime and when to choose each one.
ETL VS ELT
The key differences of ETL (Extract-Transform-Load) vs ELT (Extract-Load-Transform). Learn which design approach to follow based on your requirements.
Azure Data Factory Introduction
A comprehensive guide to Microsoft Azure Data Factory including the key advantages and disadvantages of using this service. Great for beginners to learn more about the service.