All Questions
Tagged with azure-sql-managed-instance powershell
7 questions
0
votes
1
answer
25
views
How to see/extract SQL MI quota limits for all subscriptions/regions
The Azure Portal does not have anywhere to view the current SQL MI quota limits. Quota limits are set per Subscription/Region pair.
The Quota blade does not contain any of this information.
You may ...
- 598
1
vote
1
answer
55
views
How can I get the Status of an Azure SQL MI using powershell or REST API?
I am trying to get the status of Azure SQL MI however the Get-AzSqlInstance does not return the status. If running or stopped. What is the easiest way to get this?
0
votes
1
answer
188
views
Query a database inside Azure managed instance from Powershell
My initial code queries database in my Azure SQL server:
$sql = @{
Server = "$($sqlServer.ServerName).$($dbURI)"
Database = $db....
1
vote
2
answers
735
views
Publishing dacpac to Azure SQL Managed Instance from on prem SQL Server 2016 via PowerShell failing "cannot publish to SQL Server 2014"
I'm trying to publish a dacpac extracted from a SQL Server 2016 on prem server to an Azure SQL Managed Instance using the below PowerShell, but this fails to the error below.
SqlPackage.exe /...
- 11
0
votes
1
answer
537
views
Power BI Data Refresh from Azure Managed Instance
I have an Azure Managed Instance and a database that I am able to connect from SSMS and Power BI Desktop, port 3342, but I am not able to schedule a refresh from within the Power BI Service or MS Flow....
1
vote
1
answer
2k
views
How to check how long a DB restore took on Azure SQL Managed Instance?
I have just completed a DR test overnight to run a PITR on Azure SQL Managed Instance. This was for a fairly large DB (4TB). I did this by using the Azure CLI. Once I executed the command (see below) ...
0
votes
2
answers
2k
views
Runbook Powershell Invoke-Sqlcmd SQL Server MI connection
I have a some Powershell code to drop a database on a SQL Server Managed Instance that I would like to schedule via Azure Automation. The code runs fine in the Windows Powershell ISE.
#Type the ...
- 98