Microsoft Q&A

Questions

Discover questions that will help you on every step of your technical journey.

222,511 questions

Sort by: Updated
1 answer

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…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,269 questions
asked 2022-02-15T06:44:27.067+00:00
Kota, Kailash 6 Reputation points
commented 2023-01-30T22:28:00.21+00:00
MartinJaffer-MSFT 24,006 Reputation points Microsoft Employee
0 answers

Microsoft Certificates

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

Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
5,288 questions
asked 2023-01-30T22:27:50.94+00:00
Omotoye Omokheyeke 0 Reputation points
1 answer

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,487 questions
asked 2023-01-30T22:24:38.86+00:00
pdsqsql 331 Reputation points
answered 2023-01-30T22:26:55.74+00:00
Erland Sommarskog 67,721 Reputation points Microsoft MVP
4 answers One of the answers was accepted by the question author.

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.

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
2,537 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,487 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
6,939 questions
asked 2023-01-30T06:44:59.1066667+00:00
ÖMER NASUHİ KESKİN 0 Reputation points
answered 2023-01-30T22:25:01.1933333+00:00
Erland Sommarskog 67,721 Reputation points Microsoft MVP
1 answer

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…

Azure RTOS
Azure RTOS
An Azure embedded development suite including a small but powerful operating system for resource-constrained devices.
219 questions
asked 2023-01-30T22:09:31.13+00:00
k.kaneko 101 Reputation points
answered 2023-01-30T22:24:47.8133333+00:00
Ken Maxwell 626 Reputation points Microsoft Employee
0 answers

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…

Update management center
asked 2023-01-30T22:23:01.2933333+00:00
Scott Goode 0 Reputation points
0 answers

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

Azure Form Recognizer
Azure Form Recognizer
An Azure service that applies machine learning to extract text, key/value pairs, tables, and structures from documents.
642 questions
Azure Cognitive Services
Azure Cognitive Services
A group of Azure artificial intelligence services and cognitive APIs that help build intelligent apps.
938 questions
asked 2023-01-25T11:45:01.4366667+00:00
Saumitra 0 Reputation points
commented 2023-01-30T22:22:59.62+00:00
VasaviLankipalle-MSFT 566 Reputation points Microsoft Employee
1 answer

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,487 questions
asked 2023-01-30T03:10:33.3733333+00:00
Simon Greener 0 Reputation points
commented 2023-01-30T22:22:54.67+00:00
Simon Greener 0 Reputation points
2 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,487 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,843 questions
Azure SQL Database
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
997 questions
asked 2023-01-30T17:02:04.5166667+00:00
Shambhu Rai 646 Reputation points
commented 2023-01-30T22:20:03+00:00
Erland Sommarskog 67,721 Reputation points Microsoft MVP
0 answers

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…

Azure Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
12,608 questions
asked 2023-01-30T22:19:46.5633333+00:00
Roberto Loria 0 Reputation points
1 answer One of the answers was accepted by the question author.

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…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,269 questions
asked 2020-09-04T15:41:17.593+00:00
braxx 426 Reputation points
edited the question 2023-01-30T22:19:22.4666667+00:00
MartinJaffer-MSFT 24,006 Reputation points Microsoft Employee
1 answer

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…

Azure Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
12,608 questions
asked 2023-01-24T16:16:19.0533333+00:00
Mark Nabors 0 Reputation points
edited an answer 2023-01-30T22:19:17.8233333+00:00
Alfredo Revilla (MSFT) 15,576 Reputation points Microsoft Employee
0 answers

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…

Azure IoT Hub
Azure IoT Hub
An Azure service that enables bidirectional communication between internet of things (IoT) devices and applications.
683 questions
asked 2023-01-30T05:31:44.49+00:00
Bashar Sadeq 0 Reputation points
edited the question 2023-01-30T22:16:16.6466667+00:00
LeelaRajeshSayana-MSFT 776 Reputation points Microsoft Employee
0 answers

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 Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,269 questions
asked 2023-01-25T10:06:58.0633333+00:00
commented 2023-01-30T22:15:23.6466667+00:00
BhargavaGunnam-MSFT 7,406 Reputation points Microsoft Employee
2 answers

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…

Azure SQL Database
asked 2023-01-28T17:51:51.29+00:00
Amar Agnihotri 776 Reputation points
answered 2023-01-30T22:15:13.74+00:00
Oury Ba-MSFT 9,561 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

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…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,269 questions
asked 2020-08-10T11:26:18.017+00:00
Andris Veidemanis 96 Reputation points
edited the question 2023-01-30T22:14:55.7366667+00:00
MartinJaffer-MSFT 24,006 Reputation points Microsoft Employee
0 answers

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".

Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
5,288 questions
asked 2023-01-30T22:14:27.03+00:00
Edge 0 Reputation points
edited the question 2023-01-30T22:14:41.7133333+00:00
Edge 0 Reputation points
2 answers One of the answers was accepted by the question author.

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 RTOS
Azure RTOS
An Azure embedded development suite including a small but powerful operating system for resource-constrained devices.
219 questions
asked 2022-11-29T09:11:06.773+00:00
k.kaneko 101 Reputation points
commented 2023-01-30T22:14:00.9233333+00:00
k.kaneko 101 Reputation points
0 answers

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 Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
2,606 questions
asked 2023-01-19T22:47:52.4933333+00:00
Jaimin Kansara 0 Reputation points
commented 2023-01-30T22:13:49.8733333+00:00
BhargavaGunnam-MSFT 7,406 Reputation points Microsoft Employee
0 answers

[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…

Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
1,201 questions
asked 2023-01-27T15:34:20.4266667+00:00
Tarek Osman 0 Reputation points
commented 2023-01-30T22:12:45.6233333+00:00
BhargavaGunnam-MSFT 7,406 Reputation points Microsoft Employee