Questions tagged [azure-sql-managed-instance]
258 questions
0
votes
1 answer
SQL 'Like' function - Clarification
In the below query, the result is 1. My doubt is why the first condition does not satisfy?
I thought that both the cases which are mere vice versa should have been same, so shouldn't the first case have been satisfied?
What am I getting wrong…
Venkat
- 47
- 7
0
votes
2 answers
How to change timezone of SQL server manage instance in azure?
I have created manage instance in azure using UTC timezone at time of creation. Now I want to change timezone to GMT. So is this any way to make timezone change of Manage instance SQL server?
NP007
- 659
- 8
- 21
0
votes
1 answer
Unable to connect Azure SQL Managed Instance datasource from Azure Search Service
I'm trying to use Azure SQL Managed Instance server (with public endpoint disabled) as datasource for Azure Search Service indexer. When I try to create indexer in Azure Search, getting below error.
A network-related or instance-specific error…
Santhanam
- 113
- 11
0
votes
1 answer
Azure SQL Database storage error, it shows a lot of unallocated error
The current specification of Azure SQL Managed Instance is 8vcore with Storage 1280 GB.
The issue is when I am going through the Size it shows me there is 380 GB of unallocated storage out of 1280 GB How can I allocate this storage.
Abhishek Jarwal
- 11
- 1
0
votes
2 answers
How to add two time values stored as decimal in SQL Server
I need to add two columns which stores time values as decimals
example:
1.) 8.30+0.32 = 9.02 (output should be 9.03 not 8.62)
The above mentioned example is working fine and is an actual output of the below SQL.
I wrote the below SQL which works…
Venkat
- 47
- 7
0
votes
2 answers
Restoring database in azure managed instance from one subscription to another
I have my production database in one subscription and dev/test database in other subscription. how can i restore database from production to test?
Priya Sharma
- 35
- 6
0
votes
1 answer
Export Azure Managed Instance Database backup to storage account
I am looking for an alternative to :
New-AzureRmSqlDatabaseExport
For the purpose of taking Managed Instance Database backup and export it to storage account. The above command, I think supports only SQL Server.
NaMo
- 513
- 1
- 6
- 19
0
votes
1 answer
How to change connect_timeout in Azure MySQL
I have Azure MySQL instance (managed instance) and I want to change connect_timeout in server options.
When I in MySQL Workbench do
SHOW VARIABLES LIKE 'connect_timeout';
The result is 'connect_timeout', '10'
the same result I get if I connect to…
Kristina Kucherova
- 31
- 1
- 4
0
votes
1 answer
How do you drop an in use database in Azure Sql Managed Instance?
When we ran Sql Server in a virtual machine we were able to use the following sql to drop in use databases.
use master
ALTER DATABASE [TargetDatabase] set single_user with rollback immediate;
Drop database [TargetDatabase]
According to the Managed…
leemicw
- 751
- 8
- 15
0
votes
1 answer
Sometime we need to open encryption key manually after failover and sometime not
I have migrated my database from on premises SQL server, using native restore from url, to managed instance and configured failover group to it. I have opened encryption key on both primary and secondary database but still sometime need to re open…
Priya Sharma
- 35
- 6
0
votes
1 answer
I am trying to connect to my azure managed instance(configured fail over group) using listener end point from SSMS
I have my data migrated to managed instance and configured fail over group. But not able to connect to my database using SSMS .I have also tried connecting by giving database name in options
Error:
A network-related or instance-specific error…
Priya Sharma
- 35
- 6
0
votes
0 answers
Why do my SQL Server calls sometimes stall for 14.3 seconds?
I have a web app running in Azure that was working fine for a couple of years. It's been connecting to a MS SQL Server instance that runs on a VM, mainly because part of it is a legacy app that needed features that Azure SQL didn't support. We've…
mherzig
- 1,528
- 14
- 26
0
votes
2 answers
How to grep dnszone from azure SQL Managed Instance connection-string
Requirement: To automate the deployment of azure sql mi and connect the web application to it.
Everytime I create sql mi it generate a random "dnszone" which I am unable to capture in file which I need to create a connection string using bash…
Raju
- 27
- 8
0
votes
1 answer
Azure SQL Managed Instance with private IP vitual nework
We have a Org policy which does not allow public IP for resource creation and because of that I am not able to create SQL Managed Instance as it takes public IP in Virtual network. Is there a way to configure the virtual network with private IP for…
Akhilesh Kumar
- 1
- 1
0
votes
1 answer
Consecutive While loops within a stored procedure in SQL Server
I am creating a stored procedure which contains two while loops consequently, the below mentioned is used for creating few temp tables and the next loop writes some data to it.
The temp table name is retrieved from a static table
Issue: the below…
Venkat
- 47
- 7