Force execution of SQL Server - Azure ARC Migration Assessments
Hello, I'd like to test the Migration tool on Azure Arc, but I'm unable to proceed because the "Migration Assessment" is scheduled for Sunday. Is there a way to force this task? It seems that the "Best Practices Assessment" is not…
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?
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…
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…
How to add Azure SQL Database as linked service to Azure Data Factory
I keep running into errors adding Azure SQL as a linked service to Data Factory. I'm new to Azure so please bear with me. Following all the online guides, I've done all of the following: On the SQL Server side: Under Microsoft Entra ID, enabled…
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…
Restore database failed. However the Tail-Log backup operation completed successfully
During restoring database I am getting this error error-Restore database failed. However the Tail-Log backup operation completed successfully .
ASD: How can I determine replica name from info in sys.dm_database_replica_states?
I have named replicas (NOT availability replicas) in my Azure SQL Database instance. When retrieving information from sys.dm_database_replica_states (generally to check secondary_lag_seconds), how can I determine the replica name associated with each…
I Have not received certificate after passing the DP900 exam
I Have not received certificate after passing the DP900 exam
Azure SQL Database connctivity
Hi Team, I have deployed azure SQL database service and I want to connect this database within the private network or office network, which configuration need to do from azure side. which IP need to whitelist from our office network? Thanks in advance!
Azure SQL Database Disaster recovery
Hi Team, can you please tell me how to configure Disaster recovery to azure sql database, and what is the difference between failover group and standby replica, both are different? if different then which solution should I go? Regards
Workflow from Email to blob using logic apps
can anyone help me on this error. Actually i created flow where it takes the file from mail and upload it on the blob folder.
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
how to restore differential azure Sql database automatically
Hello, Please suggest best approach to restore differential azure sql database. Restore/data refresh required 1-2 times daily. if we can do something using powershell/python and automation used for auto refresh. I am familiar with azure data factory for…
Postgresql flexible server on azure unplanned failover is not working in a Zoneredundant HA environment.
Hi all, On Azure we have a PostgreSQL-Server with Zone-redundant HA. When we trigger a forced Failover, the Server goes in the "Updating state" and that is the only information which we see about PostgreSQL flexible server on Azure. How we can…
Unable to find package 'Microsoft.Azure.SqlDatabase.ElasticScale.Service.SplitMerge'
It is related to "Deploy a split-merge service to move data between sharded databases" I followed the steps in the "Download the Split-Merge packages" (very beginning) and tried to execute the command nuget install…
I received a notice about retirement of Azure SQL Database 2014-04-01 APIs, what should I do? How do I identify the resources using the old version?
I received a notice about retirement of Azure SQL Database 2014-04-01 APIs, what should I do? How do I identify the resources using the old version? Sending this email to you guys as I was informed that you can run the KUSTO queries to get this detail. …
Retirement of Azure SQL Database APIs 2014-04-01
The Azure SQL Database API version 2014-04-01 is retiring, I would like to understand the following things: How can we check the resources effected using the resource graph explorer? How to make the changes using code? Any prerequisite or…
How to copy the data from Amazon S3 to Azure SQL database incrementally.
Hello team, I wanted to wanted to copy data from Amazon S3(JSON format) to Azure SQL database. I wanted to learn the mechanism for incrementally updating the data from Amazon S3 to Azure SQL. Also, the environment has only SHIR deployed, so data flows…