Questions tagged [azure-sql-managed-instance]
The azure-sql-managed-instance tag has no usage guidance.
azure-sql-managed-instance
282
questions
0
votes
0
answers
18
views
Azure Managed Instance - how to do a cross-database service broker certificate
I have migrated processes from on-prem to Managed Instance. In one case I have an activated stored procedure (service broker) that does a cross-database query. I have no idea how this worked ...
- 1,316
0
votes
1
answer
41
views
Azure SQL analysts can create views from forbidden cross database data
TLDR Problem
User can view forbidden data by creating a view to the forbidden data in his own personal schema where he has CONTROL permissions.
Introduction
I have a Azure SQL (Managed Instance) ...
- 77
0
votes
1
answer
80
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
34
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
64
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
77
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
59
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
68
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
71
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
129
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,312
0
votes
1
answer
137
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
58
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
93
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