Microsoft Q&A
Questions
Discover questions that will help you on every step of your technical journey.
Content
Connect SOAP API using Azure Data factory
Hello everyone, I an facing an issue calling a SOAP using ADF. I can make the SOAP API call through the SOAPUI but the same is not working when I am calling it from the ADF pipeline. Below is the body: <soapenv:Envelope…


Microsoft Certificates
How can I get my paper certificates for the 4 passed exams? AI 900 SC 900 DP 900 AZ 900


DBCC CHECKDB runs longer
Hello, We have Sql Server 2012 and we are running Ola's "DatabaseIntegrityCheck" job daily during off peak hours early in the morning, job runs fine but sometimes currently runs longer in our test server but production server no issue. Server…


c# use tablename as variable
How can i use tablename as a variable in sql query? "select * from table_name " table_name must be variable.


Continuation of "About the GUIX restrictions"
This is a continuation of my previous question "About the GUIX restrictions."(https://learn.microsoft.com/en-us/answers/questions/1108375/about-the-guix-restrictions). A client of ours has contacted us. The following comment, which you recently…


Need help on how to export a list of machines on all schedules
Hello, I have been looking around the internet and I am falling short on how to export a list of all schedules for update manager and the VM's attached to each schedule. I would like to do this with PowerShell but I am open to other ways to accomplish…


steps to provide the azure form recognizer model's output/result to custom text classification model as an input
Is there any way to connect the form recognizer's custom model's result/output as an input to the custom text classification model in the language studio


SQL Server Spatial Geometry Validity problem
SQL Server Spatial in RDS .... SELECT @@version GO Microsoft SQL Server 2017 (RTM-CU19) (KB4535007) - 14.0.3281.6 (X64) Jan 23 2020 21:00:04 Copyright (C) 2017 Microsoft Corporation Web Edition (64-bit) on Windows Server 2016 Datacenter 10.0…


multiple select in view
Hi Expert, i wanted to store the data in temp table and then use in another to improve performance i.e. select col1,col2,col3 into #temp from table1 select col1,col2 ,table1.col3from view a join #temp on a. col1=b.col1 expected output: select…


Synchronize employeeType Attribute from Active Directory to Azure AD
Hello, I have syncronized attribute employeeType to AzureAD with Azure Ad Connect with this guide: https://learn.microsoft.com/en-us/azure/active-directory/app-provisioning/user-provisioning-sync-attributes-for-mapping (step: Create an extension…


Pipeline failed when parsing json due to null values
First of all, I am new in ADF world. Recently got a task which I am still strugling with. I am trying to parse nested json stored in Blob Storage and copy the content to a table I had built in Azure Sql DB. I created a pipeline and mapping but…


Join a Windows 2019 Standard Server to Office365 Azure
I have a Windows 2019 Standard server running a legacy application and my backup software. All my clients are Joined to the Office365 Azure Domain in the cloud. No local AD at this time. The Windows 2019 Standard server is a standalone device and is…


configuring real time tags as events in Azure IoT Hub
I am using an IoT device called "eWon Flexy" to push the real time data directly to Azure IoT, which can be retrieved by Cloud BI called "AVEVA InSight". the hardware is connected to Azure. the AVEVA InSight is connected to Azure. but…


Problem with ADF Dataflow pipeline when writing data to SQL Server
I have an ADF Dataflow pipeline that reads data from a data lake and writes it to a SQL Server table. I have a problematic column called "gdtxft" that I converted from binary to string using the 'toString' function in the Derived column…


Azure sql db instance is taking very long time for a simple select query . How can we improve his ?
Hi, I have this azure sql db instance I am having table in database which is having only 12000 rows. A week ago everything was working fine but suddenly since last 3 days even select query is taking very long time . See the snap. For fetching the 12000…


ForEach inner activity fails but not ForEach activity itself!
I have a pipeline with a single ForEach activity which consists of one Copy activity. This ForEach activity usually iterates over seven items. Now and then one of ForEach inner Copy activities fails but not the ForEach activity itself. This makes…


Bulletins Tabs Removed?
For some reason bulletins tabs has been removed from our teams and whenever we try to access it through the post generated when it was added, both me and the admin is getting "You don't have permission to access this app".
About the GUIX restrictions.
Please let me know if anyone knows about this. The following URL is a description of the limitations of GUIX Studio. https://learn.microsoft.com/en-us/azure/rtos/guix/guix-studio-1#guix-studio-constraints The following three are listed here. …
Azure Synapse Workspace - Role and Permission to see SQL views and execute views
Hi, I have data lake storage account which has raw JSON files. I created Synapse Workspace and added SQL serverless database which has 2 different views on top of these JSON files. I as admin can query this views and able to see results in synapse…


[Azure Databricks] Getting com.amazonaws.SdkClientException in our logs
Starting on 12/19 or so we've got a bunch of errors referencing AWS + EC2. Is this expected? Our assumption is that the Metadata call is generic and is being used for Azure + AWS, but would like to confirm. com.amazonaws.SdkClientException: at…

