6,710 questions with Azure SQL Database tags

Sort by: Updated
2 answers

Do I need a new SQL Managed Instance?

I’m a data engineer at our company, but our Azure subscription is managed by a separate IT team. We’re building a new data platform and need elevated permissions to manage specific databases, without having full administrative access to the entire…

Azure SQL Database
asked 2026-01-15T02:24:23.2766667+00:00
Warren Narayan 0 Reputation points
commented 2026-01-20T17:58:10.1633333+00:00
VRISHABHANATH PATIL 4,200 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

How to restore Azure SQL Database from one SQL Server to a new SQL Server

I am trying to restore an existing Azure SQL Database hosted on Azure SQL Server to a new Azure SQL Server hosted on a different resource group. So far, I figured the best possible method to accomplish this is by creating a BACPAC file using SSMS. Now…

Azure SQL Database
asked 2026-01-19T18:09:27.35+00:00
Gagandeep Singh 20 Reputation points
accepted 2026-01-20T16:36:47.2933333+00:00
Gagandeep Singh 20 Reputation points
0 answers

Azure SQL vulnerability assessments should run weekly (configured on subscription level with express configuration), but some databases are scanned monthly.

Azure SQL vulnerability assessments should run weekly (configured on subscription level with express configuration), but some databases are scanned monthly. The weekly vulnerabiilty reports randomly show databases. In my case, I have 5 databases, and the…

Azure SQL Database
asked 2026-01-16T09:32:24.5533333+00:00
Rogier Haest 1 Reputation point
edited a comment 2026-01-20T14:46:56.03+00:00
Manoj Kumar Boyini 4,000 Reputation points Microsoft External Staff Moderator
1 answer

Azure Database Watcher for Read Scale-Out

Hello, We have set up Database Watcher for Azure SQL Database on Premium Tier with Read Scale-Out feature enabled. We have set up our database as SQL target with Read intent flag enabled. We would like to see the read-only replica as a separate…

Azure SQL Database
asked 2026-01-19T09:35:58.73+00:00
Ignat Strelets 5 Reputation points
commented 2026-01-20T13:46:25.0966667+00:00
Sina Salam 26,991 Reputation points Volunteer Moderator
2 answers

Why am I seeing around $380 in charges for an Azure SQL Database even though it was created using the Free (serverless) tier and barely used?

We created an Azure SQL Database using the Free serverless option since it was intended only for basic testing. There was no significant workload, very little data, and almost no CPU activity. However, when we reviewed Cost Analysis, we noticed charges…

Azure SQL Database
asked 2026-01-20T10:25:45.25+00:00
Adi Lakshmi Baddipudi 0 Reputation points
edited the question 2026-01-20T12:25:18.0333333+00:00
TP 146.9K Reputation points Volunteer Moderator
1 answer

Urgent - unable to restore snapshot mysql flexible server 'No available SKUs in this location'

I'm trying to restore a point in time backup of a mysql server. If I attempt via AZ cli I get 'No available SKUs in this location'. Trying via the portal I get 'Provisioning is restricted in this region. Please choose a different region. For exceptions…

Azure SQL Database
asked 2026-01-20T10:15:40.5566667+00:00
Adam Toms 0 Reputation points
answered 2026-01-20T10:43:09.7766667+00:00
Pilladi Padma Sai Manisha 2,135 Reputation points Microsoft External Staff Moderator
2 answers

Update-AzSqlInstanceVulnerabilityAssessmentSetting error

Hello, I am having some trouble with this cmdlet Update-AzSqlInstanceVulnerabilityAssessmentSetting when configuring vulnerability assessment for a Azure SQL Managed Instance. For context I have a User-assigned Managed Identity set as primary identity…

Azure SQL Database
asked 2026-01-15T13:07:18.0833333+00:00
Julie 100 Reputation points
commented 2026-01-20T09:09:02.33+00:00
Julie 100 Reputation points
1 answer

DR for DWH solution

Hello, I need to pick up some input what type of DR I need to use for a Data Warehouse build on Azure. Here's the setup: Data Source -Oracle OCI (cloud) ETL tool - Synapse Pipelines Data Lake gen 2 used to store data as is taken from Oracle db…

Azure SQL Database
asked 2026-01-14T13:19:13.2666667+00:00
Xhevahir Mehalla 25 Reputation points
commented 2026-01-20T06:27:31.5166667+00:00
Pilladi Padma Sai Manisha 2,135 Reputation points Microsoft External Staff Moderator
2 answers

Azure SQL serverless costs are high despite low usage – is this configuration oversized and what is a safe lower tier?

We are seeing steadily increasing Azure costs, with the majority of spend coming from an Azure SQL Database. The current configuration is General Purpose serverless, Gen5, 6 vCores, 250 GB max storage. Actual usage is very low: storage averages 2–3 GB,…

Azure SQL Database
asked 2026-01-17T14:12:26.1133333+00:00
Gabriela Matouskova 0 Reputation points
commented 2026-01-20T04:20:20.3633333+00:00
Pilladi Padma Sai Manisha 2,135 Reputation points Microsoft External Staff Moderator
2 answers

Azure Managed Instance - Shrink 32TB database that has 20TB free space

Good Day I have a 32TB database in an Azure Managed Instance. The database after a cleanup now has 20TB free space. The database has multiple files. I've been trying to shrink the database by running DBCC ShrinkFile on individual files. The command ran…

Azure SQL Database
asked 2026-01-13T09:38:51.3466667+00:00
Denesh Naidoo 5 Reputation points
commented 2026-01-19T22:02:49.25+00:00
Erland Sommarskog 131.1K Reputation points MVP Volunteer Moderator
2 answers

How do I restore a SQL Server. (The resource group is also deleted)

Azure SQL logical server AND its resource group were accidentally deleted. How do i restore the SQL Server

Azure SQL Database
asked 2026-01-19T15:52:18.1433333+00:00
Mahaboobsab Makandar 0 Reputation points
answered 2026-01-19T21:59:05.59+00:00
Alberto Morillo 35,411 Reputation points MVP Volunteer Moderator
2 answers

Agent message code 21118. Failed to connect to Azure Storage '\\filestorage.file.core.windows.net\replshare' with OS error: 67.

We are trying to mount Aure file storage account file share with SQL Managed instance and getting below error: -XCancelEventHandle Global\Distribution-{999CD062-8A3C-4697-9A2A-B241BB5852ED} 2026-01-15 08:28:21.258 Startup Delay: 2800…

Azure SQL Database
asked 2026-01-15T12:13:28.83+00:00
Devulacheruvu Venkatesh 0 Reputation points
commented 2026-01-19T10:52:13.0566667+00:00
Pilladi Padma Sai Manisha 2,135 Reputation points Microsoft External Staff Moderator
11 answers One of the answers was accepted by the question author.

Microsoft SQL Server Studio - Dark Mode

Is there any official method to use Microsoft SQL Server Management Studio Studio with Dark Mode?

Azure SQL Database
Developer technologies | Transact-SQL
Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,713 questions
Developer technologies | Visual Studio | Other
Developer technologies | Visual Studio | Other
A family of Microsoft suites of integrated development tools for building applications for Windows, the web, mobile devices and many other platforms. Miscellaneous topics that do not fit into specific categories.
5,645 questions
SQL Server | Other
asked 2023-12-19T13:11:52.4966667+00:00
Kıvanç ÖZDEMİR 135 Reputation points
answered 2026-01-19T10:47:38.16+00:00
Roy V 0 Reputation points
1 answer

Service Principal permissions needed for OPENROWSET queries to Azure Blob Storage via Fabric

Description: I'm querying Microsoft Fabric from Python using pyodbc and SQLAlchemy with ActiveDirectoryServicePrincipal authentication. What works: Querying tables in our mirrored PostgreSQL database executes successfully with the service…

Azure SQL Database
asked 2026-01-12T08:05:43.3866667+00:00
Kenneth Kabiru 0 Reputation points
commented 2026-01-19T10:24:25.3833333+00:00
Pilladi Padma Sai Manisha 2,135 Reputation points Microsoft External Staff Moderator
3 answers

How do I Fix Login failed for user ''. for Mac apple silicon download azure SQL Server

've been trying to install azure sql for the past 3 weeks and eep getettign this error message. I deep dived the web for answers but none have suffice. Can you help, I'm trying to use sql for my class and business. I know it's telling em the username I…

Azure SQL Database
asked 2024-04-23T19:26:01.33+00:00
blouis 5 Reputation points
answered 2026-01-19T10:11:53.68+00:00
MrPro 0 Reputation points
1 answer

How to load data from azure file share to SQL managed instance?

How to load files (image, Microsoft document, pdf, etc.) in azure file share to SQL managed instance?

Azure SQL Database
asked 2025-03-07T03:27:15.7833333+00:00
Junhui Ma 20 Reputation points
commented 2026-01-19T09:11:22.7133333+00:00
Scott Faculak 6 Reputation points
1 answer

Azure Logic App - SQL Stored Procedure Execution Failing with 403 Forbidden Despite Correct Permissions

I have an Azure Logic App configured to interact with an Azure SQL Database. The app successfully: Inserts data into a table Uses the same SQL connection However, when attempting to execute a stored procedure, I receive a persistent 403 Forbidden…

Azure SQL Database
asked 2026-01-18T14:02:49.65+00:00
A. Washington 0 Reputation points
commented 2026-01-19T01:26:35.8166667+00:00
Pilladi Padma Sai Manisha 2,135 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Azure SQL MI Fail over group configuration freezes?

Hi thanks for the attention of my question I am using Azure SQL MI. I want to configure replication to a secondary region by setting up a fail over group. However, since we are in production, it is important that there are no interruptions (including…

Azure SQL Database
asked 2024-05-11T03:24:18.1933333+00:00
romero 125 Reputation points
edited a comment 2026-01-17T04:04:30.51+00:00
Madugula, Yugalkishore G 0 Reputation points
1 answer

Trying to change region for sql database

trying to move resource/db to east us region. Seems to not allow it. Not sure what to do.

Azure SQL Database
asked 2026-01-16T16:49:23.3633333+00:00
Franklin Husselbee 0 Reputation points
answered 2026-01-16T17:49:39.9133333+00:00
VRISHABHANATH PATIL 4,200 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Architecture advice for a Battery Passport SaaS: Integrating Azure SQL Database with Container Apps and API Management.

I am a university student working on a project for a SaaS and Battery Passport solution and I am researching the most optimized and cost-effective Azure architecture for this use case. The company collects and stores data from customers. Using this data,…

Azure SQL Database
asked 2026-01-13T18:38:51.42+00:00
Pasquale 20 Reputation points
accepted 2026-01-16T14:11:19.35+00:00
Pasquale 20 Reputation points