Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,861 questions
1 answer
One of the answers was accepted by the question author.
Copy activity configuraion showing diffrent values
Hi Please find the screenshot where copy activity audit details, in that photo total time for 'reading from source' and 'write to sink' having less than one minute. But total duration showing 10min
asked 2021-01-07T06:30:23.307+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 54%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETG%3C/text%3E%3C/svg%3E)
THIMMAIAH GARI,PRASHANTH,,
201
Reputation points
accepted 2021-01-13T08:18:26.277+00:00
THIMMAIAH GARI,PRASHANTH,,
201
Reputation points
2 answers
How to use String.Format in PowerShell?
Hah! (We’re back ;-) ) It’s as easy as that: PS > [string] :: Format( "Hello {0} {1} :-)", "Rahul", "Singh") Hello Daniel Walzenbach :-) Needless to say that other formatting – like Currency formatting – works as…
Microsoft Edge
Microsoft Edge
A Microsoft cross-platform web browser that provides privacy, learning, and accessibility tools.
2,359 questions
asked 2020-08-12T03:14:32.963+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 1%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Rahul Singh
1
Reputation point
answered 2021-01-13T08:16:55.337+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 65%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBV%3C/text%3E%3C/svg%3E)
Bart van den Donk
1
Reputation point
1 answer
Shedule an exam from different country
Dear Team, Currently I'm sri lankan citizen and most of the exam fee is 80$. But my question is if I travel different country and schedule an exam, still may I allow to book the exam as a srilankan citizen. Tharindu.
Microsoft Edge
Microsoft Edge
A Microsoft cross-platform web browser that provides privacy, learning, and accessibility tools.
2,359 questions
asked 2021-01-13T07:10:43.42+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 57.99999999999999%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETW%3C/text%3E%3C/svg%3E)
Tharindu Weerakoon
1
Reputation point
answered 2021-01-13T08:10:23.71+00:00
Vaibhav Chaudhari
38,746
Reputation points
2 answers
Lync environment access from public ip
We are using lync server in production, Domain Controller Lync Front-End Server on Windows Server 2012r2 standard SQL 2012 std for monitoring and persistent chat on Windows Server 2012r2 Exchange 2016 on Windows Server 2016 Lync…
asked 2020-12-24T15:27:54.14+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 44%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Suy Peang
91
Reputation points
commented 2021-01-13T08:08:43.417+00:00
Sharon Zhao-MSFT
25,101
Reputation points Microsoft Vendor
1 answer
Error writing to Datalake Gen 2
Hello, my Source is a SQL Server, queried with a Self Hosted IR Runtime and my sink is a Datalake Gen 2, I get the following Error Failure happened on 'Sink' side.…
asked 2020-12-23T21:52:39.017+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 1%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Silvano P
101
Reputation points
commented 2021-01-13T08:06:46.717+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 9%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HarithaMaddi-MSFT
10,136
Reputation points
1 answer
COPY Activity very slow
Hi All, In my pipe line i have 40 COPY Activities. All are copying data from the files in ADLS Gen2 into SQLMI . All except one COPY is taking 2 hours, while the rest are getting done in few minutes. I compared the files sizes and files bigger than…
asked 2021-01-08T17:02:30.603+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 7.000000000000001%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
bk
466
Reputation points
commented 2021-01-13T08:01:19.57+00:00
HarithaMaddi-MSFT
10,136
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure Sentinel (IIS, SQL, Syslog server)
Hello, I am new to Azure Sentinel - so i need to implement this solution. So basically i need to collect logs from Active Directory, IIS, SQL Server make SYSLOG (linux) server which will collect Windows Firewall Logs and then send it's to Syslog…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 39%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
2 answers
Can the accounts uploaded to azure be synchronized to the on-premises environment?
We are trying to manage it as a hybrid due to security concerns. So, I want to synchronize the user accounts in the cloud to the on-premises ad environment. Is this possible with the ad connecter?
asked 2021-01-13T06:35:00.84+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 9%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHL%3C/text%3E%3C/svg%3E)
hyunsoo.lee
1
Reputation point
answered 2021-01-13T07:57:33.523+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 42%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
mirba-msft
651
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure Data Factory Issue: How to parametrise a custom activity and link an event-based trigger
Hello, I am trying to parametrise a custom activity of Azure Data Factory (ADF) so that it can take in inputs from the event based trigger (folder name and file name). I have tried to follow the following demos: …
asked 2021-01-08T23:48:45.183+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 96%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Sampat, Varun
231
Reputation points
commented 2021-01-13T07:55:03.727+00:00
HarithaMaddi-MSFT
10,136
Reputation points
2 answers
One of the answers was accepted by the question author.
TS Ports on Server 2012 Standard
I run windows 2012 standard on my server at home, I have a TeamSpeak 3 server as well as no-ip (DUC (Dynamic Update Client)) program running on it, I have two pc's running windows 10 pro on the network as well as 3 phones and 2 smart watches, (2 Android,…
asked 2021-01-08T08:21:28.68+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 87%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDV%3C/text%3E%3C/svg%3E)
Derik Venter
21
Reputation points
accepted 2021-01-13T07:54:08.187+00:00
Derik Venter
21
Reputation points
1 answer
Microsoft Defender for Office 365
We have been working with Microsoft Defender for Office 365 for several months now. During that time we have had a couple of instances where a messages has been picked up by the service and quarantined. However the recipient concerned has still…
asked 2021-01-12T10:23:40.74+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 14.000000000000002%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Michele Green
1
Reputation point
answered 2021-01-13T07:44:30.693+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 50%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJY%3C/text%3E%3C/svg%3E)
Jenny Yan-MSFT
9,336
Reputation points
1 answer
One of the answers was accepted by the question author.
Migrate VMs from one subscription to another
We want to migrate Azure resources (VMs, Cosmos, Sql server) etc. to another Subscription in another tenant. Please advise if we can use Azure migrate to migrate the all the resources. We want to take a phased approach by migrating non-prof…
asked 2021-01-10T20:34:35.427+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 23%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Siva Ramakrishnan
71
Reputation points
accepted 2021-01-13T07:41:23.997+00:00
Siva Ramakrishnan
71
Reputation points
1 answer
How to export and import custom reports in SSRS?
We've migrated our current SSRS to a new server. Now I need to export and re-import our custom reports to our new SSRS server. I've tried the download and upload with .rdl file extension but I got this error below.
asked 2021-01-11T17:01:10.267+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 3%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
CharlieLor
561
Reputation points
commented 2021-01-13T07:39:41.677+00:00
ZoeHui-MSFT
37,671
Reputation points
1 answer
Take the first item in the date range
I need to search the cube's calculated date for the first interval date in an MDX query. The query I created is this head ([Date]. [DateKey]. [DateKey] null) .item (0) .member_Caption, but I was not successful.
asked 2021-01-11T17:25:07.983+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 48%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
stefany
1
Reputation point
commented 2021-01-13T07:39:29.59+00:00
ZoeHui-MSFT
37,671
Reputation points
1 answer
AD Proxy provide vague results on account lockouts
Hi, I'm working in an enterprise that uses ad proxy. when we are investigating the lockouts events with Splunk, we are receiving the AD Proxy server name as the caller computer name and not the computer from which the authentication was called. is…
asked 2021-01-11T14:47:17.077+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 59%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Shay Kopilevich
6
Reputation points
answered 2021-01-13T07:31:25.89+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 32%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
Jitendra Rai
231
Reputation points
1 answer
Removing Unnecessary Messages in Output Window When Debugging
When debugging my Xamarin.Forms app (which is being written for and debugged using an Android emulator in Visual Studio 2019 16.8.3), I receive tons of unnecessary output in the Output Window, making it much less useful because it is hard to find my…
asked 2020-12-27T17:41:07.057+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 12%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Nathan Sokalski
4,111
Reputation points
commented 2021-01-13T07:28:55.67+00:00
JessieZhang-MSFT
7,711
Reputation points Microsoft Vendor
3 answers
BizTalk Server 2013 - EDI Batching orchestration performance and Load Balancing
BizTalk Server 2013 - EDI Batching orchestration performance and Load Balancing . We are running on BizTalk 2013 version for EDI messaging. we are facing performance issues in load balancing the outgoing EDI batches where in more than half of the…
asked 2021-01-11T19:31:38.627+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 3%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Tulasi
1
Reputation point
answered 2021-01-13T07:27:58.72+00:00
AliceYang-MSFT
2,091
Reputation points
3 answers
One of the answers was accepted by the question author.
get childstring json format
hi i have one doubt in sql server. how to convert json format using multiple tables create table emp_addr(empid int,city char(15),state char(15),country char(15),doj date) insert into emp_addr…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 90%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
1 answer
SCOM Rest API to update the alert fields like ticketid of a known alertID
I see scom rest apis to retrieve the alert data. I want SCOM Rest API to update the alert fields like ticketid of a known alertID? is it available, if so how to do it.
asked 2021-01-11T18:10:56.277+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 11%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
mahesh palem
41
Reputation points
answered 2021-01-13T07:15:58.457+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 92%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXM%3C/text%3E%3C/svg%3E)
XinGuo-MSFT
18,771
Reputation points
1 answer
One of the answers was accepted by the question author.
Sensitivity Labels in Azure Purview
I noticed that there is a report in Insight for sensitivity labels. I've set a few on-prem databases with sensitivity labels and have run scans. I don't see sensitivity labels or information types displayed in the asset and the report shows 0 for…
asked 2020-12-24T19:41:55.483+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 79%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEA%3C/text%3E%3C/svg%3E)
Everett, Andy
166
Reputation points
commented 2021-01-13T07:13:03.097+00:00
PRADEEPCHEEKATLA
90,231
Reputation points