6,019 questions with Azure SQL Database tags

Sort by: Updated
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.

Azure SQL Database
asked 2025-02-18T14:17:44.1566667+00:00
Dan Deluna 0 Reputation points
answered 2025-02-19T22:49:00.26+00:00
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…

Azure SQL Database
asked 2025-02-18T20:46:18.5266667+00:00
Phil Brown 0 Reputation points
commented 2025-02-19T22:37:15.12+00:00
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…

Azure SQL Database
Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,311 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,818 questions
asked 2025-02-19T09:56:47.0966667+00:00
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…

Azure SQL Database
asked 2025-02-18T14:09:59.4366667+00:00
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…

Azure SQL Database
asked 2025-02-18T23:22:44.8766667+00:00
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…

Azure SQL Database
asked 2025-02-19T13:49:18.2133333+00:00
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…

Azure SQL Database
asked 2025-02-18T14:40:39.4633333+00:00
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…

Azure SQL Database
asked 2025-02-18T11:44:41.7033333+00:00
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…

Azure SQL Database
Azure Service Bus
Azure Service Bus
An Azure service that provides cloud messaging as a service and hybrid integration.
666 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
5,430 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
3,090 questions
Azure AI Document Intelligence
Azure AI Document Intelligence
An Azure service that turns documents into usable data. Previously known as Azure Form Recognizer.
1,927 questions
asked 2025-02-19T13:21:00.3766667+00:00
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…

Azure SQL Database
asked 2024-09-14T01:05:06.1633333+00:00
Matt Keranen 20 Reputation points
commented 2025-02-19T15:48:09.9333333+00:00
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

Azure SQL Database
asked 2025-02-18T05:46:45.9366667+00:00
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.

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
asked 2025-02-17T04:59:09.97+00:00
AANCHAL CHAUHAN 5 Reputation points
edited a comment 2025-02-19T11:30:23.72+00:00
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…

Azure SQL Database
asked 2024-10-08T13:19:07.2333333+00:00
Marcin Kycia 25 Reputation points
commented 2025-02-19T10:09:13.48+00:00
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…

Azure SQL Database
asked 2025-01-20T13:46:16.21+00:00
Eldin Egrlic 0 Reputation points
edited the question 2025-02-19T09:25:49.9433333+00:00
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

Azure SQL Database
asked 2025-02-13T06:34:33.7266667+00:00
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…

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.
8,327 questions
asked 2025-02-12T17:20:20.2866667+00:00
Andrew 36 Reputation points
edited the question 2025-02-19T09:08:02.33+00:00
anashetty 2,275 Reputation points Microsoft Vendor
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!

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
asked 2025-02-12T19:29:49.3433333+00:00
GP 16 Reputation points
commented 2025-02-19T09:07:40.1733333+00:00
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…

Azure SQL Database
asked 2025-02-14T20:31:56.4166667+00:00
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
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
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?

Azure SQL Database
asked 2025-02-14T00:15:17.9033333+00:00
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