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
1 vote
0 answers
18 views

Sustained substantial increase in Logical Writes for all plans & dbs on an Azure Managed Instance

We habe a managed instance with a 12 or so dbs supporting the same application across 2x customers. This has been running find on a 4-core sql managed instance, but at almost exactly midnight local ...
user avatar
1 vote
2 answers
48 views

Azure SQL - altering MAX DOP value at Database scope level is not taking place

I am trying to change the MAX DOP value for my Azure Managed SQL which currently is set to ZERO. Here is the script I am running: USE [my-sql-db] GO ALTER DATABASE SCOPED CONFIGURATION SET MAXDOP =5 ;...
user avatar
  • 221
0 votes
0 answers
16 views

Migration SQL managed Instance DB to another tenant SQL MI

I am stuck with a SQL migration between 2 tenants. Any help will be really appreciated.  There is one SQL Server managed instance TDE enabled is sitting in one tenant and we have to move the same to a ...
user avatar
  • 1
0 votes
0 answers
15 views

High usage on Azure log analytics

I have a relatively simple web app set up with a SQL database, and we have log analytics. We have "Auditing" turned on for the SQL server, and for some reason I'm seeing 2.8GB of usage a day ...
user avatar
  • 1
0 votes
1 answer
60 views

In ADF, are copy data activities wrapped in transactions?

I have a copy data activity that is moving data from a managed instance to a sql database. The flow of the process is: truncate a staging table on the sql database as a distinct activity call a ...
user avatar
  • 101
1 vote
0 answers
45 views

Drop external table in Azure Managed Instance

We moved a database from on-prem to Azure Managed Instance. But now we can't use External Tables, so we're taking a different approach. Is there a way to drop the external tables so I can use the ...
user avatar
1 vote
1 answer
47 views

Azure Database Performance Throttling - Use Replication or?

We keep a "rather large" azure database where we load all of our company data into every night. It uses temporal tables to keep track of changes to the data Now we want to start reading this ...
user avatar
  • 113
3 votes
1 answer
90 views

SQL Server Data Tools -- Stopped connecting to Azure SQL DB

All updates are installed on VS 2017 (15.9.47) and 2019 (16.11.13) I am trying to perform a data comparison between two DB's via Microsoft’s tool , On Prem and Azure SQL managed instance Everything ...
user avatar
  • 31
-2 votes
1 answer
48 views

What are the features that Azure VM based SQL server supports and the managed instance doesn't support?

I'm deciding on whether to install SQL server on azure VM versus configuring a managed instance. I understand that the following features are not supported by managed instance: SSIS SSAS SSRS Manual ...
user avatar
  • 2,375
0 votes
0 answers
32 views

Azure Key Vault Backup/Restore Across Subscriptions

I have 2 Azure SQL Managed Instances, each on a separate subscription. I am trying to see if I can take an Azure Key Vault Key used for TDE in one subscription and back it up to then restore to a Key ...
user avatar
1 vote
1 answer
32 views

Azure MI - clustered and nonclustered indexes with the same columns - different execution plans

I have a problem to understand why I am getting 2 different execution plans based on whether clustered index is involved or not. It's happening in Azure managed instance, I have no possibility to test ...
user avatar
  • 105
0 votes
0 answers
38 views

Full Text Index Crawler - MAXDOP - FT_IFTS_RWLOCK

We ran into a rather interesting situation regarding our Server and it's Full Text Catalog yesterday. I'm wondering if the experts here can shed some light on it as I've not been able to find ...
user avatar
0 votes
0 answers
51 views

Is there a way for a SQL Server Login to gain permissions from multiple groups?

I have a security solution that I am trying to build. But I am unable to get it to a state that I am happy with. I am hoping someone will be able to shed some light on the correct path or deny the ...
user avatar
4 votes
0 answers
155 views

Azure SQL Managed Instance - Reboots - places to look?

We have been seeing what appears to be reboots on our SQL Managed Instances (Standard, Failover Group). One node (the current primary, USEast) has been apparently rebooting for the last 24 hours, ...
user avatar
0 votes
1 answer
244 views

Row-Level Security with Azure AD Groups on Azure SQL Managed Instance

I have an Azure SQL Managed Instance on which I need to implement Row-Level Security on some tables to filter the data queried by some users. All my users authenticate with Azure Active Directory ...
user avatar
1 vote
0 answers
65 views

Data migration assistant showing breaking changes/ behaviour changes for SQL 2019 but not for Azure SQL Managed instance

I am trying to assess the potential issues while migrating a SQL Server 2012 on-prem database to Azure, with SQL on Azure VM and Azure SQL Managed instance as targets. For SQL on Azure VM, DMA is ...
user avatar
  • 111
0 votes
0 answers
127 views

Validation error while trying to migrate on-prem SQL Database to Azure SQL managed instance using Azure DMS

I have successfully created Azure Database Migration Project under Azure Database Migration Service during the last phase of the project I am getting validation error No valid full backup found for ...
user avatar
0 votes
1 answer
61 views

On-premises SQL to Azure SQL MI Migration

We have a requirement to migrate around 800 GB of data from on-premises SQL Server (2012 and 2017) spread across multiple databases to Azure SQL MI. We have run the DMA on the source data and have got ...
user avatar
0 votes
0 answers
41 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 ...
user avatar
  • 239
1 vote
0 answers
97 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 ...
user avatar
-1 votes
1 answer
26 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 ...
user avatar
  • 2,375
0 votes
0 answers
23 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 ...
user avatar
  • 73
0 votes
0 answers
14 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 ...
user avatar
0 votes
1 answer
108 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: ...
user avatar
1 vote
1 answer
261 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 ...
user avatar
1 vote
0 answers
32 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 ...
user avatar
1 vote
2 answers
1k 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)...
user avatar
  • 778
0 votes
1 answer
419 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 ...
user avatar
  • 778
1 vote
0 answers
186 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 - ...
user avatar
  • 778
1 vote
2 answers
105 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? ...
user avatar
0 votes
0 answers
27 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 ...
user avatar
3 votes
1 answer
452 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 ...
user avatar
  • 625
1 vote
1 answer
579 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 ...
user avatar
  • 131
1 vote
1 answer
1k 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 ...
user avatar
  • 131
0 votes
1 answer
422 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 ...
user avatar
  • 412
1 vote
0 answers
51 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. ...
user avatar
0 votes
0 answers
359 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: ...
user avatar
0 votes
1 answer
44 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 ...
user avatar
9 votes
3 answers
3k 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 ...
user avatar
  • 173
1 vote
1 answer
80 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 ...
user avatar
1 vote
1 answer
119 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 ...
user avatar
0 votes
1 answer
89 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 ...
user avatar
  • 131
0 votes
1 answer
92 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 ...
user avatar
  • 239
1 vote
1 answer
729 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 ...
user avatar
0 votes
1 answer
344 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 ...
user avatar
3 votes
0 answers
1k 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 ...
user avatar
  • 84
1 vote
2 answers
1k 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 ...
user avatar
  • 131
0 votes
1 answer
102 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 ...
user avatar
  • 239
0 votes
0 answers
186 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....
user avatar
0 votes
0 answers
44 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 ...
user avatar