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 .
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.
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…
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. …
How to fix error "No webpage was found for the web address:" when I am opening the url for my app service.
Hi community, I have created one dotnet core web app. Pushed it to repos in azure devops, created a pipeline and deployed it on azure web app services. After creating the release and publishing it on web app, when I am trying to open the URL of web app,…
Restore Azure SQL Database from GeoBackup to a different subscription
Hi everybody, I'm facing with this issues: i need to restore an azure SQL database from GeoBackup to a different server in a different subscription, but this error occurs "Long running operation failed with status 'Failed'. Additional Info:'The…
The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'.
Resource/subscriptions/*****/providers/Microsoft.Sql/managedInstances/smi-inf-sql-dev-east1/securityAlertPolicies/Default Operation nameUpdate managed server threat detection policy Time stampThu May 04 2023 17:26:47 GMT-0400 (Eastern Daylight Time) …
Data output error using specific scenario in SQL Join
Going though something very strange while running the SQL Query. External Table: dl.tableA has a varchar value "EmployeeSequenceNumber" in column EmployeeSequenceNumber , while doing the inner join with dim.tableB, the query is getting…
How to Fix:Error: Microsoft ODBC Driver 18 for SQL Server : SSL Provider: [error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed:self signed certificate].
I followed the documentation: https://learn.microsoft.com/en-us/sql/linux/quickstart-sql-server-containers-azure?view=sql-server-ver16&tabs=kubectl to deploy SQL server on AKS. But While connecting to it, getting the below error: Sqlcmd: Error:…
SQL Server install error Wait on the Database Engine Recovery Handle Failed
SQL Server 2019 install error Wait on the Database Engine Recovery Handle Failed this error is coming and i have tried everything on the internet to solve this but it still isnt installing can anyone tell me how to remove this error
Token-based login to SQL DB fails from App Service, works fine locally.
Using an Azure access token to connect to SQL DB works fine when running locally under Visual Studio. Deploying the web app to Azure App Service is fine. The deployed web app is unable to connect to the SQL DB: System.Data.SqlClient.SqlException…
Connection to Azure database fails only at the first attempt in a series
I am running a very simple SQL-call through python on windows 10. This SQL-call is a part of a larger tool. When this tool is ran for the first time after, say 1 day, then the very first SQL-call that is connecting to an Azure database is failing with…
Getting error "Could not create the marketplace item" for any resource I am trying to create
Getting error "Could not create the marketplace item" while creating any resource. It was working fine an hour ago and suddenly not able to create any resource. Below is my subscription details.
Azure Function Python V2 with bindings to Azure SQL Database
I'm using Azure Functions V2 (Python 3.11). Here you can read that V2 replaces the function.json file with function decorators:…
Azure SQL Free Database Offer Charging for Storage
Hi There I have a quick question regarding the Azure SQL Free Database Offer. It seems that I got charged for database storage despite not consuming the 32gb of free storage. Is there any reason why it's charging me for storage? See image for reference.