Azure SQL Database
An Azure relational database service.
5,783 questions
2 answers
Help me on DP900
I was preparing for DP 900 in the official website of Microsoft Account. I came up with such question and have confusion in this. " Q1. Q2. Therefore, Which data service allows you to use every feature of Microsoft SQL Server? Please…
asked 2024-11-18T16:09:19.9533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 17%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
SUBHAJIT MUKHERJEE
0
Reputation points
commented 2024-11-19T08:11:01.92+00:00
Nandan Hegde
32,421
Reputation points MVP
0 answers
How to publish a blazor website with sql sever that is giving the error HTTP Error 500.30 - ASP.NET Core app failed to start
hi, im trying to publish my blazor web app on azure however it fives me the error HTTP Error 500.30 - ASP.NET Core app failed to start. when i try to debug it and go into the diagnose page of the websever i get this error…
asked 2024-11-18T11:43:25.1633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 57.99999999999999%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAW%3C/text%3E%3C/svg%3E)
Aidan Waterford
0
Reputation points
commented 2024-11-19T08:09:22.1933333+00:00
JasonPan - MSFT
5,981
Reputation points Microsoft Vendor
2 answers
What dont I see the "Convert to Standby" on a Geo Replication setup of Azure SQL
I have an Azure SQL server and have setup geo-replication for the databases on that server. Since we are only going to be using the replica for DR purposes, we want to switch it from geo-replica to standby-replica. According to…
asked 2024-11-18T07:30:21.6066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 78%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Mulla, Tabrez
20
Reputation points
answered 2024-11-19T07:27:34.8166667+00:00
Mulla, Tabrez
20
Reputation points
1 answer
Azure SQL billing when using the free-tier
Hi there, I've been charged when using the Azure SQL single database through the free-tier. I selected, from the ground the free-tier application blade Can you please review this out of the blue costs? I don't understand them from my side. appreciated a…
asked 2024-11-15T08:29:12.98+00:00
Enric
81
Reputation points
commented 2024-11-19T05:03:18.1933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijayalaxmi Kattimani
415
Reputation points Microsoft Vendor
1 answer
How to avoid database comparison between on-prem and azure sql after database restore
We have existing Azure data sync setup (in dev ,test and prod) between on-prem and azure sql . As part of data refresh activity, lower env (dev and test) db will be refreshed (delete and recreate db) with prod data along with data sync objects in both…
asked 2024-11-13T10:54:21.4266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 87%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Aparna Manoharan
20
Reputation points
commented 2024-11-19T04:58:39.2966667+00:00
Vijayalaxmi Kattimani
415
Reputation points Microsoft Vendor
1 answer
Azure sql serverless database status showing pause state on azure portal.
i can connect to my Azure SQL Database through SSMS or Azure Data Studio and execute queries while the Azure Portal still shows the database in a "paused" state but queries are executing through SSMS or Azure Data Studio also through my web…
asked 2024-11-14T13:12:26.95+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 18%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
Abhishek Jadhav
40
Reputation points
commented 2024-11-19T04:24:37.4933333+00:00
Vijayalaxmi Kattimani
415
Reputation points Microsoft Vendor
1 answer
Unable to connect to Azure SQL Error 40613
We have not had any changes related to this database, it has started to generate this error and I am having problems: ADDITIONAL INFORMATION: The database 'name-db' on the server 'name-server-db-server.database.windows.net' is currently unavailable. …
asked 2024-11-19T00:35:27.8866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 74%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGL%3C/text%3E%3C/svg%3E)
Guilherme Lucas Pinheiro de Lima
0
Reputation points
answered 2024-11-19T03:42:46.65+00:00
Alberto Morillo
34,056
Reputation points MVP
1 answer
Azure elastic agent jobs that work for existing databses are failing for newly created one's with "The server principal "ac1971e9-381b-449b-9e1a-9cc276fc2985@b5313c9d-fb0d-47af-bc87-7c050bffbdc3" is not able to access the database "
Azure elastic agent jobs that work for existing databases are failing for newly created one's with "The server principal "ac1971e9-381b-449b-9e1a-9cc276fc2985@b5313c9d-fb0d-47af-bc87-7c050bffbdc3" is not able to access the…
asked 2024-11-18T16:47:25.14+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 84%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Andrew Betts
0
Reputation points
edited the question 2024-11-18T21:24:05.77+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 76%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
VarunTha
9,420
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
No editor functionality in Azure Data Studio
I've just started using Azure Data Studio, and I'm surprised that very basic functionality seems to be missing. For example - I don't think I've ever seen another SQL editing tool (or any code editing tool, for that matter), that lacks the ability to…
asked 2022-09-02T21:21:43.64+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 88%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
David Bean
41
Reputation points
commented 2024-11-18T15:06:42.1166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 7.000000000000001%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Tdawg
0
Reputation points
1 answer
What is the GUID that gets created on Azure data sync objects
We have azure data sync setup for on-prem and azure sql db. When Initial trigger is started, there are Data sync tables, procedures and user types gets created.We notice the naming format for procedure is <table_name>_dss_bulkinsert<GUID>…
asked 2024-11-15T15:39:51.41+00:00
Aparna Manoharan
20
Reputation points
commented 2024-11-18T13:38:42.8833333+00:00
Aparna Manoharan
20
Reputation points
1 answer
Permission Issues with Application Registration for Creating External Users in Azure Synapse Databases
Hello everyone, I’m encountering an issue with an Application Registration in Azure AD that needs to create external users in several on-demand Azure Synapse databases across multiple environments. Despite configuring the necessary permissions in Azure…
asked 2024-11-06T08:14:30.0266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 28.000000000000004%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN4%3C/text%3E%3C/svg%3E)
NavasMiguel-4566
0
Reputation points
edited the question 2024-11-18T08:36:26.8433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
17,120
Reputation points Microsoft Vendor
2 answers
How to take back up of azure data sync metadata
We are have azure sql db which is part of azure data sync group. This db will be refreshed as part of environment refresh and restored again To avoid row by row comparisons again should we take back up of data sync metadata before refresh? If so how to…
asked 2024-11-14T15:50:10.43+00:00
Aparna Manoharan
20
Reputation points
commented 2024-11-18T06:29:35.9966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M
1,045
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
How do I set up my Azure server to receive data from outside computers?
I have an Azure Standard server set up. At the moment I can push data from this server outside. But how do I set it up to receive data from outside computers?
asked 2024-11-15T01:41:05.46+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 69%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBG%3C/text%3E%3C/svg%3E)
Bradley Gilbert
20
Reputation points
accepted 2024-11-18T06:23:27.8766667+00:00
Bradley Gilbert
20
Reputation points
1 answer
Single Server and Flexible server performance
Our application has been hosted in the Azure Environment windows server and Database server. In the month of september, Database has been migrated from single server instance to Flexible server instance. After the migration , we feel the performance of…
asked 2024-11-12T07:57:24.7166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 0%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
rv385
0
Reputation points
commented 2024-11-18T06:18:40.1266667+00:00
Sai Raghunadh M
1,045
Reputation points Microsoft Vendor
2 answers
Unable to connect to Azure SQL Server from local machine
I have created a SQL Server DB and added required firewall rules. However, I am unable to connect to the DB from my local machine using any SQL Editor. For e.g., DBeaver. Though, I can connect the DB using Azure's in-built "Query Editor". I can…
asked 2024-11-12T12:18:09.66+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 16%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Singh, Abhinav (External)
0
Reputation points
commented 2024-11-18T06:07:44.54+00:00
Sai Raghunadh M
1,045
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
azure cpu percentage vs sql instance cpu means
i have azure sql server what does CPU Percentage (Max) vs SQL Instance CPU Percentage (Max) disparity means for planning and sizing.
asked 2023-08-30T03:06:54.26+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 24%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
k shaz
36
Reputation points
commented 2024-11-17T12:39:53.8633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 79%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMJ%3C/text%3E%3C/svg%3E)
Mehdi Jafari
0
Reputation points
1 answer
One of the answers was accepted by the question author.
find duplicate record
Hi, have 3 rows in one table how to remove 2 duplicate from table 1, 2, 3 1, 2, 3 1, 2, 3
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
1 answer
How to manually backup Azure SQL Database.
I am trying to look into possible options to manually backup specific database and I found this option https://learn.microsoft.com/en-us/azure/azure-sql/database/database-export?view=azuresql&source=docs but this says that this is not a preferred…
asked 2024-11-13T13:49:26.2166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 61%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Ayush Shrivastava
120
Reputation points
commented 2024-11-15T18:49:34.54+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
3,350
Reputation points Microsoft Vendor
0 answers
Intermittent Error: Cannot Set AccessToken Property in .NET Core 8 with SQL Server
Description: I am encountering an intermittent error in my .NET 8 application when trying to establish a database connection using the Microsoft.Data.SqlClient library. The issue occurs sporadically during runtime, resulting in the following unhandled…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,783 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,940 questions
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,630 questions
.NET Runtime
.NET Runtime
.NET: Microsoft Technologies based on the .NET software framework.Runtime: An environment required to run apps that aren't compiled to machine language.
1,172 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,936 questions
asked 2024-11-15T08:04:50.8933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 84%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
Anant Jaiswal
0
Reputation points
edited the question 2024-11-15T09:25:02.1366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 36%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELH%3C/text%3E%3C/svg%3E)
Lan Huang-MSFT
29,826
Reputation points Microsoft Vendor
0 answers
AUDIT SESSION CHANGED action causes login failed
I have auditing enabled on my Azure SQL instance and I've noticed lately that whenever the AUDIT SESSION CHANGED action occurs, if a DB connection is attempted at that moment, it will fail with Login failed for user '<username>'. I've noticed this…
asked 2021-10-21T18:15:54.897+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 65%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
Graham
41
Reputation points
commented 2024-11-15T09:12:30.1733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 88%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM8%3C/text%3E%3C/svg%3E)
MarcusNilsson-8584
0
Reputation points