Azure SQL Database
An Azure relational database service.
6,820 questions
0 answers
Why does my Azure SQL Database with auto-pause enabled show recurring CPU spikes every 5 minutes overnight and is it generating billable compute time?
I have two Azure SQL Databases across two separate development stages: Dev 1 (serverless tier, auto-pause enabled) and Dev 2 (auto-pause disabled). Both databases are configured identically apart from the auto-pause setting. Both receive traffic from…
Azure SQL Database
asked 2026-04-16T20:57:22.55+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 89%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED4%3C/text%3E%3C/svg%3E)
Daniel-4204
225
Reputation points
edited a comment 2026-04-18T01:06:37.91+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 2%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Manoj Kumar Boyini
12,560
Reputation points Microsoft External Staff
Moderator
1 answer
How to connect Excel to Azure SQL instance using Entra MFA
Howdy! We have a Azure SQL managed instance with 3 databases. There is no public access, access is granted via Azure VPN and all users are required to use Entra ID with MFA enforced. Connecting with SSMS works absolutely fine. MFA is prompted via the…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,820 questions
asked 2026-04-17T00:02:11.16+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 69%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Matt Homewood
0
Reputation points
commented 2026-04-17T21:50:58.2533333+00:00
Manoj Kumar Boyini
12,560
Reputation points Microsoft External Staff
Moderator
2 answers
How to adjust the TimeZone of AzureDataBase
Currently, we are using Azure Database in Japan. In our tables, fields like UpdateTime and InsertTime are being recorded, but the times are stored in U.S. time. Is there a setting to make them match Japan Standard Time?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,820 questions
asked 2026-04-16T07:45:02.3433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 82%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
髙村 陸
20
Reputation points
commented 2026-04-17T15:39:47.44+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 24%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Pilladi Padma Sai Manisha
6,740
Reputation points Microsoft External Staff
Moderator
0 answers
Unable to disable Microsoft Entra-only authentication on SQL Managed Instance. Met with InvalidParameterValue error
We are unable to disable Microsoft Entra-only authentication on a SQL Managed Instance. Behavior: The API accepts the PUT request (HTTP 202 Accepted) but the async operation fails with:…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,820 questions
asked 2026-04-15T20:05:34.18+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 96%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Daniel Sanchez
0
Reputation points Microsoft Employee
commented 2026-04-16T23:05:54.9333333+00:00
Manoj Kumar Boyini
12,560
Reputation points Microsoft External Staff
Moderator
1 answer
Azure SQL Database Query Performance, misleading as it includes primary and standby data
Query Performance is including information for primary and secondary (note this is a business critical read-only replica, not a geo). Take a query ID provided, go to query store, it shows on Secondary, not Primary. This gives misleading information as…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,820 questions
asked 2026-04-09T15:16:48.2833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 52%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENW%3C/text%3E%3C/svg%3E)
Nancy Wotawa
0
Reputation points
commented 2026-04-16T10:55:59.68+00:00
Pilladi Padma Sai Manisha
6,740
Reputation points Microsoft External Staff
Moderator
0 answers
Migration from Azure SQL Database to SQL Managed Instance on Azure
We have around 100 database in Azure SQL database in an elastic pool. We want to switch for various reasons to SQL Managed Instance like better support for cross database queries. Our conditions are the following: We can only afford a short downtime…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,820 questions
asked 2026-04-16T07:16:14.2933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 13%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Georg Sieber
25
Reputation points
commented 2026-04-16T08:46:29.0833333+00:00
Ahamed Musthafa Careem
481
Reputation points
1 answer
Azure SQL logical server create/update stuck: Microsoft.Sql/servers/write failing repeatedly with InternalServerError (HTTP 500) in uksouth
Hi team, I am blocked on Azure SQL server provisioning and need guidance. I am deploying with Terraform, and Azure SQL logical server create/update keeps failing in a loop. In Activity Log, I continuously see: Update SQL server -> Started Update…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,820 questions
asked 2026-04-15T08:39:20.6733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 83%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Ayush Gupta
0
Reputation points
commented 2026-04-16T06:57:55.23+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 95%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Saraswathi Devadula
15,760
Reputation points Microsoft External Staff
Moderator
0 answers
Azure SQL Server Region Migration (Central India to South India) – Production Latency Issue
I need to migrate my Azure SQL Server and all databases from Central India to South India due to high latency affecting production applications. Current setup: Azure SQL Server with Elastic Pool ~60 databases Connected to 500+ client machines using…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,820 questions
asked 2026-04-12T06:07:42.75+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 37%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFA%3C/text%3E%3C/svg%3E)
Ferax AI Labs
0
Reputation points
commented 2026-04-14T20:06:17.54+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 49%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
SAI JAGADEESH KUDIPUDI
2,210
Reputation points Microsoft External Staff
Moderator
0 answers
Azure SQL Managed Instance database not visible in sys.databases but name still appears to exist
We ran into an issue on Azure SQL Managed Instance after a database drop operation. The database no longer appears in sys.databases, so from the normal catalog view it looks like it has already been removed. However: CREATE DATABASE using the same name…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,820 questions
asked 2026-04-14T16:04:38.1133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 87%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJO%3C/text%3E%3C/svg%3E)
João Paixão
0
Reputation points
commented 2026-04-14T19:19:02.7466667+00:00
Manoj Kumar Boyini
12,560
Reputation points Microsoft External Staff
Moderator
3 answers
One of the answers was accepted by the question author.
ExportDatabase stuck in CancelInProgress state for 2+ days — cannot trigger new export
Hi, I have an Azure SQL Database export operation that has been stuck in "CancelInProgress" state for over 2 days and I cannot trigger a new export. Operation: ExportDatabase - Status: CancelInProgress - Started: 2026-04-11 15:04:47 UTC -…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,820 questions
asked 2026-04-13T17:34:32.2466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 83%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Ahmed alkhairy
20
Reputation points
answered 2026-04-14T11:02:34.58+00:00
Ahmed alkhairy
20
Reputation points
3 answers
Improve SQL insert latency?
We had an Azure SQL Database running on the hyperscale tier provisioned with 8 vCores running on an Azure SQL Server to see how well it would perform with our application, which was running in an Azure VM in the same geographic area. The application…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,820 questions
asked 2026-04-08T20:25:25.8433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 61%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAW%3C/text%3E%3C/svg%3E)
Adam Weitzman
0
Reputation points
answered 2026-04-14T04:33:29.4833333+00:00
Saraswathi Devadula
15,760
Reputation points Microsoft External Staff
Moderator
3 answers
One of the answers was accepted by the question author.
Unable to move sql database to a different resource group
I go to the db in Azure I click "move" on the resource group Step 1 Source + Target appears and I choose a different resource group I click Next and I immediately get a screen that some resources can't be moved and under Errors it reads…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,820 questions
asked 2026-04-13T17:40:52.3233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 43%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Ryan Brown
20
Reputation points
answered 2026-04-13T19:51:30.3533333+00:00
Manoj Kumar Boyini
12,560
Reputation points Microsoft External Staff
Moderator
1 answer
Sql server used space started steadily increasing at a very quick rate
I am unsure of why my space usage is going up so drastically, please advise. My table usage only totals about 90GB, yet my used space is near 200GB. It increased almost 40GB in the matter of about 10 minutes and continues to grow. No data syncs or…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,820 questions
asked 2026-04-13T16:55:36.06+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 28.999999999999996%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Angelo Spaziani
0
Reputation points
answered 2026-04-13T19:32:12.7733333+00:00
Manoj Kumar Boyini
12,560
Reputation points Microsoft External Staff
Moderator
2 answers
Change Elastic Pool Location from Central India to South India
I would like to request assistance in changing the location of our Azure SQL Elastic Pool from Central India to South India. We recently evaluated performance from our application environment and observed a significant reduction in latency when using…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,820 questions
asked 2026-04-12T06:47:35.7133333+00:00
Ferax AI Labs
0
Reputation points
answered 2026-04-13T02:56:21.5066667+00:00
Saraswathi Devadula
15,760
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
Is it possible to connect to Azure resources via Entra password auth any more now that MFA is required by default?
Pretty much the title. Wondering if (via SSMS or other on-prem clients) Microsoft Entra Password authentication is still viable for connecting to Azure resources (SQL DB, MI).
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,820 questions
asked 2026-04-08T17:39:28.0066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 40%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFA%3C/text%3E%3C/svg%3E)
Folstad, Aaron
20
Reputation points
accepted 2026-04-09T17:31:49.92+00:00
Folstad, Aaron
20
Reputation points
0 answers
AzureSQL: Error executing a cross database query on the server with private endpoint
Hello, I'm trying to execute a cross database query on Azure SQLServer with multiple databases and run into error below: Any clue on how to go above resolving this? Msg 46832, Level 16, State 3, Line 93 An error occurred while establishing connection to…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,820 questions
asked 2025-06-20T23:27:34.55+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 74%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sachin S
36
Reputation points
commented 2026-04-09T12:53:31.5833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 86%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBL%3C/text%3E%3C/svg%3E)
Bihlmayer, Laurenz
0
Reputation points
1 answer
Deleted Azure SQL Managed Instance database recovery
Issue: On April 3, 2026, the original managed instance was unintentionally deleted and recreated. Two user databases were deleted with it: What we already tried: Azure portal > Managed Instance > Backups > Deleted backups Azure CLI…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,820 questions
asked 2026-04-03T20:24:04.4466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERV%3C/text%3E%3C/svg%3E)
Richard Vernon
0
Reputation points
commented 2026-04-09T04:13:42.0866667+00:00
Saraswathi Devadula
15,760
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
Issue with Defender for SQL recommendation – unable to load query results / baseline disabled
Hi, I am experiencing an issue with Microsoft Defender for Cloud related to the recommendation: “VA2108 - Minimal set of principals should be members of fixed high impact database roles” on an Azure SQL Managed Instance. Error: The Selected storage…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,820 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 56.00000000000001%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
4 answers
Login failed for user 'MyUser'. (Microsoft SQL Server, Error: 18456)
I haven't changed anything in Azure in over a year. All of a sudden, I can't access my sql server databases. From SSMS 2022 I get error "Login failed for user 'myUser'. (Microsoft SQL Server, Error: 18456)" From the Azure portal login, I get…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,820 questions
asked 2026-04-07T15:55:50.7433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 80%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
vmhatup
0
Reputation points
answered 2026-04-08T06:16:00.04+00:00
Saraswathi Devadula
15,760
Reputation points Microsoft External Staff
Moderator
2 answers
Using SSMA v10.0 on AzureSQL Managed Instance
I'm trying to use SQL Server Migration Assistant for Sybase, to migrate to an Azure managed instance. However, when I try to connect to the AzureSQL database, SSMS apparently tries to do a cross-database query, and gets the error: One of the internal SQL…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,820 questions
asked 2026-03-30T22:06:22.4033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 1%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHD%3C/text%3E%3C/svg%3E)
Hansen, David-E
0
Reputation points
commented 2026-04-06T16:51:16.9866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 37%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Santhosh Kumar Machukuri
0
Reputation points Microsoft External Staff
Moderator