Azure SQL Database
An Azure relational database service.
6,045 questions
2 answers
Need help understanding Query performance insights for Azure sql
In Azure I go to my database and choose Performance Overview | Query Performance insight and it shows me long running queries. I click it to get details and I then click again to see the details of one of the queries. It says in the last 24 hours it…
asked 2025-02-25T21:07:45.8366667+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(92.8, 43%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Ryan Brown
0
Reputation points
answered 2025-02-28T11:55:48.39+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(300.8, 60%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
PratikLad
80
Reputation points Microsoft Vendor
0 answers
Azure SQL Restore from Long Term Retention
I am trying to restore a database from long term retentions. I can't see the DB listed in my restore values, what are the options?
![](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(115.19999999999999, 5%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECV%3C/text%3E%3C/svg%3E)
3 answers
One of the answers was accepted by the question author.
Azure SQL Restore stuck
I have a 2gb DB that is stuck restoring for over 48 hrs. It shows as an entry in SSMS but does not show up in the Azure Portal (see image attached) I cant find any status or logs information in the Azure Portal either... I have used restore…
asked 2021-09-30T08:55:00.69+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(185.6, 74%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
Rodney Graham
66
Reputation points
answered 2025-02-28T10:40:38.4766667+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(64, 30%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPD%3C/text%3E%3C/svg%3E)
paulAZ dania
0
Reputation points
0 answers
Secure enclaves enabled but SSMS didn't allow
in Azure portal, I created the database with Secure enclaves enabled - type was Virtualization based security (VBS). the command below return 1,1; however when using SSMS trying to connect with Enable secure enclaves, and protocol None, got error: …
asked 2025-02-27T12:28:14.4366667+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(99.2, 39%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJW%3C/text%3E%3C/svg%3E)
John Woo
0
Reputation points
commented 2025-02-28T10:35:28.7533333+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
1,485
Reputation points Microsoft Vendor
2 answers
Azure Purview lineage extraction not working on Azure SQL database
I am able to connect Azure Purview to my Azure SQL Database using SQL credentials for a service account I made for this purpose. The service account has db_owner permissions and a master key exists in the database. When I attempt to activate lineage…
asked 2023-11-09T14:38:39.5866667+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(22.400000000000002, 81%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tyler Simpson
10
Reputation points
answered 2025-02-28T10:33:21.2266667+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(83.2, 25%, 18%)' 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)
Marcel-Jan Krijgsman
25
Reputation points
3 answers
SQL Database Reserved vCores
We have a number of databases running on Azure SQL Server resources. We would like to change them to SQL Database Reserved vCores. Is there a way to change the from Azure SQL Database to SQL Database Reserved vCores. We would like to find the easiest…
asked 2025-02-21T00:11:02.9066667+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(121.6, 43%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Sipo Ching
0
Reputation points
edited an answer 2025-02-28T09:36:51.56+00:00
Vijayalaxmi Kattimani
1,485
Reputation points Microsoft Vendor
2 answers
How to Retain User Logins & Passwords When Migrating Azure SQL Database via BACPAC
I have a production application running on Azure with an Azure SQL Server and a SQL Database inside it. In my application, all users are created at the database level with their passwords. I need to migrate this database to another Azure tenant by…
1 answer
One of the answers was accepted by the question author.
SQL Connection Failed: Database 'xyz' on server 'xyz.database.windows.net' is not currently available
We have a free-tier Azure SQL database with paid overages costs but sometimes still see the database not being available as shown by this error message in the invocations log: SQL Connection Failed: Database 'xyz' on server 'xyz.database.windows.net' is…
asked 2025-02-27T16:50:49.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, 83%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
psdehr
0
Reputation points
commented 2025-02-28T07:40:04.7+00:00
Erland Sommarskog
117.8K
Reputation points MVP
1 answer
What does the following imply? "You cannot transfer an Azure SQL database with Microsoft Entra authentication enabled to a different directory."
I am looking to transfer an Azure subscription to a different Microsoft Entra directory. As part of this process, I want to understand the impact on my Azure SQL databases that use Microsoft Entra authentication. The documentation states that **"You…
asked 2025-02-14T20:23:56.0566667+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(28.799999999999997, 47%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETX%3C/text%3E%3C/svg%3E)
Thabang Xabanisa
0
Reputation points
edited the question 2025-02-28T07:21:40.23+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(217.60000000000002, 51%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
BANDELA Siri Chandana
1,570
Reputation points Microsoft Vendor
0 answers
Why mentioned error is occurs after sucessfull run
Start: Designer x64: Started running at 2025-02-24 21:15:25 Info: Designer x64: Running at a Low Priority. Info: Designer x64: This is AMP Engine; running 4 worker threads; memory limit 25.6 GB. Error: Input Data (85): Error SQLDriverConnect:…
asked 2025-02-25T05:17:35.7566667+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(201.6, 73%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anandhswarupp
105
Reputation points
commented 2025-02-28T03:11:19.1466667+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(256, 4%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Prasad Chaganti
0
Reputation points Microsoft Vendor
1 answer
can not send email from azure manged instance database mail
set up database email profile and account in the azure manged instnace, however, when i send email, it never send. i have same settin gin premier sql server without issue. our azure manged instance is using private node. smpt auto relay email
asked 2025-02-26T00:04:20.0033333+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(316.8, 85%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDZ%3C/text%3E%3C/svg%3E)
David Zhou
0
Reputation points
edited a comment 2025-02-28T02:07:23.2766667+00:00
Vijayalaxmi Kattimani
1,485
Reputation points Microsoft Vendor
1 answer
Azure Sql Managed Instance - Service Principal access issue
We have configured Sql Managed Instance and currently configured MS Entra MFA but we can't use for application login/Service account which is prompting for MFA so we have created Service Principal and provided access after adding into Managed Sql Server…
![](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(150.4, 17%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
0 answers
Action required: Upgrade Azure SQL Database 2014-04-01 APIs to a newer version by 31 October 2025
We received a notification for " Upgrade Azure SQL Database 2014-04-01 APIs to a newer version by 31 October 2025" and how do we check the resources Impacted? while searching in the azure retirement workbook what will be the service name ,…
asked 2025-02-27T19:25:21.6166667+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(22.400000000000002, 59%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
Neelima
0
Reputation points
edited the question 2025-02-27T22:15:22.1866667+00:00
Erland Sommarskog
117.8K
Reputation points MVP
0 answers
database deleted in managed instance, but keep say the database exist after syn database from sql server to azure failed
I created a distribute alwasy group from premier sql server to azure manged instance , but sync database failed in some point, I deleted the distribute group in local sql server, however, in the managed insance , the group name still exist , I can…
asked 2025-02-25T16:25:01.88+00:00
David Zhou
0
Reputation points
commented 2025-02-27T20:36:45.86+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(220.8, 47%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Mallaiah Sangi
85
Reputation points Microsoft Vendor
0 answers
Azure SQL DB Timeout
Getting status as 'Resuming' peristently for my SQL DB Trying to figure out cause of the problemScreenshot 2025-02-27 at 16.16.46.png
asked 2025-02-27T11:39:33.9833333+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(80, 71%, 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)
Sparsh Agarwal
0
Reputation points
commented 2025-02-27T19:43:06.8266667+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
2,720
Reputation points Microsoft Vendor
1 answer
How to login SQL server from SSMS using Managed Identity
Hi Team, We are using Azure SQL server. We have to disable the 'Public Network access' on this server now so we are checking the options on how to connect to this server from SSMS 20 as our existing method of login with MFA account will not work…
asked 2025-02-20T09:17:51.97+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(284.8, 11%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESU%3C/text%3E%3C/svg%3E)
Sanchita Uttarwar
0
Reputation points Microsoft Vendor
commented 2025-02-27T18:33:52.0633333+00:00
Mallaiah Sangi
85
Reputation points Microsoft Vendor
0 answers
Incorrect syntax near 'BLOB_STORAGE'.
Hello, I had created a Credential using the following Query. The credential got added successfully. -- CREATE DATABASE SCOPED CREDENTIAL TradeGeekBlobCredential -- WITH IDENTITY = 'SHARED ACCESS SIGNATURE', -- SECRET = 'MYSECRET'; Later, I am…
asked 2025-02-26T09:07:16.3166667+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(294.40000000000003, 12%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rahul Kumar
0
Reputation points
commented 2025-02-27T17:23:17.5566667+00:00
Sai Raghunadh M
2,720
Reputation points Microsoft Vendor
0 answers
Hosting Azure SQL Databases in Multiple Regions for Compliance and Access via Single API
We are looking to implement a multi-region data storage strategy using Azure SQL Database. Our goal is to store EU customer data in an Azure SQL Database located in an EU region and non-EU customer data in a US-based Azure SQL Database to meet compliance…
asked 2025-02-27T13:36:39.6733333+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(278.4, 48%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
Devesh Tiwari
180
Reputation points
asked 2025-02-27T13:36:39.6733333+00:00
Devesh Tiwari
180
Reputation points
3 answers
One of the answers was accepted by the question author.
Zone Redundency Option not showing on West Europe SQL Elastic pool
Hi, I have an SQL Elastic Pool in West Europe and another East US and the section where it allows me to enable "Zone Redundancy" isn't showing: I've successfully enabled it on our UK South Elastic Pool without any issues: UK South Elastic…
asked 2025-02-18T11:44:41.7033333+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(19.2, 75%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECW%3C/text%3E%3C/svg%3E)
Callum Woodward
21
Reputation points
accepted 2025-02-27T10:00:33.8966667+00:00
Callum Woodward
21
Reputation points
3 answers
The operation could not be completed because a service tier change is in progress for managed instance 'xxxxxxxx'.
I have a SQL server managed Instance and trying to make a copy of exiting database on same managed instance using restore operation but getting error -- "The operation could not be completed because a service tier change is in progress for managed…
asked 2025-02-22T17:33:43.0733333+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(89.60000000000001, 60%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
Pramod Kumar Singh
0
Reputation points
commented 2025-02-27T01:38:50.0833333+00:00
Vijayalaxmi Kattimani
1,485
Reputation points Microsoft Vendor