Azure Data Factory

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)

2021-04-22

3,412 reads

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)

2021-04-05 (first published: )

3,197 reads

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

2021-03-04

1,641 reads

Blogs

Architect a disaster recovery for SQL Server on AWS: Part 1

By

  New blog post - Architect a disaster recovery for SQL Server on AWS: Part...

Seamlessly migrate large SQL databases using AWS Snowball and AWS DataSync.

By

New blog post - Seamlessly migrate large SQL databases using AWS Snowball and AWS...

Daily Coping 3 Aug 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

FOR JSON command adding carriage return to output

By fxferguson

I'm pretty new a creating JSON output form SQL server. I'm having trouble with...

Create a delta from downloaded info

By Bruin

I'm looking for some suggestions on how to create a delta file that will...

Last Time Stored Procedure Ran ?

By homebrew01

Hi, I've found several examples using dm_exec_procedure_stats but the results are only useful  as...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers