(2020-Oct-14) Ok, here is my problem: I have an Azure Data Factory (ADF) workflow that includes an Azure Function call to perform external operations and returns output result, which in...
2020-10-23 (first published: 2020-10-15)
229 reads
(2020-Oct-05) Adding a row number to your dataset could a trivial task. Both ANSI and Spark SQL have the row_number() window function that can enrich your data with a unique...
2020-10-12 (first published: 2020-10-05)
300 reads
(2020-Sep-26) Last week one of my Azure Data Factory (ADF) deployment pipelines failed with an error that it couldn’t find some of the deployment parameters that I try to override,...
2020-10-05 (first published: 2020-09-26)
223 reads
(2020-Sep-13) Array of arrays, in a JSON world, it’s a very common concept to have a set of sets of other elements in a dataset. Despite how strange it may...
2020-09-21 (first published: 2020-09-14)
394 reads
(2020-Aug-14) Setting default values for my parameters or variables in Azure Data Factory (ADF) may be a trivial task, but it gets more interesting when those elements are Arrays....
2020-08-25 (first published: 2020-08-14)
477 reads
(2020-July-29) There is a well known and broadly advertised message from Microsoft that Azure Data Factory (ADF) is a code-free environment to help you to create ...
2020-08-07 (first published: 2020-07-29)
536 reads
(2020-June-22) It's a noble act to develop a very cool database solution that will bring value to your customers. In addition to this, you can help...
2020-07-07 (first published: 2020-06-22)
569 reads
(2020-May-24) It has never been my plan to write a series of articles about how I can work with JSON files in Azure Data Factory (ADF). While working with one...
2020-06-09 (first published: 2020-05-24)
1,251 reads
(2020-June-07) It is a very simple concept, you have a database query result, either a direct database table output or a stored procedure returned result that needs ...
2020-06-08
813 reads
(2020-May-01) There is a current limitation in Azure Data Factory (ADF) to accept only two conditions for the OR function.You won't be able to specify the following expression to evaluate...
2020-05-19 (first published: 2020-05-01)
296 reads
By HamishWatson
This blog post lists the reasons why I felt the need to run for...
By gbargsley
Happy Tuesday everyone… In early 2017 I started blogging on this site in hopes...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hello. I have a table (say orderlines) with orderrows, There is a column...
We have 3 sql agent jobs that are running SSIS packages. Until this past...
In the list of connection manager driver, I cannot find MSOLEDBSQL, There is a...
Ask SSC