Azure SQL Database
An Azure relational database service.
6,019 questions
3 answers
We have a serverless Azure SQL database that we can't drop from the portal or SSMS.
I have reviewed the common solutions provided by the troubleshooter and none of them have resolved the issue.
asked 2025-02-18T14:17:44.1566667+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(259.20000000000005, 1%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
Dan Deluna
0
Reputation points
answered 2025-02-19T22:49:00.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(236.8, 79%, 32%)' 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)
RahulRandive
10,226
Reputation points
1 answer
SQL Stored procedure is continually reparsed and recompiled, causing significant delay in response
Our organization has a stored procedure, that seems to always be recompiled and reparsed nearly every execution, adding upwards of 14 seconds to overall execution time. The procedure is frequently but irregularly run, so it becomes common for users to…
asked 2025-02-18T20:46:18.5266667+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(38.4, 68%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Phil Brown
0
Reputation points
commented 2025-02-19T22:37:15.12+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
5
Reputation points Microsoft Vendor
1 answer
Connect Azure Automation Account to Azure SQL using Managed Identity
Hello, I'm trying to create a Runbook (Powershell) to connect to Azure SQL Database and then add an Entra ID user in that database. If there is way to do so in CLI commands it's fine by me. The problem is that we're always stuck at the DB connection step…
asked 2025-02-19T09:56:47.0966667+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(140.8, 61%, 23%)' 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)
Michel Sfeir
85
Reputation points
commented 2025-02-19T22:23:22.9966667+00:00
Erland Sommarskog
117.2K
Reputation points MVP
2 answers
Restore a database in Azure SQL Managed Instance to a previous point in time
Hello everyone, I created a powershell script below and I scheduled every day with SQL Agent Job SSMS to restore database from automatic backup azure managed instance , but I have this error : 'The term 'Get-AzSubscription' is not recognized as the…
asked 2025-02-18T14:09:59.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(288, 73%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
DJAMEL GARAR
0
Reputation points
edited an answer 2025-02-19T18:46:00.9133333+00:00
DJAMEL GARAR
0
Reputation points
0 answers
Azure SQL Managed Instance Stuck After Force Deleting Virtual Cluster – Cannot Remove MI
I attempted to delete an Azure SQL Managed Instance (MI), but the process became stuck while deleting the associated Virtual Cluster. I then manually force deleted the Virtual Cluster using Azure CLI. However, the SQL MI still exists in the Azure Portal…
asked 2025-02-18T23:22:44.8766667+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, 9%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEL%3C/text%3E%3C/svg%3E)
Eric Lee
0
Reputation points
commented 2025-02-19T18:02:36.98+00:00
Oury Ba-MSFT
20,346
Reputation points Microsoft Employee
1 answer
Recently, ODBC connections to our database in Azure no longer show all available tables.
When trying to add a linked table to our Azure DB in Microsoft Access via ODBC, recently I've started getting the following error message: OBDB--call failed. [Microsoft][ODBC SQL Server Driver][SQL Server]Reference to database and/or server name in…
asked 2025-02-19T13:49:18.2133333+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, 3%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENF%3C/text%3E%3C/svg%3E)
Neal Freeman
0
Reputation points
commented 2025-02-19T17:18:54.93+00:00
Neal Freeman
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Allocating DB costs
My desktop app (in development) is using an Azure SQL DB to store shared content. I want to allocate costs for storage and compute time for each client based on their usage. I think I understand how I can calcualte the storage costs, but am not sure…
asked 2025-02-18T14:40:39.4633333+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(102.4, 13%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAE%3C/text%3E%3C/svg%3E)
Admin eSMMS.tech
20
Reputation points
commented 2025-02-19T17:12:15.7666667+00:00
Admin eSMMS.tech
20
Reputation points
1 answer
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
1
Reputation point
edited a comment 2025-02-19T16:19:38.19+00:00
Callum Woodward
1
Reputation point
1 answer
upload_blob and download_blob takes 2 seconds to execute which increases execution time of our API
This is how we are creating a pdf on azure blob storage and reading the file from Azure blob storage upload_blob and download_blob takes 2 seconds to execute which increases execution time of our API i tried async but it didnt reduced time. func tools…
asked 2025-02-19T13:21:00.3766667+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(51.2, 91%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mayank Arora
0
Reputation points
answered 2025-02-19T16:08:13.5866667+00:00
Vinodh247
28,211
Reputation points MVP
3 answers
One of the answers was accepted by the question author.
OPENROWSET(FORMAT='PARQUET') syntax error in Azure SQL Database
Documentation suggests that OPENROWSET should support retrieving data in Parquet files from Azure BLOB Storage in Azure SQL Database [1], but for me it is returning "[Code: 102, SQL State: S0001] Incorrect syntax near 'FORMAT'." This is a new…
asked 2024-09-14T01:05:06.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(291.2, 27%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Matt Keranen
20
Reputation points
commented 2025-02-19T15:48:09.9333333+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(265.6, 69%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
haskie
0
Reputation points
1 answer
the same DB is visible twice in elastic pool
Dears Support recently we have noticed that the same DB is visible twice in elastic pool. Could someone support to understand what is reason Best Regards Vahe
asked 2025-02-18T05:46:45.9366667+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, 49%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
Vahe Mikayelyan
0
Reputation points
commented 2025-02-19T13:30:53.7733333+00:00
Vahe Mikayelyan
0
Reputation points
1 answer
we need to find a way to connect the Azure prod DB with our Prod VM server and our local machine, simultaneously via VPN or Private endpoint? Also I should be able to connect with DB and can write or extract data from DB table.
I'm unable to connect via on premise and VM with private connections using Azure VPN simultaneously. Also regarding on premise VPN connection I was able to connect but could not extract / write or even read the data.
asked 2025-02-17T04:59:09.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(185.6, 88%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
AANCHAL CHAUHAN
5
Reputation points
edited a comment 2025-02-19T11:30:23.72+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,330
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Question about GA for Next-gen GP for Azure SQL Managed Instance
Hi, Public-preview for Next-gen GP for Azure SQL Managed Instance is available since 21 March 2024, especially support for 32TB (https://techcommunity.microsoft.com/t5/azure-sql-blog/introducing-azure-sql-managed-instance-next-gen-gp/ba-p/4092647). Are…
asked 2024-10-08T13:19:07.2333333+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, 15%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Marcin Kycia
25
Reputation points
commented 2025-02-19T10:09:13.48+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, 54%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBJ%3C/text%3E%3C/svg%3E)
Biju Joy
0
Reputation points
1 answer
How to disable Storage Pools/Disks to be available to other nodes in SQL Cluster?
I am creating a SQL Cluster in Azure. This SQL cluster is mostly based on the Microsoft documentation article called "Tutorial: Configure an availability group in multiple subnets (SQL Server on Azure VMs)". This way you can create an SQL…
asked 2025-01-20T13:46:16.21+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, 69%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEE%3C/text%3E%3C/svg%3E)
Eldin Egrlic
0
Reputation points
edited the question 2025-02-19T09:25:49.9433333+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(54.400000000000006, 73%, 15%)' 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)
anashetty
2,275
Reputation points Microsoft Vendor
0 answers
paid 1000$ and litteraly no answer at all for 2 days
It is a realy joke ! they are offering 24 7 help and no one is answering there is not even a chat or any way to talk to someone for 1k tbh this is the absolute worst service ever
asked 2025-02-13T06:34:33.7266667+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(230.39999999999998, 33%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOB%3C/text%3E%3C/svg%3E)
Olivier Blanchet
0
Reputation points
edited the question 2025-02-19T09:25:08.91+00:00
anashetty
2,275
Reputation points Microsoft Vendor
2 answers
Require approval to delete a resource
Good Day I know resource locks exist, but, that's not what I'm looking for. What I want is a way to prevent deleting a resource, be that a SQL Server, App Service, App Service Plan, VM, Storage Account, or other, without approval from two…
![](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(166.4, 71%, 26%)' 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)
3 answers
Document for Backup Restore
Any document/link about backup and restore of MS SQL Server database using Visual Studio Code? Similar to the below one for azure data studio. https://learn.microsoft.com/en-us/azure-data-studio/tutorial-backup-restore-sql-server Thanks!
asked 2025-02-12T19:29:49.3433333+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(236.8, 15%, 32%)' 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)
GP
16
Reputation points
commented 2025-02-19T09:07:40.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(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
0 answers
HOST POOL AND VIRTUAL HOST USERS ARE UNABLE TO CONNECT TO AZURE SQL DATABASES
PLEASE HELP US UNDERSTAND WHY HOST POOL USERS ARE NO LONGER ABLE TO CONNECT TO SQL OR USE CLIENT APPLICATIONS THAT LINK TO SQL. IT IS IMPORTANT TO NOTE THAT OTHER VIRTUAL MACHINES ARE ABLE TO CONNECT AND UTILIZE THE DATABASES SUCH AS…
asked 2025-02-14T20:31:56.4166667+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(236.8, 10%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEA%3C/text%3E%3C/svg%3E)
Ed Abraham
0
Reputation points
edited the question 2025-02-19T09:07:36.8833333+00:00
anashetty
2,275
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
When can we expect Vector Similarity Search in Azure SQL Managed Instance
Hi team, I see that the Vector Similarity search is available in Azure SQL database in Preview mode. May I know when can we expect this feature in Azure SQL Managed Instance.
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,019 questions
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,090 questions
asked 2025-02-19T06:33:04.32+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(102.4, 38%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVG%3C/text%3E%3C/svg%3E)
Vigneshg G
0
Reputation points
accepted 2025-02-19T07:04:14.7233333+00:00
Vigneshg G
0
Reputation points
1 answer
Secure Deletion in Database Records
If I delete certain records (rows) in a database, do the deleted items appear in the latest instances or backups of the original database?
asked 2025-02-14T00:15:17.9033333+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(179.20000000000002, 96%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Luis Manuel Perez
0
Reputation points
edited a comment 2025-02-19T01:40:43.68+00:00
Vijayalaxmi Kattimani
1,330
Reputation points Microsoft Vendor