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

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

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

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