How to check in ADF if a csv file contains data or not when file can contain more than 5000 rows (limitation for lookup activity)
Hi, How can I check if a csv file contains any data (file always contains header row)? Problem is that I can get file where is more than 5000 rows (sometimes I can get 60k). In that case I face the issue of lookup limitation: …
Convert Sql queries to SOQL using ADF
I have an existing adf pipeline which uses lookup activity and get all the table names from azure sql sever. Using for each activity I copy the data from sales force to blog storage. I use dynamic sql queries in copy activity . Select * from…
Connecting dev subscription's container registry while deploying the appservice in test subscription.
I am a devOps Engineer, deploying three app services in dev and test environment using azure bicep and github action. While deploying the app services in dev I am connecting to dev subscription through github action p[ipeline and while deploying test app…
What are some best practices for optimizing performance and cost management when using Azure resources in production environments?
Hello everyone my name is naidu,What are some best practices for optimizing performance and cost management when using Azure resources in production environments? i work at Pearl Shims
Do you need to have single sign on to setup MFA on Azure radius vpn?
Do you need to have single sign on to setup MFA on Azure radius vpn? If not, how can you enable MFA for Azure VPN?
Faced internal server error while migrating a Classic Storage account to Azure Resource Manager (ARM)
Faced internal server error while migrating a Classic Storage account to Azure Resource Manager (ARM). How to migrate when MS backend is non functional for the migration required of us, by them?
Connect to Linked Server Database using Azure Data Factory
Hi! I have a database that is a linked server of another. I can connect and copy data of the main database in ADF. But is it possible to also copy data from the linked server database? If yes, how would I do this?
Front Door and CDN profiles alert
Hi Team, can we set up alert for an azure front door if my domain certificate getting expire? if yes can you please let me know the steps or any other way so that alert will trigger before expiry. Regards
Virtual machines with single firewall ip
How can we connect multiple Virtual machines with single firewall ip and how to assign each virtual machine's IP address to different users in outside.
Can Azure Container Instance be configured to pull images from a private Container Registry using managed identity?
Can Azure Container Instance be configured to pull images from a private Container Registry using managed identity? I am currently developing a CI/CD pipeline to automate the deployment of a standalone Python simulation application to the Container…
Can ASR and Azure Migrate Coexist?
Is it possible to have ASR enabled on an on-prem system AND migrate it to Azure at the same time? Ex. Imagine a company is running VMware, and they have ASR (on-prem to Azure) enabled to DR protect some of their VMs. Can you still migrate the VMs while…
Document Intelligence Studio Label Data Key based authentication error
Hi, i have set up a storage account with a container. i have disabled key access and added my Entra id to the roles with storage data contributor and added the system assigned identity of document intelligence identity with storage reader role to storage…
Module Not Found Error while executing the Azure Functions VS code or Pycharm.
I have created an azure function to consume data from Azure Event Hub. While trying trying to test function in VC code or Pycharm I am getting error.
why am I having error messages when attempting to create a virtual machine in Azure Training
I followed the instructions and copy and typed the Azure CLI commands as shown in the instructions but failed every time. I reset the Terminal type each command shown in the instructions and got failed message. Then I copied the commands and continued to…
vnet peering, NVA, and BGP
Hello everyone. I've been trying to achieve a robust network design for infrastructure on the Azure platform. I've established vnets in both West US and South Central US. The vnets are peered and the following two options are enabled. wus-vnet …
An csv file with 200 columns in adls. fetch only list of columns from config table. config table is in Azure SQL. config table has only 10 col names
An csv file with 200 columns in adls. fetch only the list of columns from the config table. config table is in Azure SQL.config table has only 10 column names. how to create pipeline with this scenario in Azure datafactory?
Synapse workspace deployment node-js supported versions
Hi, I would like to know the list of node.js versions supported for Synapse workspace deployment (Synapse Workspace Deployment@2 task). I can't seem to find any documentation describing the same.
Schema Drift Issue in Dataflow with Sink-Delta
Hi Team, I was testing the schema drift option for my delta sink and am getting error while running my dataflow when added one new column to existing source schema. Pipeline ran successfully when I didn't change the schema. Error: I have selected Allow…
re-activate deleted Subscription
I recently (20 days) deleted an Azure Subscription b03f63dc-d273-4e03-a478-fb0164243771 tksiproprod6453 And now I cannot find a way to re-activate it. Doesn't even show in my past billing history. Any advice?
Dataverse Connector in Logic App Standard using Managed Identity
Hi I'm looking for way to use Managed Identity with a Dataverse (Preview) connector in a Logic App Standard workflow. I only see the option to sign in with a personal account. What am I doing wrong here ? Rob