Stack Overflow
Stack Overflow

Questions tagged [azure-sql-managed-instance]

258 questions
22
votes
4 answers

Does or does not SQL Azure support CLR assemblies?

We've got a couple of on-premises dbs and we're seeing if we can migrate them to SQL Azure. Some of those dbs have a couple of user defined functions written in C# in an assembly (SAFE). After running a search, I've found a couple of posts which…
Luis Abreu
  • 4,008
  • 9
  • 34
  • 63
15
votes
3 answers

What extra one gets by selecting Azure SQL Managed Instance vis-a-vis Azure SQL DB PaaS

I would like to know what extra benefits one get by choosing Azure SQL Managed Instance compared to Azure SQL DB PaaS. I know SQL Managed Instance is offered as a vCore based purchasing model only. Apart from this what is the extra add on and…
Pallab
  • 1,915
  • 2
  • 19
  • 46
13
votes
1 answer

What is the difference between Azure SQL Database Elastic Pools and Azure SQL Database Managed Instance?

Azure SQL Database has two similar flavors - Managed Instance and Elastic pools. Both flavors enables placing multiple databases that share the same resources and in both cases can be changed cpu/storage for entire group of database within the…
Jovan MSFT
  • 13,232
  • 4
  • 40
  • 55
5
votes
0 answers

ODBC Driver 17 for SQL Server TCP Provider: Error code 0x68 [104]

I have a flask-sqlalchemy project running on an Azure Web App Service plan using a Linux machine. It is connecting to an Azure SQL DB (SQL Server). Intermittently I am receiving the error below: sqlalchemy.exc.OperationalError:…
Robert Riley
  • 389
  • 1
  • 7
  • 31
4
votes
3 answers

How to take backup of azure SQL-Managed Instance backup to azure blob

I am having a SQL-Managed Instance database now I wanted to take backup in .bak format to blob storage. The current Command I am using is WITH IDENTITY = 'SHARED ACCESS SIGNATURE' , SECRET = 'Pasted my sas token generated from azure portal blob…
Gaurav Modi
  • 51
  • 1
  • 2
  • 3
4
votes
2 answers

Using Entity Framework 6 / EF Core inside SQL CLR

Microsoft Azure Tech support has confirmed that all version of .Net 4.XX including 4.7.2 is supported in SQL Server Managed Instance CLR. We're transforming some portion of Business layer with 4.7.2 and latest EF 6.2 Use Entity Framework in CLR…
Abhijeet
  • 13,562
  • 26
  • 94
  • 175
4
votes
2 answers

How to apply Azure Hybrid Benefit to Managed Instance?

With Azure Hybrid Benefit (AHB), the existing on-premises SQL Server licences can be converted into `40% discount on the price of Azure SQL Managed Instance. If a Managed Instance is already created without AHB, how to apply Azure Hybrid Benefit on…
Jovan MSFT
  • 13,232
  • 4
  • 40
  • 55
4
votes
1 answer

How to cancel restore command in Azure SQL Managed Instance

When the RESTORE command is executed on Azure SQL Database Managed Instance it cannot be stopped because this is executed asynchronously: RESTORE DATABASE wwidb FROM URL = …
Jovan MSFT
  • 13,232
  • 4
  • 40
  • 55
4
votes
1 answer

Can the NSG be applied to the Subnet AFTER the Azure SQL Managed Instance is deployed into the subnet?

Can the NSG be applied to the Subnet AFTER the SQL MI is deployed into the subnet? https://learn.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance-vnet-configuration We are getting the following error when saving: “Failed to save…
Janos Kralik
  • 41
  • 1
  • 2
3
votes
1 answer

How to use terraform to store connection string from SQL Managed Instance in Azure Key vault

I am using terraform to deploy a SQL managed instance and need to store the 4 connection strings that come with it in azure key vault. According to terraform documentation for SQL managed…
mattymac
  • 33
  • 1
  • 3
3
votes
2 answers

Is there anyway to connect to Azure SQL Server using jTDS with TLS 1.2?

Our Java app use jTDS 1.3.1 to connect to SQL Server, which works fine until a client trying to put the database on Azure SQL. The connection failed with the following exception: java.sql.SQLException: Reason: Login failed due to client TLS version…
user2552742
  • 312
  • 4
  • 13
3
votes
3 answers

How to get size of Database in Azure SQL Managed Instance using Azure Management Fluent API?

Is there any way to get size of database in SQL Managed Instance in Azure using API for Azure management (Microsoft.Azure.Management.ResourceManager.Fluent.dll)? Or maybe with another API? The way of SQL queries is not possible for us, because we…
Miroslav Vanický
  • 39
  • 4
3
votes
2 answers

Cross Database Queries in Azure Synapse, Azure SQL Database, Azure Managed Instance and On Premise SQL Server

We are looking at options for moving our on premise SQL Server(s) to Azure and trying to understand whether we will be able to run cross database queries should we have data residing across multiple database technologies both in Azure ( specifically…
vavacious
  • 33
  • 1
  • 4
3
votes
0 answers

Azure SQL Managed Instance run Automation Account's notebooks

I have a notebook in an Azure Automation Account that I would like to call from SQL Managed Instance. Normally what I would do is to run: Start-AzAutomationRunbook ` -AutomationAccountName "some-aa-name" ` -Name "notebook-name" ` …
zimek-atomek
  • 413
  • 4
  • 14
3
votes
1 answer

How do you specify a serverless database in an ARM template in Azure?

How does one specify a General Purpose: Serverless tier for Azure SQL Database (Microsoft.Sql/managedInstances resource) in an Azure Resource Manager (ARM) template? What is the appropriate value for {“resources”: [{..., “sku”: {..., “tier”:…
nelsonSchwarz
  • 55
  • 4
1
2 3
…
17 18