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 […]

5 (2)

You rated this post out of 5. Change rating

2021-04-22

29,510 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. […]

5 (2)

You rated this post out of 5. Change rating

2021-04-05 (first published: )

9,137 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 […]

5 (1)

You rated this post out of 5. Change rating

2021-03-04

3,216 reads

Blogs

Knoxville M365 Community Days Recap

By

Hello data friends! Had a blast at my first ever M365 Community Day this...

What is Deferred Name Resolution?

By

One interesting concept in SQL Server is Deferred Name Resolution. This is something many...

SQL Server Time Bombs

By

Common Reasons for Emergency SQL calls If you are a production DBA (or Accidental...

Read the latest Blogs

Forums

List the Databases To Which You Have Access

By rathiaakash91@gmail.com

Comments posted to this topic are about the item List the Databases To Which...

Deadlocks after index rebuild

By btork

We rebuilt a bunch of indexes that had avg_fragmentation_in_percent>30. Now we have 1 job...

SSIS (Integration Services) - "External table is not in the expected format"

By Reh23

Good Afternoon. I have been manually running an SSIS package on an adhoc basis,...

Visit the forum

Question of the Day

Dateadd with a numeric value

What is returned from the following query ?

declare @currentDateTime DATETIME = '2025-01-01 00:00:00.000'

select  dateadd(hour, 3.0/2, @currentDateTime);

See possible answers