I have a pair of Elastic Job agents running on separate Azure SQL Servers.

I have a pair of Elastic Job agents running on separate Azure SQL Servers.

I have a pair of Elastic Job agents running on separate Azure SQL Servers.

I have a pair of Elastic Job agents running on separate Azure SQL Servers.

I have a pair of Elastic Job agents running on separate Azure SQL Servers.

Problem:
The real problem I am solving is adding a permission to an account. Namely the SHOWPLAN. The account that I usually use to make changes to the database schema apparently does not have the ability to GRANT. The DBO account has the permissions to do a grant (I assume it does) but I do not seem to have the login for that in any of my notes. I figure there has to be a way from the Azure Portal to get to the login or a login of similar status.
The information related to azure especially things like permissions seems to be out of date to what is on the interface.
I tried using the Azure Data Studio’s connection but got the following error:

We are using Azure hyperscale DB Gen5 DB to store lots of data.

I’m experiencing an issue with my web API connecting to an Azure SQL Managed Instance. Here’s the situation:

I am trying to establish link server connection from Microsoft SQL server which in on prem to the Azure Microsoft SQL Server managed instance.
Please guide me on this.

I use SQL Server in various environments, including Azure services, virtual machines, and locally on my laptop. Although there is some information about the performance of these hosting environments, such as DTU metrics, virtual environment specifications, or physical machine specifications, I find it quite difficult to compare them.