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.
52
questions
0
votes
0answers
29 views
tsql do update queries that join other tables lock the joined tables also?
Azure SQL Managed Instance. If I am updating a temp table, and joining to another table or tables, do the joined tables also get locked, even though the update statement is only updating the temp ...
1
vote
0answers
41 views
Extended events error in Azure Managed instance
I have setup extended events on Managed instance. Below are the steps followed:
create a master key
Create a credential for Azure Blob storage with shared access token
Create the extended event and ...
-1
votes
1answer
16 views
What is the equivalent of on prem ha dr solutions in the azure cloud PaaS and SaaS?
On prem ha dr solutions are:
Log shipping
Mirroring
Replication
FCI
AG
What is the equivalent of each of the above in the azure cloud PaaS (azure sql managed instance) and SaaS (azure sql ...
0
votes
0answers
24 views
Azure SQL Server DTU Percentage degrades over time with API Throttling
I've been facing a weird DB behavior when trying to post records to my api. I have a function that throttles requests at a request rate of 10-15 req/s, each request results in a lookup and an insert (...
0
votes
0answers
15 views
script to find info on Azure sql dbs,Azure mysql dbs
I would like to check if we have a powershell script which can fetch all properties of a particular service like logical servername, resourcegroup etc for all azure sql databases (PAAS) and azure ...
0
votes
0answers
8 views
How to make the Azure MySQL log events for Security Compliance
We currently in the process of the Implementing below Standards required.
https://www.cyber.gov.au/acsc/view-all-content/guidance/event-logging-and-auditing
Does anyone has any idea on how we can ...
0
votes
1answer
22 views
Shrink the data file on Azure SQL MI
I have a 600GB DB with 400GB free space in the data file on Azure SQL MI.
I am planning to shrink it and save the storage, but it's a critical DB with the user sessions.
There are two plans:
Plan A: ...
1
vote
1answer
58 views
Configuring Azure SQL Server and SQL DB instance with MFA/2FA for On-premise AD DS synched account
I've synched my OnPremise AD DS users into Azure using Azure AD connect.
How can I enable the user of my Azure SQL Server and Azure SQL DB instance to use MFA/2FA when connecting with SSMS using the ...
1
vote
0answers
21 views
Azure SQL DB and SQL MI Security Concerns
I have 7 different SQL Managed Instances, which were newly migrated over from SQL VM. I also have 7 different Azure SQL Databases, which were also newly created.
I want to make sure that I completely ...
1
vote
2answers
258 views
Maintenance Plan folder missing in SQL Managed Instance (via VM)
Accessing our new SQL Managed Instance via an Azure VM/SSMS, the Maintenance Plan folder is missing from the Object Explorer pane. Reading other posts (that all relate to other versions of SQL Server)...
0
votes
1answer
184 views
Changes to server configuration option remote access are not supported in SQL Database Managed Instances
Having just set up our new SQL Server Managed Instance, restored a sample database for testing, and run Azure's vulnerability assessment, it produces this high risk finding:
VA2120 - Features that ...
1
vote
0answers
136 views
Cannot use the special principal 'dbo' when addressing SQLMI risk VA2108
We've just set up a new SQL Managed Instance on Azure, and have restored a database to it for testing. After running an initial Azure Vulnerability Assessment, the results include this:
VA2108 - ...
1
vote
2answers
101 views
What is the best practice location for Memorize Optimization (OLTP) files?
Best practices for log and mdf files is to split across drives (e.g. G:\SQL Data & I:\SQL Logs).
What are the best practices for memory optimization files? Should they reside on their own drive? ...
0
votes
0answers
79 views
What could cause a slow DB connection between AWS and Azure?
Currently we are running with a piece of middleware and our SQL server in AWS. We are looking to move to Azure SQL managed instance. But I am experiencing severely increased insert times when using ...
0
votes
0answers
16 views
How to restore and overwrite an existing database on Azure SQL MI [duplicate]
We are trying to restore a backup file in Azure SQL MI using SSMS. the issue is we are trying to overwrite an existing database and we notice this feature is not present in SSMS for Azure SQL MI but ...
0
votes
0answers
20 views
Azure SQL MI PITR got failed
We were trying to restore a database on the same SQL MI with older date and different name but it got failed and we did get any information from the error message. This is also causing issue while ...
2
votes
1answer
299 views
Azure Elastic Pool - is it supported for MySQL?
I know that Elastic Pool in Azure is supported for SQL Server.
But I could not find any information if it is supported for MySQL.
I could not find any information in documentation at all what types of ...
1
vote
1answer
385 views
Can we configure logins to only connect to read-only replicas in Azure SQL Database automatically?
For Read-Only routing, rather than explicitly using "ApplicationIntent=ReadOnly" into our application connection string or for individual users to specify it in additional properties, can ...
1
vote
1answer
683 views
What is the SQL Server equivalent for Oracle character set AL32UTF8?
While porting data from oracle to Azure sql database I am facing the following issue where, empty data in Oracle is converted as ➞➞➞ in SQL Server
Pic1: Data as in Oracle DB;
Pic2: Data as in Sql ...
0
votes
1answer
303 views
How to query an Extended Events target file on a SQL Azure Managed Instance by using T-SQL?
I'm setting up an Extended Events trace in a Managed Instance (NOT Azure SQL DB) for the first time.
These are the steps I've carefully followed:
Created a Master key on my Database.
Created a ...
1
vote
0answers
40 views
SQL Managed Instance Restore to lower environments
I was trying to find an article or design pattern to fit my use case but I cannot find one.
My use case: I have a Production Subscription with a SQL Managed Instance that holds all production data. ...
0
votes
0answers
230 views
SQL Server Snapshot replication - Failing to start the Publisher snapshot agent
I am trying to set up a Snapshot replication using an Azure SQL Managed Instance. While trying to see the Snapshot Agent status, I see this error. Failed to connect to Azure Storage '' with OS error: ...
0
votes
1answer
36 views
Grant permissions to allow user to check if session is on read replica or not
Azure SQL Managed Instances offer access to read replicas from the availability group (in specific tiers at least).
I am writing a test script for our application to connect to read/write and read ...
9
votes
3answers
2k views
Restoring ANY database to Azure MI fails
Our freshly provisioned Azure SQL managed instance fails restoring backups from URL.
According to the server log the restore itself seems to finish after a certain amount of time but errors in ...
1
vote
1answer
71 views
Reducing table size during initial load with ADR in SQL Server
When a table is created, and loaded with data from scratch based on a file, the table size changes significantly when Accelerated Database Recovery is on in SQL Server (realized based on my question ...
1
vote
1answer
98 views
Table size in Azure SQL Managed Instance vs On Premise SQL Server
In doing a test, I have observed that the size of the same table with the same exact DDL (created from scratch) with the same exact data (10M rows) varies drastically in our Azure SQL Managed Instance ...
0
votes
1answer
74 views
Database level access in Azure SQL managed instance
In my Azure SQL managed instance I have two databases, Database_A and Database_B.
User A_ABC has access only to Database_A and he is part of role db_owner.
When the tries to alter a table we are ...
0
votes
1answer
75 views
Does setting Query Optimizer Fixes to ON enable Scalar UDF Inlining on a database with compatibility level 140?
Azure SQL Database Managed Instance. Current Compatibility Level is set to 140 to match on-prem SQL Server 2017 test and development server. I just read this article on Scalar UDF Inlining and was ...
0
votes
1answer
533 views
Backup from dacpac file extracted using SSTD
I tried method given in this answer by Ramankant Dadhichi but deploying failed.
Backup a database from Azure SQL Managed Instance and restore to on premise SQL Server
I have my database in managed ...
0
votes
1answer
304 views
Migrating Azure SQL database to Azure sql Managed instance
What are different options to move database from "Azure sql server" to "Azure sql managed instance", Looks like below options are not possible
1) Azure migration service - Not supporting azure sql ...
2
votes
0answers
862 views
DNS CNAME for a SQL Managed Instance (Azure)
I currently have an on Prem SQL Instance that has a DNS CNAME set up against it via our On Prem DNS Server.
I am looking to move this server to an Azure Managed Instance and I want to point the DNS ...
1
vote
2answers
801 views
Calculate size of the filtered rows of a table in sql server
My requirement is to know the size occupied(count of records and size in mb) by a table during every 24 hours, I found query to get the whole size of a table but not sure on where to start with or how ...
0
votes
1answer
85 views
SSMS 18.4 Error opening database properties dialog box Azure SQL DB Managed Instance
I have three databases in an Azure SQL DB Managed Instance. I am using SSMS 18.4. One database I can right-click, choose Properties, and the dialog box comes up normally. The other two databases give ...
0
votes
0answers
165 views
How to configure transactional replication for managed instance as a publisher and a subscriber for two different sql server at the same time?
The scenario is such that a subscriber is subscribed to transaction replication based publisher (distributor running on publisher).
I then want this subscriber to be a publisher to another subscriber....
0
votes
0answers
37 views
What happens to the transactional replication if azure sql Vm(publisher and distributor) is stopped and restarted from portal?
I am a newbie...I have azure sql vm and sql managed instance. I have setup transactional replication between them. Now if I stop the vm from the portal will the replication still continue after ...
1
vote
1answer
747 views
Does Azure SQL Managed Instance offer SQL Server 2016?
I want to create a SQL Server Managed Instance in Azure that is SQL Server 2016 so I can backup and restore databases across on prem and Azure - i.e. in case we want to back out of Azure, we can do a ...
1
vote
1answer
159 views
SQL server database Role management - Azure SQL MI
In my database I have multiple users with SQL server authentication login and AD login.
For ex: User 1 and user 2 are from same team(ABC), if I create a role db_abc
User 1 needs read access to table ...
0
votes
1answer
240 views
Change Azure Standard to Premium
I have one application using SQL Server Standard and would like the change to Premium, but I need to understand about the DTU. The application reaches 100% in DTU every day.
Would talk know if I need ...
2
votes
0answers
2k views
Linked server from Azure managed instance
I have my Managed Instance (MI) setup and can connect from SSMS on-premises. There is limited functionality this way (you only see databases and security) - so I have a VM in the v-net where I can ...
0
votes
1answer
880 views
Validate deployment failed deny policy in SQL managed instance Azure
I am trying to create a manged instance within an existing subnet in Azure. I have configured the subnet with the script provided by Microsoft which tells me the subnet is prepared.
When I create ...
1
vote
1answer
231 views
Add a DL as a login in azure sql managed instace
I am able to add individual AD logins as a login in azure sql managed instance, when i try to add a DL is the same way i am getting the following error.
error: Principal '' could not be found or this ...
0
votes
1answer
805 views
How to find total used and remaining space in Azure SQL mi
I queried sp_databases and the sum of space occupied by all db's was 380Gb. The total allocated space for the managed instance is 800Gb.
But, enquiring with the infra team found that we have only ...
5
votes
3answers
3k views
SQL Managed Instance - Cross Subscription Restores/Migration
Short Version:
I am trying to restore a backup from one SQL Managed Instance to another SQL Managed Instance. These are in different subscriptions. Using Example 3 from here I can at least get it ...
2
votes
1answer
485 views
Azure Managed Instance - Is it possible to send Sql Logs To Log Analytics?
Is it possible to stream a Managed Instances SQL logs into log analytics?
I need a single location for all Azure based monitoring so that multiple teams have visibility/access to log information for ...
5
votes
2answers
987 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 ...
5
votes
3answers
6k 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
3answers
973 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
133 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
443 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
1answer
20 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 ...