6,680 questions with Azure SQL Database tags

Sort by: Updated
0 answers

how do i add a new user in azure sql

Hi, I want to add a test credentials . Some un pw which can create sql tables. I am on this screen: from that screen copilot says to it says to go to query editor preview, but all i see is this: Is this because I have a free version ?? thanks for any…

Azure SQL Database
asked 2025-12-26T05:28:34.8066667+00:00
James Pruett 0 Reputation points
1 answer

Azure SQL BACPAC parallel imports stuck at 100% for extended periods – expected behavior?

Hi, I’m looking for clarification on the expected behavior of Azure SQL Database** BACPAC imports**, particularly in environments where imports may be triggered in parallel and imports reach 100% but do not complete. Environment Azure SQL Database …

Azure SQL Database
asked 2025-12-25T08:00:42.6633333+00:00
FELDNER Ilanit 20 Reputation points
commented 2025-12-26T05:17:01.8566667+00:00
VRISHABHANATH PATIL 3,220 Reputation points Microsoft External Staff Moderator
1 answer

how to fix below question in azure sql data base i am already created table

Req 8: Crate a pipeline to move data from on premises CCardTrans table into Azure SQL DB by creating a new table, when pipeline runs for the first it has to move all the rows from the source table, but if you rerun the same pipeline it should not process…

Azure SQL Database
asked 2025-12-13T18:26:16.1533333+00:00
subhashini panidepu 0 Reputation points
commented 2025-12-26T03:24:58.0866667+00:00
VRISHABHANATH PATIL 3,220 Reputation points Microsoft External Staff Moderator
3 answers

Unable to Enable CDC on Azure SQL Database Using Server Admin Login - Error 22902 "Caller is not authorized"

We are unable to enable Change Data Capture (CDC) on our Azure SQL Database despite using the server-level admin login (DBAdmin) and Entra ID service administrator. Steps Performed: Connected to the master database using the SQL server admin login . …

Azure SQL Database
asked 2025-12-17T14:14:54.9166667+00:00
RM 0 Reputation points
commented 2025-12-25T20:09:32.4933333+00:00
Pilladi Padma Sai Manisha 1,000 Reputation points Microsoft External Staff Moderator
3 answers

How to export an Azure SQL Database when subscription is disabled?

Hi everyone, I have an Azure SQL Database on a subscription that was unexpectedly disabled. Attempts to export via the Azure portal, sqlpackage, and SSMS all fail with “login failed.” Access from the app is also blocked. I need to recover the full…

Azure SQL Database
asked 2025-12-24T20:51:39.9766667+00:00
Active Nights Out 0 Reputation points
commented 2025-12-25T19:33:41.6833333+00:00
Pilladi Padma Sai Manisha 1,000 Reputation points Microsoft External Staff Moderator
3 answers

Issue with Query Store Showing “Restricted Text” in Azure SQL Managed Instance

I am experiencing an issue with Azure SQL Managed Instance where some of the long-running queries in Query Store are displayed as “Restricted Text” instead of the actual query text. Details: Environment: Azure SQL Managed Instance I have admin access,…

Azure SQL Database
asked 2025-12-17T19:00:48.9733333+00:00
Aditya Rangineni 0 Reputation points
commented 2025-12-25T18:24:30.76+00:00
Pilladi Padma Sai Manisha 1,000 Reputation points Microsoft External Staff Moderator
1 answer

Unexpected billing for the Azure SQL Database Service tier Basic

Hi, I have been using the Azure SQL Server Database with the Basic level service tier for many months now. But just for the last month I got the bill of around 200 Euros and the bill was for the SQL Database Single/Elastic Pool General Purpose - SQL…

Azure SQL Database
asked 2025-12-09T21:50:29.61+00:00
Muhammad Usman 0 Reputation points
commented 2025-12-25T17:10:04.63+00:00
Pilladi Padma Sai Manisha 1,000 Reputation points Microsoft External Staff Moderator
2 answers

SSMS 22 Azure validation and weird email address

I installed SSMS 22 today, and when I try to connect to an Azure SQL Database and server, I get the following prompt with some weird email address. I have NO idea where it is pulling that from. I have ZERO issue with SSMS 21, but with SSMS 22 this is an…

Azure SQL Database
asked 2025-12-11T23:24:16.3466667+00:00
Scott Klein 35 Reputation points
commented 2025-12-25T13:45:07.46+00:00
Manoj Kumar Boyini 2,435 Reputation points Microsoft External Staff Moderator
2 answers

Azure SQL Serverless cost

On Azure SQL Serverless - Will I be charged per second even when 4-5 users are connected via SSMS but not querying? Most of the time people are connected via SSMS have few query windows open, but not much of actual querying. This is a follow up question…

Azure SQL Database
asked 2025-12-23T15:01:04.9033333+00:00
RJ 366 Reputation points
commented 2025-12-24T15:40:18.41+00:00
Erland Sommarskog 129.8K Reputation points MVP Volunteer Moderator
3 answers One of the answers was accepted by the question author.

How to export an Azure SQL database?

How to export an Azure SQL database? 如何导出azure的SQL数据库? 我已阅读过相关文档,搜索相关问题,问过AI,均没找到解决方案 I have reviewed the official documentation, searched for related issues, and consulted AI tools, but I have not been able to find a viable…

Azure SQL Database
asked 2025-12-21T12:23:01.5733333+00:00
苏钰 20 Reputation points
commented 2025-12-24T09:54:59.6433333+00:00
Erland Sommarskog 129.8K Reputation points MVP Volunteer Moderator
2 answers

Accidentally deleted azure sql database

Database: DaySpringCare Server: spotlighthealthcaredatabaseserver.database.windows.net Deletion Time: 2025-12-17 ~12:00 UTC BUSINESS IMPACT:Critical business data lost due to accidental resource group deletion REQUEST Point-in-time restore of…

Azure SQL Database
asked 2025-12-20T08:16:40.47+00:00
Bernard Mensah 0 Reputation points
commented 2025-12-24T04:38:13.75+00:00
VRISHABHANATH PATIL 3,220 Reputation points Microsoft External Staff Moderator
4 answers

What is the best way to design a database schema for comparing educational institutes with multiple criteria?

I am working on an education-related project where I need to store and compare information about multiple higher education institutes. Each institute has different attributes such as approvals, location, course offerings, placement statistics, fee…

Azure SQL Database
asked 2025-12-20T09:18:44.9366667+00:00
Gunjan 0 Reputation points
commented 2025-12-24T04:34:51.0766667+00:00
VRISHABHANATH PATIL 3,220 Reputation points Microsoft External Staff Moderator
3 answers

How to Log Actual Application Admin Users in Azure SQL Audit Logs Instead of the Authenticated Entra ID Admin

Hey everyone, I hope you’re all doing well. I’m running into an issue related to Azure SQL audit logs, and I’m a bit confused about the best way to approach it. The problem is that an Azure SQL Server has one Entra ID admin user, and we use that user to…

Azure SQL Database
asked 2025-12-20T19:56:46.5166667+00:00
Zain 20 Reputation points
commented 2025-12-24T01:11:27.83+00:00
VRISHABHANATH PATIL 3,220 Reputation points Microsoft External Staff Moderator
1 answer

Azure SQL Database Hyperscale Serverless

I have a database in Azure. It's an SQL Database that runs only one process per day, just one in 24 hours. When this process runs, it consumes a lot of DTUs and CPU, requiring approximately 4 to 6 vcores. Therefore, I configured this database with a…

Azure SQL Database
asked 2025-12-10T12:50:29.5466667+00:00
Fernando Gutierrez 325 Reputation points
commented 2025-12-23T09:41:06.4933333+00:00
VRISHABHANATH PATIL 3,220 Reputation points Microsoft External Staff Moderator
4 answers

Cannot establish ODBC 18 Connection via Interactive authentication

I have been unable to create an ODBC interactive connection to an Azure database. The credentials work fine in SSMS and using the SQLCMD. The browser window opens and allows me to authenticate. I have tried using the ODBC manager (32-bit) as well as…

Azure SQL Database
asked 2025-12-08T16:01:05.7033333+00:00
P Christel 20 Reputation points
commented 2025-12-22T19:17:36.3933333+00:00
Pilladi Padma Sai Manisha 1,000 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Transaction log stuck at 100%

Transaction log stuck at 100% CHECKPOINT fails with error 5901 Log reuse wait shows REPLICATION intermittently Replication & CDC disabled Holdup LSN: (988323:4179272:5) Need backend cleanup of orphaned replication recovery unit.

Azure SQL Database
asked 2025-12-20T08:52:48.1166667+00:00
Mirajul 20 Reputation points
accepted 2025-12-22T14:34:29.58+00:00
Mirajul 20 Reputation points
1 answer

Database deployment using Azure DevOps when the database is on a private virtual network

I have got a SQL server database in azure on a private network; I would like to set up a database deployment function. As the database is no longer on a public endpoint. How can I deploy SQL changes onto the SQL server database without building a…

Azure SQL Database
asked 2023-02-06T11:33:35.9066667+00:00
MrFlinstone 731 Reputation points
commented 2025-12-22T08:34:44.6+00:00
Cardoner, David 0 Reputation points
2 answers

Error SQL71621: Azure Key Vault URI '' must be an well-formed, absolute URL

I have an Azure SQL Database using Always Encrypted with the Column Master Key being stored in Azure Key Vault. The project is in Azure DevOps and I am using the Azure SQL DacpacTask to deploy my releases to my dev and prod environments. I am using a…

Azure SQL Database
asked 2024-10-23T18:27:15.0666667+00:00
J B 0 Reputation points
edited an answer 2025-12-22T00:56:52.3833333+00:00
Greg Yvkoff 151 Reputation points
3 answers One of the answers was accepted by the question author.

Switch Azure SQL Provisioned to Serverless and back to Provisioned

Hi  Can we switch Azure SQL from "Provisioned" to "Serverless" and back to "Provisioned" without any data loss / minimal downtime?  Wanted to observe how serverless works for a week. Data should never be lost while switching…

Azure SQL Database
asked 2025-12-17T20:15:24.1066667+00:00
RJ 366 Reputation points
commented 2025-12-18T22:07:25.0533333+00:00
Erland Sommarskog 129.8K Reputation points MVP Volunteer Moderator
1 answer

Performance improvement in Azure SQL Database

Hi, Our Azure SQL Database is configured with Standard-series (Gen5). Most of the time, we experience performance issues, as shown in the attached snippet. Could you please guide me on how to track down the root cause and suggest possible…

Azure SQL Database
asked 2025-12-18T07:34:19.3733333+00:00
MAGUDEESWARAN, THARUNKUMAR 0 Reputation points
answered 2025-12-18T08:03:47.4+00:00
VRISHABHANATH PATIL 3,220 Reputation points Microsoft External Staff Moderator