Issues with EF Update Command and Azure Credentials in ASP.NET Core Application
I am encountering errors while attempting to run an Entity Framework (EF) update command (dotnet ef database update) from my ASP.NET Core application. The application is connected to a database hosted on Azure. After executing the EF update command, I am…
how to fix task canceled error from Azure Data Factory, Pipeline
Hello The error below has occurred. Let me know what I'm gonna do. Error : 'Type=System.Threading.Tasks.TaskCanceledException,Message=A task was canceled.,Source=mscorlib,' A pipeline trigger was executed in Azure Data Factory. Thank you.
CosmosDB Analytical store delete changes in sql sink
Hi I am trying to capture delete changes from Azure cosmosdb analytical store using change data capture in Azure datafactory, Source is Cosmosdb, sink is Azure sql database. In between I am flattening my file using dataflow. My insert, update is…
Error in Linked Service connected to azure sql db using Azure Key vault
The linked service is not working after performing CICD from dev to qa branch. All the resources are copied along with linked service. However, The linked service could not setup correctly with this error. What does this error indicate and how to…
sqlcmd fails to connect to azure sql server because of mfa, but active directory says mfa is disabled
I have been following this guide: https://learn.microsoft.com/en-us/azure/azure-functions/functions-identity-access-azure-sql-with-managed-identity and have reached the step "Grant SQL database access to the managed identity". I have…
Hi , I have created one Azure SQL database with Basic pricing tier. I am not able to take it offline or pause the database.
when i go to Settings -> Properties, I can see an option Status ->online for that database but I can not change it to Offline/Pause. Please help since this effect my billing.
¿Cómo recupero la información de licencia OLP Microsoft SQL (2019 )?
¿Cómo recupero la información de licencia OLP Microsoft SQL (2019 )? Secuencia del tiempo Se toma la decisión de ordenar licenciamiento de productos usados en la nuestra compañía, Microsoft, Adobe y otros A fines del año 2017 compramos una…
I have been charged without my knowledge for the service that i did not use!
I have been charged without my knowledge for the service that i did not use. my number is #G047412504. it gives me error when i try to get refund. even though it displays that i am eligeable.
Location 'southindia' is not accepting creation of new Windows Azure SQL Database servers for the subscription
I tried creating an Azure Synapse workspace. After clicking on the final 'review+create' option & it was getting deployed, I received an error (image below). However, I can see a storage account & a synapse storage account created. Only the…
User Managed identity with failover group with servers in different regions
while using user managed identity with azure sql , the connection string or token acquired using DefaultAzureCredential is dependent on the clientID of user managed identity. for the scenario when there is a sql failover switch i.e due to outage in one…
Azure Management Instance Business Critical
Hi people, I have two questions about SQL Management Instance Business Critical. 1 - When I activate Zone Redundancy, I can't select which redundancy zone I want one of the nodes to be in? 2 - When I have zone redundancy in a failover with Business…
Query to identify queries executed in a specific Azure SQL DB
Hi All, I am trying to monitor queries running on Azure SQL Databases on a Premium tier Elastic Pool with ReadScale replication enabled. We redirect reporting for our OLTP system against the replicas (using ApplicationIntent = ReadOnly) which means Query…
Copying a Database to another logical server via the Portal
Copying a Database to another logical server does not show the available Elastic Pool in the destination when using the Portal. What is the reason for this?
How do I download my app codes, and database, which are in Azure Cloud?
I need to download my app codes, and database, which are in Azure Cloud? Could anyone help me, indicating where are the tools for this? Thanks!
How to create and migrate the tables from one azure database to another azure database
Use-Case- I have 130 tables in the Azure sql database, I need to create and migrate the 130 tables to another azure sql database. Can I use the Azure data factory auto-create functionality to migrate those 130 tables. How the primary keys and indexes of…
Azure SQL Database geo replication and Failover group cost
Hello Team, How to calculate Azure Azure SQL Database geo replication and Failover group cost, I cant see the option in azure pricing calculator. Regards
Impact on Azure SQL Database due to End of TLS1.0/1.1 Support
I am currently using Azure SQL Database without specifying a minimal TLS version, but will I be affected by the TLS 1.0/1.1 discontinuation on 10/31/2024 and will I be unable to connect with less than TLS 1.2? Will the minimal version of TLS, which is…
Deploying Azure SQL API Connection for Logic App using ARM
I have successfully created an Azure SQL Connection and registered it in the Logic App. However, I would like to authorize the connection manually, similar to creating a connection to one of the O365 services. When I create the Azure SQL Connection and…
Excessive waiting is happening on the following dominant wait type: CXCONSUMER
We have found from the logs of SQL managed database that DB is taking more time. Also, after investigation, we found that " Excessive waiting is happening on the following dominant wait type: CXCONSUMER " message in the logs of the managed…
As we observe from application insight logs from app services it show database is taking long time to respond to request
We are using SQL managed instance in azure and in single manage instance we have many different database to it. As we observe from application insight logs from app services it show database is taking long time to respond to request as shown in the…