Questions tagged [azure-sql-managed-instance]
258 questions
0
votes
0 answers
Managed Instance Connection Python
I have been using pymssql for a while with no issues. I can connect to on-prem and azure sql db.
However, we moved an on-prem db to azure MANAGED Instance and the same scripts don't work after altering the connect server variables.
conn =…
Robin Halabicki
- 37
- 2
- 8
0
votes
1 answer
Performance of using multiple filegroups in SQL Managed Instance
Similar to Azure single database (PaaS), Azure SQL Managed Instance does not allow referencing or creating physical files on disk. However, it does still support filegroups when restoring an on-premise backup that used them or by using the ALTER…
defect833
- 275
- 7
- 22
0
votes
1 answer
Does Azure charges for using VPN in SQL Database Managed Instance?
I am planning to use Azure SQL Database Managed Instance, but not sure if using VPN will be charged or not. Microsoft Doc's on this are quite confusing and doesn't clearly mention about VPN pricing.
Ayush Patel
- 11
- 3
0
votes
1 answer
Does user is charged for using azure managed instance in free trail period?
I am new to Azure. I have create Azure free account.
I like to migrate production database to Azure Cloud, and found Managed Instance as perfect choice (as per documentation). Before migration i want test it out, but not sure if this service is free…
Ayush Patel
- 11
- 3
0
votes
3 answers
How to connect Azure Managed Instance in Azure Linked service
I am trying to make the "Managed Instance" as destination in Azure Data Factory(copy data). But, I couldn't see any option to select "Managed Instance" in Linked service.
Here is the list of Azure supported data stores,
Source :…
Pரதீப்
- 91,748
- 19
- 131
- 172
-1
votes
1 answer
How to create custom Azure SQL alerts on T-SQL for bulk updates in Azure SQL DB and Azure SQL MI
How to create custom alerts on T-SQL for bulk updates in azure SQL db and Azure SQL MI.
Currently we can create Alerts in Azure Databade only on Metrics.
My requirement is to create alert on bulk data inserts/updates/deletes on any table in my db as…
-1
votes
1 answer
Service Broker not supported in Azure SQL managed instance?
Even Service Broker seems to be available for Azure SQL managed instance, I was able to activate it, when I run:
CREATE QUEUE ExpenseQueue;
, I get the error:
Statement 'CREATE QUEUE' is not supported in this version of SQL
Server.
Any idea how…
bjnr
- 3,353
- 1
- 18
- 32
-1
votes
1 answer
Azure SQL Managed Instance T-SQL query debugging
When trying to debug a T-SQL query within Azure SQL Managed Instance database from Visual Studio, I get an error:
Failed to start debugger and exception was generated: Data is null. This method or property cannot be called on null values
Followed…
-1
votes
1 answer
Azure SQL Managed instance latency to read replica
We are using Business Critical service tier for Azure Managed Instance and we are leveraging the read-only replicas heavily. How can I get some visibility into the latency between the read/write replica and the read replica?
Ultimately I would like…
Dep
- 1
-1
votes
1 answer
How to configure retention period for a Azure Blob folder?
How to configure retention period for a Azure Blob folder?
I want to set a 7 days retention period for SQL Server log backups in Azure. How to configure in Azure Blob Storage?
AVB
- 1
- 2
-1
votes
1 answer
How do Azure SQL scaling features change schema design?
In other words, how should schema design in Azure SQL differ from schema design for SQL on VM or hardware? What additional factors should the DBA consider when designing schemas for Azure SQL databases and managed instances?
In order to narrow the…
David Cobb
- 680
- 6
- 11
-1
votes
2 answers
Does Horizontal scaling(scale out) option available in AZURE SQL Managed Instance?
Does Horizontal scaling(scale out) option available in AZURE SQL Managed Instance ?
R0106
- 33
- 5
-1
votes
1 answer
Load data from a file to SQL Managed Instance
From what I understand SQL Managed Instance cannot access local or external file share.
We are trying to load data from a file to SQL Managed Instance, wanted recommendations on the best approach for that.
Kumar
- 11
- 1
-1
votes
1 answer
How to conditionally execute SQL code specific for Azure SQL Managed Instance?
I have a TSQL code where some parts are not applicable to Managed Instance. Is there a way to determine in
TSQL code is the code executed on Managed Instance and run the code only in that case?
Jovan MSFT
- 13,232
- 4
- 40
- 55
-2
votes
1 answer
Create Azure Data factory Linked service to SQL Managed Instance
I want to store data in a SQL managed instance database using azure data factory
in this case, I have to create a linked service to this database
but I get an error and I don't know how to go through
enter image description here
frexville
- 3
- 3