An Azure relational database service.
SQL Server instance CPU persistently high
We have a database pool that has been running well, however since ~13 May the pool has been consistently high CPU. There is a lot of noise of legit queries, so I am showing smaller windows. The last hour looks like this. Zooming to a similar time period…
Azure SQL Database
Defender for Cloud VA2065 baseline buttons not responding for SQL Server vulnerability assessment
Summary: I am trying to remediate vulnerability finding VA2065 ("Server-level firewall rules should be tracked and maintained at a strict minimum") on an Azure SQL Server resource using Microsoft Defender for Cloud's Vulnerability Assessment…
Azure SQL Database
An Azure relational database service.
Troubleshoot SQL Database connectivity error 40613
On Azure SQL. We tried to do the preview restart. Still got the error that it could not connect to database. Ran the recommended cloud shell command for Manual Failover and still could not connect to database. Not sure what to do, since it looks like I…
Azure SQL Database
An Azure relational database service.
Unable to create Azure SQL Database on region East US
My Azure tenant is in East US region. I signed up for Fabric (which it created in East US region). I additionally have a Snowflake account (East US region), and I am configuring Snowflake-managed Iceberg tables in Azure OneLake (Fabric). So, to…
Azure SQL Database
An Azure relational database service.
SQL Server temporal tables - storing the user who deleted a row
Hi all; I am going to use temporal tables to keep a full audit trail of all changes to records in my key tables. One thing I have already implemented is each of those key record models implements: public interface IAuditTrail { /// <summary> …
Azure SQL Database
An Azure relational database service.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
How to set vulnerability assessment baseline or remove from baseline when portal buttons are unresponsive
Hello, I am working with Microsoft Defender for Cloud's SQL Vulnerability Assessment feature and need help with setting baselines for findings. Problem: I have two Azure SQL databases that show open vulnerability assessment findings. When I navigate to…
Azure SQL Database
An Azure relational database service.
vulnerability assessment baseline buttons not responding in Defender for Cloud portal
I am requesting assistance with the SQL Vulnerability Assessment baseline functionality in Microsoft Defender for Cloud. Issue: The "Add all results as baseline" and "Remove all from baseline" buttons on the VA2065 finding page are…
Azure SQL Database
An Azure relational database service.
I need to restore the deleted Azure SQL server and db. I could not restore using the Azure portal.
Session ID:da1f7f0674914bd8816c52e008876566 Conversation ID:8FXcwwXNyhFIE61Ng0WDck-us Activity ID:8FXcwwXNyhFIE61Ng0WDck-us|0000006 Correlation ID:8FXcwwXNyhFIE61Ng0WDck-us|0000000 PI Information<
Azure SQL Database
An Azure relational database service.
Login failed for user '<token-identified principal>' (I have spent many hours exhausting options)
Multiple App Service managed identities receive valid Entra tokens that are rejected by Azure SQL with "Login failed for user '<token-identified principal>'" even though: The DB user mapping exists with type EXTERNAL_USER The user's…
Azure SQL Database
An Azure relational database service.
Can not connect to Azure Database
TITLE: Connect to Database Engine Cannot connect to ebm-db-server.database.windows.net. ADDITIONAL INFORMATION: Database 'eRC-FirkusDB' on server '' is not currently available. Please retry the connection later. If the problem persists, contact…
Azure SQL Database
An Azure relational database service.
Azure database noy available
TITLE: An error occurred while changing the current database. Database 'eRC-FirkusDB' on server '' is not currently available. Please retry the connection later. If the problem persists, contact customer support, and provide them the session tracing…
Azure SQL Database
An Azure relational database service.
databases within a database pool are not available
TITLE: An error occurred while changing the current database. Database '<any in the pool>' on server '' is not currently available. Please retry the connection later. If the problem persists, contact customer support, and provide them the…
Azure SQL Database
An Azure relational database service.
Using GRS for Azure SQL Database Backups to a region with restricted access?
I´m wondering what happens if I setup Backup for an Azure SQL Database using GRS in Sweden Central without having applied to access for Sweden South (the paired but restricted region). Would the backup still be replicated to Sweden South? Would there be…
Azure SQL Database
An Azure relational database service.
Production database connectivity issues starting at 10:22am today
Our production database has connectivity issues for ~30 mins staring approx 10:22am today. I've run the diagnostic suggested by Critical insight - no issues found. I need to know what caused the issues so any underlying problems can be resolved.
Azure SQL Database
An Azure relational database service.
How to move Azure SQL from one resource group to other in the same Subscription ?
How to move Azure SQL from one resource group to other in the same Subscription
Azure SQL Database
An Azure relational database service.
Database Watcher Alert Templates Failing to Deploy
I've been trying to set up some database alerting via Database Watcher alert templates. Each time I try to deploy the templates, it fails with the following error message: { "status": "Failed", "error": { …
Azure SQL Database
An Azure relational database service.
Azure SQL Database not running on free tier despite overage billing set
Same question as this: https://learn.microsoft.com/en-au/answers/questions/5879850/azure-sql-database-remains-inaccessible-after-swit Except, FreeLimitExhaustionBehavior to BillOverUsage has been set at the start (few months prior) and consistently with…
Azure SQL Database
An Azure relational database service.
Need help recovering accidentally deleted Azure SQL Server, database, and resource group (Azure for Students)
I accidentally deleted my Azure SQL Server, SQL database, and the entire resource group from my Azure for Students subscription. Details: Server name: risu_dev Database name: risu_frame Region: Central India Subscription type: Azure for…
Azure SQL Database
An Azure relational database service.
SQL Elastic Pools Not Responding - Timeout error / unable to access table via SQL Management Studio
Hi We have a number of SQL pools that are having access issues. As you can see from the Resource utilization chart there are periods of missing "tracking" : Grant ******@brightlogic.co.uk
Azure SQL Database
An Azure relational database service.
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
An Azure relational database service.