5,205 questions with Azure SQL Database tags

Sort by: Updated
1 answer

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…

Azure SQL Database
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,993 questions
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
29 questions
asked 2023-10-31T10:28:44.38+00:00
Mayank Jain 260 Reputation points
edited the question 2024-05-07T15:56:16.29+00:00
bharathn-msft 5,086 Reputation points Microsoft Employee
0 answers

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 .

Azure SQL Database
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
29 questions
asked 2023-11-16T11:54:08.5166667+00:00
Mayank Jain 260 Reputation points
edited the question 2024-05-07T15:52:33.6133333+00:00
bharathn-msft 5,086 Reputation points Microsoft Employee
1 answer

I Have not received certificate after passing the DP900 exam

I Have not received certificate after passing the DP900 exam

Azure SQL Database
asked 2024-05-07T13:11:39.3733333+00:00
PragnaParveda-6730 0 Reputation points
answered 2024-05-07T13:46:25.2466667+00:00
GeethaThatipatri-MSFT 27,887 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

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
Azure Private Link
Azure Private Link
An Azure service that provides private connectivity from a virtual network to Azure platform as a service, customer-owned, or Microsoft partner services.
470 questions
asked 2024-04-30T05:18:55.9333333+00:00
Ankush Gurjar 160 Reputation points
commented 2024-05-07T10:06:45.6066667+00:00
Ankush Gurjar 160 Reputation points
1 answer One of the answers was accepted by the question author.

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

Azure SQL Database
asked 2024-04-30T07:07:30.22+00:00
Ankush Gurjar 160 Reputation points
commented 2024-05-07T08:36:47.03+00:00
Ankush Gurjar 160 Reputation points
1 answer

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
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,353 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,889 questions
asked 2024-04-29T07:54:32.59+00:00
Power BI Admin Ciel 0 Reputation points
commented 2024-05-07T08:29:17.0033333+00:00
SwathiDhanwada-MSFT 17,881 Reputation points
1 answer

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…

Azure SQL Database
asked 2024-05-01T07:44:45.57+00:00
Ashutosh Prashar 0 Reputation points
answered 2024-05-07T03:45:30.8566667+00:00
ShaktiSingh-MSFT 13,836 Reputation points Microsoft Employee
0 answers

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…

Azure SQL Database
Azure Database for PostgreSQL
asked 2024-04-22T14:27:14.8433333+00:00
Serkan Aytekin 0 Reputation points
commented 2024-05-06T22:59:53.82+00:00
GeethaThatipatri-MSFT 27,887 Reputation points Microsoft Employee
1 answer

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. …

Azure SQL Database
asked 2024-05-03T10:06:02.83+00:00
Deep Kundu (DKN) 0 Reputation points
answered 2024-05-06T16:51:47.22+00:00
GeethaThatipatri-MSFT 27,887 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

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,…

Azure SQL Database
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,228 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,993 questions
asked 2023-05-18T08:39:43.7833333+00:00
Rajneesh Yadav 30 Reputation points
commented 2024-05-06T13:35:58.2333333+00:00
IbrahimYusuf-3145 0 Reputation points
2 answers One of the answers was accepted by the question author.

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…

Azure SQL Database
asked 2024-04-12T09:15:18.03+00:00
Simona Pantini 65 Reputation points
accepted 2024-05-06T13:32:32.9766667+00:00
Simona Pantini 65 Reputation points
2 answers

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) …

Azure SQL Database
asked 2023-05-09T13:07:51.9066667+00:00
Evan Van Scooter 30 Reputation points
answered 2024-05-06T04:22:21.95+00:00
Stuart Dobson 6 Reputation points
2 answers

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…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,853 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,560 questions
asked 2024-05-05T14:26:32.57+00:00
NIKHIL KUMAR 101 Reputation points
commented 2024-05-06T02:30:15.07+00:00
CosmogHong-MSFT 23,556 Reputation points Microsoft Vendor
1 answer

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:…

Azure SQL Database
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
980 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,853 questions
Azure Kubernetes Service (AKS)
Azure Kubernetes Service (AKS)
An Azure service that provides serverless Kubernetes, an integrated continuous integration and continuous delivery experience, and enterprise-grade security and governance.
1,883 questions
asked 2023-06-27T20:19:16.9633333+00:00
Satyam 20 Reputation points
commented 2024-05-05T12:03:10.72+00:00
Jaap Titulaer 0 Reputation points
9 answers

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

Azure SQL Database
Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
45 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,853 questions
asked 2021-07-28T10:27:04.27+00:00
Priyanshu Singh 31 Reputation points
edited an answer 2024-05-05T10:31:12.0666667+00:00
Fasil Hayat 0 Reputation points
3 answers One of the answers was accepted by the question author.

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…

Azure Key Vault
Azure Key Vault
An Azure service that is used to manage and protect cryptographic keys and other secrets used by cloud apps and services.
1,143 questions
Azure SQL Database
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,993 questions
asked 2020-07-28T09:34:02.19+00:00
dunderhead 106 Reputation points
commented 2024-05-04T13:07:53.85+00:00
ivan zhukov 10 Reputation points
3 answers

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…

Azure SQL Database
asked 2022-05-25T09:38:14.053+00:00
Smail Kozarcanin 1 Reputation point
commented 2024-05-03T15:21:50.4533333+00:00
Scott H 0 Reputation points
1 answer

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 SQL Database
Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,734 questions
asked 2024-04-19T14:00:11.5233333+00:00
Abhisekh Paul 0 Reputation points
edited an answer 2024-05-02T22:31:17.62+00:00
GeethaThatipatri-MSFT 27,887 Reputation points Microsoft Employee
1 answer

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 Database
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,353 questions
asked 2024-04-29T12:55:35.0966667+00:00
Louis Deconinck 0 Reputation points
answered 2024-05-02T21:20:23.2833333+00:00
Amira Bedhiafi 16,071 Reputation points
1 answer

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.

Azure SQL Database
Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,105 questions
asked 2024-05-02T01:08:43.9766667+00:00
Daniel Nguyen 0 Reputation points
commented 2024-05-02T16:24:48.31+00:00
Oury Ba-MSFT 16,731 Reputation points Microsoft Employee