Azure Data Factory

SQLServerCentral Article

Dynamically Add a Timestamp To Files in Azure Data Factory

  • Article

This article will describe how to add your local timestamp at the end of the each file in Azure Data Factory (ADF). In general, ADF gets a UTC timestamp, so we need to convert the timestamp from UTC to EST, since our local time zone is EST. For example, if the input Source file name […]

(2)

You rated this post out of 5. Change rating

2021-04-22

30,359 reads

SQLServerCentral Article

Migrating SSIS packages to Azure - Lift and Shift using Azure Data Factory

  • Article

Unlike an on premises SQL Server, Integration Services (SSIS) works very differently on Azure. If there are requirements to run our existing SSIS packages on Azure, then we need to understand our options. In this article we will talk about our options for migrating SSIS to Azure and what components are required to migrate SSIS packages. […]

(2)

You rated this post out of 5. Change rating

2021-04-05 (first published: )

9,889 reads

SQLServerCentral Article

Using ADF to Upload Disparate CSV Files into Azure MySQL

  • Article

In this article our objective is to showcase how to leverage Azure Data Factory (ADF) and a custom script to upload data in Azure MySQL database when we have CSV files with different schemas. As there is no straightforward way to upload data directly using ADF for this given scenario, it will actually help to […]

(1)

You rated this post out of 5. Change rating

2021-03-04

3,300 reads

Blogs

Monday Monitor Tips: Virtual Machine Usage and Cost

By

One of the things I’ve been requesting for a number of years is cost...

Advice I Like: Respect

By

“Don’t aim to have others like you; aim to have them respect you.” –...

Blue Sky Programming – The Optimism Trap

By

Many years ago, before I joined Oracle, I was working on a major modernisation...

Read the latest Blogs

Forums

SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About

By Terry Jago

Comments posted to this topic are about the item SQL Art, Part 4: Happy...

SQL Server Still Wins

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server Still Wins

DBCC CHECKDB Limits I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DBCC CHECKDB Limits I

Visit the forum

Question of the Day

DBCC CHECKDB Limits I

When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?

See possible answers