Questions tagged [azure-sql-managed-instance]

SQL Server Managed instance, a deployment option of Azure SQL Database providing compatibility with the latest SQL Server on-premises Database Engine with PaaS features and capabilities.

Filter by
Sorted by
Tagged with
5
votes
2answers
95 views

CLR Stored Procedure on Azure SQL Managed Instance error on execution: “Assembly in host store has a different signature than assembly in GAC”

I have a CLR stored procedure which executes correctly when deployed to local SQL Server instances from SQL Server 2012 - 2017. I can successfully deploy to an Azure SQL Managed Instance but when I ...
-2
votes
0answers
17 views

Azure SQL managed instance default isolation [duplicate]

What is the default isolation level for azure SQL managed instance?
3
votes
2answers
57 views

Backup a database from Azure SQL Managed Instance and restore to on premise SQL Server

I have three databases that I am migrating to Azure SQL Managed Instance. One is a Utility database, just a small collection of generic functions and procedures. One is the OLTP database for a web ...
2
votes
2answers
62 views

Restore DIfferential backup on azure managed instance?

I am migrating my database from on-premise to Azure managed instance. In order to move the database I'm using the organization weekly full backup, and I am asking them to take a diff after they take ...
0
votes
0answers
11 views

Azure Managed Instance MSOLAP OLE DB connector

We have a managed Azure SQL instance, and trying to leverage it for some Azure AS documentation. Managed Azure supports OPENROWSET which was going to be used to access DMVs in the SSAS tabular model, ...
1
vote
0answers
52 views

SQL Server Database auditing not working

I'm setting up auditing on a SQL Server Managed Instance in Azure (Version = Microsoft SQL Azure (RTM) - 12.0.2000.8). Following the instructions in the link, everything worked for server-level ...
0
votes
0answers
8 views

Details about existing roles and users in azure sql database

I would like to get details of all users existing in a sql server DB and the respective roles they are part of and the permissions granted/denied for the a role/user. what is the best way to get this ...
1
vote
0answers
146 views

How do I grant permissions for a SQL Server Management Studio user to access system.views in an Azure Managed Instance?

I am connecting to an Azure SQL managed instance with Active Directory through SQL Server Management Studio. I'm trying to access system views, like: SELECT * FROM sys.dm_db_missing_index_details ...
0
votes
0answers
27 views

How to know the size of data returned from a select statement using extended event in azure sql MI?

When a select statement is issued I would like to know the the query issued by the user and the number of rows returned along with the bytes/MB of data returned using extended events. With event ...
1
vote
0answers
49 views

How to Measure data consumed by an user in Azure sql server database?

For an Azure sql server MI, we have multiple external users consuming data, I would like to know how much data an user is consuming/extracting from the DB? Can this be checked from, 1.) From SSMS ...