AZURE: Cannot clear the Query Store
I am trying to setup the Automatic Tuning for the Azure SQL Database, but I have found out the "Query Store is in read-only state" So I plan to use the command to clear it to make it run "ALTER…
How to unpivot columns in kusto/kql/azure and put multiple columns into one
I got a table like this in Azure analytics with Kusto for the game I'm working on datatable (ID_player:string, Timestamp:timespan, monster1:int, monster2:int, monster3:int) [ "aaa", "12:00:00", 1,2,3 ,"aaa", "12:10:00", 4,7,0 ,"bbb", "12:30:00", 0,2,1 ] Basically, I need to switch to…
Azure – Is there a way to combine multiple query into one in SQL Server 2019?
I am wondering if there is a function in SQL Server or service in Azure to provide an opportunity to combine multiple queries into one. For example, ALTER TABLE1 ADD RetailValue AS (CAST(QtyAvailable AS int) * CAST(UnitPrice AS int) *…
Azure – [Issue on Integrating CICD Pipeline]-No hosted parallelism has been purchased or granted
I want to integrate CICD Pipeline for Uipath in azure devops using external application in orchestrator by following this uipath link How to Implement CICD Pipeline Using Azure DevOps Pipelines | Community Blog But when I build the pipeline and…
Azure – How can I transform the JSON in app logic?
I got to as far as a json result from log analytic query API HTTP action call: { "tables": [ { "name": "PrimaryResult", "columns": [ { "name": "TimeGenerated", "type": "datetime" }, { "name": "_queue", "type": "string" }, { "name": "_messages",…
Azure – How am I supposed to know the request to my bot originated from Teams?
We are currently working on implementing a Teams chatbot but had some questions on authentication. How does the bot verify the request is coming from Teams and not just a cURL request?
Azure – Why does Get-AzKeyVaultSecret return "No Such Host Is Known"?
I am trying to run a PowerShell script that calls Get-AzKeyVaultSecret using examples provided per Microsoft and keep getting an error stating No such host is known. Generically, the error is simple enough but the fact that I'm not specifying…
Job Suspended Run Login-AzureRmAccount to login using Azure AutomationAccounts System Managed Identity
I am trying to shutdown the VM using Azure Automation Account System Managed identity option. However I am ending up with below error. As per the other articles it is mentioned to upgrade the module Update-ModulesInAutomationToLatestVersion but I could not…
Why is Azure AD B2C saying my password is incorrect?
I have built a custom user flow in Azure AD B2C. It is almost a direct copy of this sample policy for doing JIT migration of users: https://github.com/azure-ad-b2c/user-migration/tree/master/jit-migration-v2. I have disabled Facebook, Google, sign-up & password reset. This leaves me…
Azure Kubernetes Service clusters should have Defender profile enabled
I am trying to fix this high severity error for Azure Kubernetes Cluster I tried using Azure portal but It keeps spinning for hours and does not fix it. I also tried with below Az Command - az aks update…