Question : I’m deciding on whether to install SQL server on azure VM versus configuring a managed instance. I understand […]
Tag: azure-sql-managed-instance
Azure Database Performance Throttling – Use Replication or?
Question : We keep a “rather large” azure database where we load all of our company data into every night. […]
Table size in Azure SQL Managed Instance vs On Premise SQL Server
Question : In doing a test, I have observed that the size of the same table with the same exact […]
On-premises SQL to Azure SQL MI Migration
Question : We have a requirement to migrate around 800 GB of data from on-premises SQL Server (2012 and 2017) […]
Can we configure logins to only connect to read-only replicas in Azure SQL Database automatically?
Question : For Read-Only routing, rather than explicitly using “ApplicationIntent=ReadOnly” into our application connection string or for individual users to […]
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 […]
- 1
- 2