5,155 questions with Azure SQL Database tags

Sort by: Updated
0 answers

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?

Azure SQL Database
asked 2024-05-07T16:32:39.4+00:00
Jon Josep 0 Reputation points Microsoft Employee
commented 2024-05-07T19:13:41.3533333+00:00
Oury Ba-MSFT 16,471 Reputation points Microsoft Employee
1 answer

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…

Azure SQL Database
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,862 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,595 questions
asked 2024-05-07T17:06:06.31+00:00
Morne Weyers 0 Reputation points
answered 2024-05-07T19:01:52.8033333+00:00
akinbade abiola 0 Reputation points
1 answer

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…

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,617 questions
asked 2024-05-07T04:05:57.0066667+00:00
shellkyle 0 Reputation points
commented 2024-05-07T16:49:20.7133333+00:00
Harishga 3,580 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

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…

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,929 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.
28 questions
asked 2023-09-25T10:26:31.7966667+00:00
Mayank Jain 260 Reputation points
edited the question 2024-05-07T15:57:49.3966667+00:00
bharathn-msft 5,086 Reputation points Microsoft Employee
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,929 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.
28 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.
28 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

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…

Azure SQL Database
Azure Arc
Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
328 questions
asked 2024-05-07T10:24:15.01+00:00
Lorenzo Dalla Pozza 0 Reputation points
answered 2024-05-07T14:51:14.7666667+00:00
GeethaThatipatri-MSFT 27,717 Reputation points Microsoft Employee
1 answer

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…

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.
960 questions
asked 2024-05-07T14:04:13.9166667+00:00
Joseph Harris 0 Reputation points
commented 2024-05-07T14:45:30.64+00:00
Joseph Harris 0 Reputation points
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,717 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.
469 questions
asked 2024-04-30T05:18:55.9333333+00:00
Ankush Gurjar 140 Reputation points
commented 2024-05-07T10:06:45.6066667+00:00
Ankush Gurjar 140 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 140 Reputation points
commented 2024-05-07T08:36:47.03+00:00
Ankush Gurjar 140 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,306 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,862 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,726 Reputation points
1 answer

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

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,060 questions
asked 2024-05-06T08:20:54.0666667+00:00
Ankush Gurjar 140 Reputation points
commented 2024-05-07T07:45:03.0733333+00:00
akinbade abiola 0 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,516 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,717 Reputation points Microsoft Employee
1 answer

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…

Azure SQL Database
asked 2024-05-02T16:29:54.73+00:00
Ho Ming Tam 45 Reputation points
commented 2024-05-06T22:49:08.1166667+00:00
Oury Ba-MSFT 16,471 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,717 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

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…

Azure SQL Database
asked 2024-05-01T08:54:07.26+00:00
Azra Akil 60 Reputation points
commented 2024-05-06T16:44:19.4633333+00:00
GeethaThatipatri-MSFT 27,717 Reputation points Microsoft Employee
1 answer

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…

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,617 questions
asked 2024-05-01T20:06:01.4533333+00:00
Shweta Chavan 40 Reputation points
commented 2024-05-06T16:35:44.25+00:00
Oury Ba-MSFT 16,471 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,199 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,929 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