Question : For Read-Only routing, rather than explicitly using “ApplicationIntent=ReadOnly” into our application connection string or for individual users to […]
Tag: azure-sql-managed-instance
Reducing table size during initial load with ADR in SQL Server
Question : When a table is created, and loaded with data from scratch based on a file, the table size […]
How to query an Extended Events target file on a SQL Azure Managed Instance by using T-SQL?
Question : I’m setting up an Extended Events trace in a Managed Instance (NOT Azure SQL DB) for the first […]
Maintenance Plan folder missing in SQL Managed Instance (via VM)
Question : Accessing our new SQL Managed Instance via an Azure VM/SSMS, the Maintenance Plan folder is missing from the […]
How to find total used and remaining space in Azure SQL mi
Question : I queried sp_databases and the sum of space occupied by all db’s was 380Gb. The total allocated space […]
Restoring ANY database to Azure MI fails
Question : Our freshly provisioned Azure SQL managed instance fails restoring backups from URL. According to the server log the […]
Grant permissions to allow user to check if session is on read replica or not
Question : Azure SQL Managed Instances offer access to read replicas from the availability group (in specific tiers at least). […]
SQL Server Data Tools — Stopped connecting to Azure SQL DB
Question : All updates are installed on VS 2017 (15.9.47) and 2019 (16.11.13) I am trying to perform a data […]
Managed backups in Azure SQL Managed Instance
Question : The Managed Instance allows the admin to ENABLE Compress backups at the instance level. Does that affect the […]
Does Azure SQL Managed Instance offer SQL Server 2016?
Question : I want to create a SQL Server Managed Instance in Azure that is SQL Server 2016 so I […]
- 1
- 2