6,401 questions with Azure SQL Database tags

Sort by: Updated
0 answers

Azure SQL Database Elastic Pool Upgrade: DTU to vCore (General Purpose Gen5) Cost Clarification

Hello Microsoft Support, I am planning to migrate an existing Azure SQL Database Elastic Pool configured with Standard 100 DTUs in the East US region to the vCore-based General Purpose tier using Compute Gen5. I have the following queries: vCore…

Azure SQL Database
asked 2025-08-04T13:47:13.24+00:00
Pradeep 20 Reputation points
commented 2025-08-05T04:02:59.24+00:00
Saraswathi Devadula 10,220 Reputation points Microsoft External Staff Moderator
1 answer

Azure - change to SQL Authentication

Good morning Azure team, I need assistance to change the Azure MS Entra for my SQL Server and database to SQL Authentication, I have tried everything, including deleting all policies, clearing caches, disabling the "Support only Microsoft Entra…

Azure SQL Database
asked 2025-08-04T12:08:24.1833333+00:00
Brenda 0 Reputation points
commented 2025-08-05T04:02:24.4733333+00:00
Saraswathi Devadula 10,220 Reputation points Microsoft External Staff Moderator
0 answers

Clarification on Environment Design – DB2 to Azure SQL Hyperscale Migration (80+ TB Load)

We are performing a large-scale data migration from IBM DB2 to Azure SQL Hyperscale, involving over 80 TB of historical data, using Azure Data Factory, SHIR, Databricks, and Kafka for CDC. We have a few architecture questions related to environment…

Azure SQL Database
asked 2025-08-03T07:27:42.0233333+00:00
Janice Chi 580 Reputation points
commented 2025-08-05T03:55:05.1166667+00:00
Mahesh Kurva 6,285 Reputation points Microsoft External Staff Moderator
1 answer

Azure SQL Hyperscale Partition Handling After ADF Copy from Parquet (Bronze Layer)

In our project, we are loading Parquet-partitioned data from the ADLS Gen2 Bronze layer into Azure SQL Hyperscale using Azure Data Factory Copy Activity (no data flow involved). This loading is part of a healthcare data migration involving ~80 TB…

Azure SQL Database
asked 2025-07-25T17:49:55.08+00:00
Janice Chi 580 Reputation points
edited an answer 2025-08-05T02:31:01.4+00:00
Mahesh Kurva 6,285 Reputation points Microsoft External Staff Moderator
1 answer

Can I access an Azure SQL database in another tenant/subscription when creating a mirrored Azure SQL database?

Is it possible for our customer to mirror an Azure SQL database located within our Azure Tenant when their Microsoft Fabric is in their own Azure tenant?

Azure SQL Database
asked 2025-08-04T11:03:39.7833333+00:00
Andrew HB 341 Reputation points
commented 2025-08-04T20:25:32.9366667+00:00
Oury Ba-MSFT 21,026 Reputation points Microsoft Employee Moderator
3 answers

Login Failed for user '<token-identified principal>'. (Microsoft SQL Server, Error: 18456)

I was booted off the server this morning and then when I tried to log back in, I keep getting the below error. I have not made any changes to my log in credentials. When I use the MFA verification, I get the text with the code and enter it, then get this…

Azure SQL Database
asked 2023-05-09T17:13:32.1466667+00:00
Megan Barnason 0 Reputation points
commented 2025-08-04T20:11:37.37+00:00
Isaias Zelaya 0 Reputation points
1 answer

Efficient Filtering, Sorting, Pagination, and Grouping in Node.js API with TypeORM Across Multiple Services

Context: I’m working on an API backend using a layered architecture: Controller → Service → Repository (TypeORM) The list endpoints support: Search Filter Sort Pagination Grouping Additionally, the frontend requires metadata in the response such…

Azure SQL Database
asked 2025-08-03T11:33:27.76+00:00
Maxime Beck 0 Reputation points
commented 2025-08-04T08:19:38.5+00:00
Mahesh Kurva 6,285 Reputation points Microsoft External Staff Moderator
1 answer

I have received retirement notice Upgrade Azure SQL Database 2014-04-01 APIs to a newer version

We attempted to deploy the Azure SQL Database policy template, but the deployment failed. Upon reviewing the error details, we identified the following issues: Unsupported API Versions for Database Advisors Several resources, such as database/advisors,…

Azure SQL Database
asked 2025-07-31T17:55:54.9833333+00:00
Shaikh Sameer Abdul Kalam 0 Reputation points
commented 2025-08-04T01:59:09.58+00:00
Mahesh Kurva 6,285 Reputation points Microsoft External Staff Moderator
1 answer

How to use Always Encrypted feature with temp table

Hi,We are using Always Encryption in our Azure SQL hosted database(PaaS) and when we are using temp table in an stored procedure which is being used to store and Join with encrypted table's column for UPDATE/INSERT operation, getting error : 'Msg 33293…

Azure SQL Database
asked 2024-07-09T08:03:52.1333333+00:00
Surapally Sravan Kumar 0 Reputation points
edited a comment 2025-08-02T09:01:44.3566667+00:00
VarunTha 14,860 Reputation points Microsoft External Staff Moderator
1 answer

Understanding the changes in the Root CA change for Azure SQL Database & Azure SQL Managed Instance

Hi Support, Ref Link: https://learn.microsoft.com/en-us/azure/azure-sql/updates/ssl-root-certificate-expiring?view=azuresql#frequently-asked-questions When must Azure Sql be completed? Is there a specific date? Why is there so little information about…

Azure SQL Database
asked 2025-07-28T04:09:53.7966667+00:00
FU JIE ZHAO 20 Reputation points
commented 2025-08-01T22:42:43.24+00:00
FU JIE ZHAO 20 Reputation points
2 answers

Database becomes unavailable when idle

Am very new to Azure SQL - indeed this is the first thing I've set up. I have a thrid party tool writing to the DB WF capturing tickets from our ticketing system that have passed through a particular status 'waiting approval' and writing a handful of…

Azure SQL Database
asked 2025-07-23T13:39:04.1933333+00:00
Leia Fee 0 Reputation points
answered 2025-08-01T09:11:48.86+00:00
Leia Fee 0 Reputation points
0 answers

The server principal is not able to access the database under the current security - Sql Managed Instance

Hello, We have recently created Azure Sql Managed Instance and after migrating database, we have one of the Synonyms which we are accessing using Azure Service Principal but it's throwing an error. Synonyms created in Database1 which is reference to one…

Azure SQL Database
asked 2025-07-21T22:42:09.98+00:00
Pds 46 Reputation points
commented 2025-08-01T08:39:00.7866667+00:00
Erland Sommarskog 124K Reputation points MVP Volunteer Moderator
1 answer One of the answers was accepted by the question author.

Change in database subscription tier overnight + spike in charges

The database subscription that I am using had a random change overnight and this caused a huge spike in my charges. If assuming it's due to the sudden changed from the Standard (S0) tier to the vCore-based purchasing model tier, may I please ask for…

Azure SQL Database
asked 2025-07-31T01:44:35.04+00:00
Trackify 20 Reputation points
edited the question 2025-08-01T03:50:24.5233333+00:00
TP 129.5K Reputation points Volunteer Moderator
1 answer One of the answers was accepted by the question author.

about permission, view server performance state denied in paas server database

i have read write permission to particular database in paas server, but while user run the update statement, it was throwing an error, like view server performance state denied, but when i try to give server performance state permission, throwing an…

Azure SQL Database
asked 2025-05-07T13:17:12.07+00:00
Naga Durga Devi Kannuri - Admin 40 Reputation points
edited a comment 2025-07-31T18:24:02.65+00:00
Oury Ba-MSFT 21,026 Reputation points Microsoft Employee Moderator
1 answer One of the answers was accepted by the question author.

Azure Managed Redis is down for 3 days in a row

Hey, On Saturday 26th of Jul at 2AM CET our Azure Managed Redis (not Azure Cache for Redis) started to have 100% CPU load and been having it ever since causing it to reboot from time to time and cause cache down time. We didn't deploy anything, we don't…

Azure SQL Database
asked 2025-07-28T11:22:34.8333333+00:00
Alexander Shvets 20 Reputation points
accepted 2025-07-31T17:01:40.58+00:00
Alexander Shvets 20 Reputation points
1 answer

CHANGE_TRACKING_CURRENT_VERSION is stuck in replica DBs

We have configured some databases in a Business Critical elastic pool And on those, we have change tracking enabled in a few tables. We use that feature to detect data changes (inserts, updated, etc) to our data and refresh some other resources…

Azure SQL Database
asked 2025-07-31T11:23:19.0533333+00:00
Roi Sanchez Riveira 0 Reputation points
answered 2025-07-31T14:27:56.72+00:00
Roi Sanchez Riveira 0 Reputation points
0 answers

Abort error with microsoft mysql

Hi Experts, I need some help. I am currently using the azure webapp and the azure sql database. Current the webapp is on B3 and the database is on standard with 10 DTUs and 2GB space each. The thing is that my metrics such as cpu and data io did not…

Azure SQL Database
Azure Static Web Apps
Azure Static Web Apps
An Azure service that provides streamlined full-stack web app development.
1,205 questions
asked 2024-04-02T03:43:14.4133333+00:00
Toh Yi Cheng 25 Reputation points
edited a comment 2025-07-31T11:15:52.6633333+00:00
RNareddy 2,505 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Guidance on Optimal Strategy for row_num and row_hash Partitioning at Scale (80TB+ DB2 Migration)

We are migrating 80TB+ of historical data from IBM DB2 to Azure SQL Hyperscale as part of a healthcare modernization program. As part of our reconciliation framework, we are validating accuracy using both row-count and hash comparison logic at a…

Azure SQL Database
asked 2025-07-24T11:37:39.3+00:00
Janice Chi 580 Reputation points
accepted 2025-07-31T09:29:41.4333333+00:00
Janice Chi 580 Reputation points
1 answer One of the answers was accepted by the question author.

Inquiry About Azure SQL Database API Version

Hello, I am trying to determine the API version for Azure SQL Database, but I couldn't find this information in the Azure Portal. Unfortunately, I am unable to utilize professional support at this time. Thank you for your assistance. Best regards,

Azure SQL Database
asked 2025-07-30T08:42:48.8466667+00:00
ny 20 Reputation points
accepted 2025-07-31T04:06:59.33+00:00
ny 20 Reputation points
0 answers

Backup State Failed with no log in Azure Managed Instance for Apache Cassandra

Backup State Failed with no logs in for a Cassandra Cluster in Azure Managed Instance for Apache CassandraPolicy is set to do the Backup at 14:00 with a retention of 4 hours. The only backup listed is marke as State "Failed" In Overview…

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,524 questions
asked 2024-04-23T11:30:07.58+00:00
alimagali 0 Reputation points
edited a comment 2025-07-31T03:14:37.5733333+00:00
RNareddy 2,505 Reputation points Microsoft External Staff Moderator