convert null to zero in pivot to get row total
Hello This is my sql code DECLARE @cols NVARCHAR(MAX)='' DECLARE @query NVARCHAR(MAX)='' DECLARE @COLS_SUM NVARCHAR(MAX)='' DECLARE @COLS_TOT NVARCHAR(MAX)='' --Preparing columns for Pivot SELECT @cols = @cols + isnull(QUOTENAME(ND),0) +…
APIM API Visibility Permission
i have an APIM resource in Azure, i have created 2 APIs in it Audit API Invoice API i have 2 teams working for me - Autid Development Team Invoice Team i want to give visibility permission to them as below: Audit Team can only see Audit API…
Can't add physical fido2 passkey/security key to my microsoft account, using edge
Hello, I'm trying to add my physical usb pass key ( security key ) brand is Feitian k9, I enter the pin and there's a message password is saved, afterwards it says couldn't add the physicial key key works %100 fine in other browsers and apps and phone
How do I use the built-in authentication features for a self-hosted container?
I have been using the Azure Document Intelligence service to detect document layout but I need to use the deployable container version that will be hosted in my own datacenter. I would like to make use of the authentication features described here:…
Document Intelligence Cold Start
The cold start seems to range from 15-25 seconds for standard layout OCR. If I ping it to stay warm, how long will it stay warm for? Are there any dedicated service plans I could use so it's always warm? Thanks
Error: 11402 -The value of the property '' is invalid: 'The remote name could not be resolved:
I am setting up a Linked service for ODATA in ADF, for IntegrationRuntime I am selecting "AutoResolveIntegrationRuntime" but connection to ODATA resource is failing: The value of the property '' is invalid: 'The remote name could not be…
How to deploy a web app with multiple docker images and no sidecar container
What is the best tool in Azure to host a web application that consists of four separate Docker images that have to communicate between each other? I've already tried container instances but learned that it's not possible to host multiple containers with…
Azure firewall migration from third party firewall
I am planning to migrate from a third party firewall to Azure firewall. Without much downtime Currently, all UDR points to third party firewall appliance hosted in Azure I have setup a firewall and empty policy in Azure I am will be importing rules…
Azure functions not displaying in the function app I created
I created an azure function app. When I try to create a function for it, for the first time the online editor open up and I can write the code. Now if I come to the function app and check under the functions tab it is not the showing the functions I…
Using Defender for endpoint on Servers
Hi all, I am looking to put Microsoft Defender on my servers, I know there is Defender for servers however could I install Defender for endpoint instead? To save costs? Or once I enrol the servers to defender for endpoint it will convert to defender…
How to get spoken Language in audio file with Azure Speech sdk in C#?
Hi, I need to detect what's spoken language in an audio file. I have already read the documentation about language identification for speech service but in the SpeechRecognitionResult object result I don't have the recognized language code. Is there a…
Azure China CDN distribute Blob of Azure HK
Could I use Azure China CDN to accelerate Blob content stored in Azure HK ? Users are in Mainland China, but my content is in Blog of Azure HK.
ADFS Authentication Issue in .Net 8
I have an existing ASP.NET MVC application that relies on ADFS authentication. I'm currently upgrading it to .NET 8. As part of the upgrade process, I prioritized implementing the authentication functionality first. However, I'm encountering an issue…
Azure Firewall inbound and Outbound Exceptions for APIM instance deployed in Internal VNet mode
Hi Community I'm planning to deploy an APIM instance in "Internal" VNet injection mode in a hub-spoke topology where APIM is deployed to spoke VNet and there's an Azure Firewall in the hub that police all the inbound and outbound traffic. UDRs…
CultureNotFoundException Querying SQL database using EF
Hello, I have a Web App (ASP.NET MVC) with controllers making CRUD operations using EF 6. Any operation involving the EF context to read data generates the following exception The Web App is localized in it-IT, setting up ThreadCulture and…
azure prononciation assessment async assessment
i'am using azure speech recognizer sdk , to do the prononciation assessment of an audio file. the problem when the speech is in french the results are always low , and no expressive const language = await detectSingleSpeechLanguage(text) …
Automatically install app as a personal app
Hello, could someone help me with automatically installing an app as a personal app for users who add the bot to a channel in a team? For example, when Adobe Acrobat is added to a channel in a team, it is also automatically installed as a personal app…
DeniedBySystem returned when i was used PhoneLineTransportDevice::RequestAccessAsync
I try to requset PhoneLineTransportDevice access with below code. It works fine in my Win10 22H2, but failed when i try to run in my Win11 23H2. would you like to give some advice? 1, Why it was failed DeniedBySystem in win11 ? 2, How to solve it…
Show/hide the fields based on the condition in jQuery
how to show/hide the otp->textbox and update->button based the onblur SaveProfileName_Email values change. Initially, when the page is loaded the txtProfileEmail and txtProfileName should contains the default values ex:- txtProfileEmail :- a@b.com…
Fetch the first element of a Collection attribute in the $select query in Graph API
I am trying to fetch some extension properties which are not default for User schema , here is a request and response format of a graph API. I need to get the response in the desired format what should be the modified query Request…