Questions tagged [azure]
Microsoft Azure is a Platform as a Service and Infrastructure as a Service cloud computing platform. Use this tag for database administration questions involving Azure. General server help can be obtained at Super User or Server Fault.
381 questions
-2 votes
1 answer
65 views
Azure Synapse dedicated pool high compute node memory
Queries are running slow on azure synapse dedicated pool and all the compute and control nodes' memory usage is touching 100%. Some days back, we restarted the pool (pause and resume) and noticed the ...
hassan ammar
0 votes
0 answers
78 views
Azure flexible database for mysql won't login, admin user access denied, and Entra fails
I have fully provisioned Microsoft Entra authentication on my Flexible Server but the AzureActiveDirectory plugin never loads. Specifically: Server version: 8.0.21 Region: East US 2 Actions taken (all ...
2 votes
1 answer
74 views
partition table by created - how to avoid pagination problem caused by partition by Created column
I'm dealing with a performance issue on a partitioned table in SQL Server. ⚙️ Table setup: The table is partitioned by Created (weekly), using a PARTITION SCHEME and PARTITION FUNCTION based on the ...
- 67
0 votes
2 answers
194 views
How to retain user logins & passwords when migrating Azure SQL Server database via BACPAC
I have a production application running on Azure with an Azure SQL Server and a SQL database inside it. In my application, all users are created at the database level with their passwords. I need to ...
0 votes
0 answers
70 views
How can I replicate data from a SQL Server VM in Azure to avoid recovery mode for reporting?
Currently, I'm using SQL Server on an Azure VM (DB B) to read from Power BI. DB B updates via log shipping from a primary SQL Server (DB A) and it locks me out from reading DB B two times an hour. I'...
- 11
0 votes
0 answers
59 views
Issues converting an XEL (Extended events file) to XML with the help of PowerShell in Azure automation Runbook
I need some advice to convert the XEL file to XML. I am executing a PowerShell script in Azure Automation runbook in Azure portal to store the XEL file from BLOB storage to my local machine, ...
1 vote
1 answer
646 views
Easiest way to GRANT SHOWPLAN in Azure SQL
So not an expert on Azure Portal, I mostly still connect with SSMS to these resources using EntraID etc. I have a need to grant a single user SHOWPLAN perms on a single database. When I look under the ...
- 91
1 vote
1 answer
667 views
How do I change ownership of database objects after migration of postgresql database in azure?
I migrated existing single server postgresql database to flexible server, I am encountering the below error when setting ownership like so, ALTER TABLE schema.table OWNER TO comm_user;and I am logged ...
- 13