Azure Data Factory Interview Questions and Answers
Get a few common questions and possible answers about Azure Data Factory that you may encounter in an interview.
2022-06-03
4,148 reads
Randheer Parmar
Understanding the Mapping Data Flow Activity in Azure Data Factory
Learn about using Mapping Data Flows in Azure Data Factory.
2022-04-25
6,665 reads
Migrating SSIS packages to Azure - Lift and Shift using Azure Data Factory
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. […]
2021-04-05 (first published: 2021-03-22)
8,916 reads
Using ADF to Upload Disparate CSV Files into Azure MySQL
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
3,172 reads
Blogs
SQL Data Pipelines: The Ultimate Guide to Streamlining Your Data Flow
Want to build a data analytics foundation that transforms raw data into valuable business...
Using SQL Compare in Read-Only Databases
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
T-SQL Tuesday #179 Roundup: The Data Detective Toolkit
By Tim Mitchell
Earlier this month, I hosted the monthly T-SQL Tuesday invitation in which I asked,...
Forums
Date Type ETL Question
I'm not sure that I'm posting this in the right section, so please mods...
Possible oddity in msdb.dbo.backupset
Hi all I've written a script to keep track of how long backups...
Operand data type varchar is invalid for sum operator
I have this view [dbo].[Asset Metrics - Client(Rama -Client-Test)], which makes use of multiple...
Question of the Day
Data Migration Assistant Sources
In the current (Sep 2024) Data Migration Assistant, what are the possible sources for on-premises SQL Server instances?
See possible answers