Questions tagged [azure-sql-managed-instance]
The azure-sql-managed-instance tag has no usage guidance.
azure-sql-managed-instance
280
questions
0
votes
1
answer
53
views
Inconsistent Connections to Azure SQL Managed Instance with Fabric Notebook
I'm trying to connect to an Azure SQL Managed Instance with Microsoft Fabric Notebook using PySpark code. When I attempt to connect, I encounter the following error:
: com.microsoft.sqlserver.jdbc....
0
votes
0
answers
32
views
Azure Database Watcher connected to SQL Managed Instance does not show any SQL Managed Instances in Dashboard
I have configured an Azure Database Watcher (preview) to monitor a SQL Managed Instance. After starting the database watcher the Dashboards do not display any SQL Mananged Instance instances.
Here are ...
- 188
-2
votes
1
answer
61
views
Link server from on-premise Microsoft SQL Server to Azure SQL Server Managed Instance
I am trying to establish link server connection from Microsoft SQL Server which in on-premise to an Azure Microsoft SQL Server Managed Instance.
What steps are needed in creating the link server?
0
votes
1
answer
75
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....
0
votes
0
answers
56
views
How can I make my code retry when Azure SQL goes down for maintenance?
I am currently trying to do a bugfix on a large piece of existing software. The issue occurs when the application is running a long process overnight and loses connection due to Azure SQL managed ...
- 21
0
votes
1
answer
64
views
Issues with Azure web app to reach Azure SQL managed instance
I have an ASP.NET Core 8 Web API, and it needs to reach an Azure SQL managed instance that exists in other resource group.
I already peered the virtual network of the managed instance with my web app ...
- 1
0
votes
0
answers
69
views
SQL query hangs when trying to run any R code
So I am trying to run some R code as part of a SQL query, but it hangs no matter what I put in the R script.
See the below screenshot as an example (this script should list installed R packages, as ...
0
votes
1
answer
124
views
How can I export Azure SQL Managed Instance database to Azure storage using a script?
I want export multiple TDE encrypted database of a SQL managed instance one by one to Azure's Storage. I can do operation using SSMS's GUI. But it will be time-consuming to do 100s of databases one-by-...
- 3,302
0
votes
1
answer
130
views
Azure SQL Managed Instance - Private Link to one database connection
Is there a way to connect via Azure Private Link (PL) to Azure SQL Managed Instance (MI SQL) to one (chosen) database?
I have followed many tutorial (eg: https://techcommunity.microsoft.com/t5/azure-...
0
votes
1
answer
56
views
Stream Analytics - Output Device Messages Only Upon Change
I'm currently setting up a job that forwards IoT Device based Event Hub data (JSON payloads) for multiple devices to a database.
The job forwards to an SQL table right now which is great (easy part), ...
- 37
0
votes
0
answers
92
views
Connect managed instance from .net console 4.8 app
I am trying to create a .NET 4.8 console app (VS 2022) and establish a connect with managed instance in Azure.
I have followed the article https://learn.microsoft.com/en-us/azure/azure-sql/managed-...
- 175
0
votes
0
answers
73
views
Deleting a row in an MS Azure SQL Database table is block
I have a table with other tables linked by foreign keys and cascading delete. I can delete rows from the table - except one. It was used in a transaction where the host process crashed. I checked for ...
0
votes
0
answers
66
views
Azure SQL Managed Instance Connection with .net 4.8 api/svc host
We have a .net 4.8 application with api and svc host projects where our applications are hosted in Azure Virtual Machine (IIS), and our Databases are hosted in SQL Managed instance. They are in the ...
- 175
0
votes
1
answer
117
views
Connecting from Azure Synapse Analytics Spark Pool to Azure MI
I need to connect (Read/Write) to Azure MI through the synapse notebook. Part of the data lives in ADLS Gen2, that I need to migrate to MI. I want to schedule this notebook to execute daily.
currently ...
- 28
0
votes
0
answers
36
views
Powershell script error on hangfire install
I am trying to install hangfire db on my azure managed instance using powershell script through my devops pipeline.
Here is the script:
param(
[Parameter(Mandatory=$true, Position=1)][string]$...
- 175