Using Stored Procedure in Azure Data Factory
In recent posts I’ve been focusing on Azure Data Factory. Today I’d like to talk about using a Stored Procedure as a sink or...
Azure Data Factory Event Triggers
If you’re still triggering your ETL processes on a schedule (maybe once an hour or at a set time each night), I want to...
Azure Data Factory Pipeline Templates
If you’re new to Azure Data Factory and unsure what you can do with it, I want to tell you about a new option within Data...
Database Properties in Visual Studio Database Projects
Do you work in Visual Studio for development of SQL Server databases? At Pragmatic Works, we’re big fans using SQL Server...
What is Microsoft Graph?
In today’s post, I’d like to introduce you to Microsoft Graph. Microsoft Graph is an API that you can use to connect to...
The Difference Between Elastic Pools and Elastic Queries
Do you get elastic pools and elastic queries confused within Azure SQL Database? Many people do, probably because of the...
Using Databricks in Azure Data Factory for ETL
A common discussion we’ve had lately is about using Azure Databricks within Azure Data Factory for ETL.
ETL in Power BI with Dataflow
In this post, I want to tell you about a feature of Power BI that is in preview called Dataflow and how we can use that to...
Leave a comment