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