How to troubleshoot memory issues, either at the Elastic pool or database level?
We would like to request some assistance to monitor if our resources are experiencing memory-related problems, either within the Elastic pool or at the database level. PS - Based on common issues that we have seen from customers and other sources, we are…
Exporting SQL Database using Poswershell is failing
Exporting SQL Database using Poswershell is failing and getting below Error “The resource operation completed with terminal provisioning state failed”. Please help with PowerShell script. PS - Based on common issues that we have seen from customers and…
Getting error while connecting SQL Database. How to use JDBC to connect Azure SQL Database
Getting error while connecting SQL Database. How to use JDBC to connect Azure SQL Database PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help the Azure community.
SQL DB max storage expansion options beyond 5 TB
SQL DB max storage expansion options beyond 5 TB PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help the Azure community.
Why we are not able to reused the approved private link when exporting the DB and why always its get recreated
Why we are not able to reuse the approved private link when exporting the DB and why always its get recreated
SSMS UI bug (all versions so far)
Hello there, There is an annoying bug in the SSMS UI that I thought will be found and fixed with the latest version (19.0.1) I just installed. It persists in all the previous versions I used and is available here too. Here is the description: Connect…
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…
Change the 'remote query timeout' value to zero for one of our Azure SQL Database
We are required to change the 'remote query timeout' value to zero for one of our Azure SQL Database but not able to find any way to implement this change. For example, we can do it in SQL VM instance by using sp_configure system procedure but this…
Optimize Azure SQL Database Performance
Do we need to run update statistics after running rebuild index in Azure PaaS servers. We are currently running Rebuild index through runbook automation. Also need to know if we can get email notification on failure of Automation Runbook. PS - Based on…
Does the read-only replica have its own query optimizer separate from the primary?
How are the execution plans for the queries that run on the read-only replica created? Does the primary create the execution plans for both primary and read-only replicate or does the read-only replica have the ability to create the execution plan…
Facing an issue with enabling managed identity between a virtual machine (VM) and a Platform as a Service (PAAS) SQL server
I am facing an issue with enabling managed identity between a virtual machine (VM) and a Platform as a Service (PAAS) SQL server to authenticate to a SQL database without using a username and password. The troubleshooting steps taken so far include…
Azure SQL DB Export operations running for long time and timed out
We are experiencing an issue with an export operation getting stuck at 47% for 2 days, and the operation timed out after 48 hours PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help the…
Azure Web Application Connectivity Issue with Disabled Public Endpoint
After creating a private endpoint in US East, the Azure Web Application is working and connecting to the Azure SQL DB server (in other region). However, it is unable to access the data when the public endpoint is disabled PS - Based on common issues that…
SQL DB export to Storage Account with Private link is failing
I am trying to export the database to storage account which has following feature Tool or method used to export - Using Portal Attempting to backup/export db to Storage Account in same RG. Azure SQL DB is using Private Link Storage Account does not…
Earlier Point-in-Time Restore (PITR) Not Visible for Azure SQL Database in the Portal
Earlier Point in Time restore (PITR) is not visible for Azure SQL Database in the portal We needed an earlier restore point than the ones shown as available on this database. Unfortunately, we don't see restore points earlier than 20 of June, which is…
Scenarios for SQL Admin to Update Admin or User Password and Resolving Server Admin Password. Getting update Error
In what scenarios can a SQL Admin update the admin or user password? Getting below error when updating Server admin password Error- Cannot alter the login '<>>', because it does not exist or you do not have permission.Msg 15151, Level 16, State…
Enabling user authentication to connect Access front end to Azure SQL Database
I need to connect/link the tables in Access to an Azure SQL database using ODBC Driver 18 for SQL Server. I am trying to use New Data Source->From Database->From Azure Database to authenticate with either Azure AD Password or Interactive…
How to "restore" AdventureWorks .bak into Azure SQL Database
I'm trying to get the AdventureWorks dataset into a new Azure SQL Server Database, using the instructions here : https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms When I connect to the…
Azure MySql Database to power apps
Dear Azure Expert, I am new in Azure , I want to create table directly to Azure MySQL without using MySQL work bench, is it necessary? btw Im using powerapps I really want to migrate all my data from SP list to Azure, is there other way? Recommended…
Unable to purchase support plan
Hello, I am trying to purchase a support plan with Azure. I am unable to because I receive this message when choosing to purchase Developer support. This is preventing me from filing a support ticket for another issues I am having with a Azure…