Questions tagged [azure-sql-server]
548 questions
-1
votes
1 answer
azure storage pricing for sql server in vm
I have created a SQL server 2016 virtual machine.
I have added 6 disks of 1 TB SSD each to my machine.
Is the pricing for each 1 TB disk the same as the premium storage disk (e.g. 148$ per month) or is there another pricing for the disks ?
asaf
- 958
- 1
- 16
- 38
-1
votes
1 answer
ARM Template - AlertRules - UnsupporedMetric
I am trying to create an ARM template to add alert metrics to my elastic pool database. I've done this manually in the portal and am using the ARM template generated from the portal.
Here is the ARM template:
{
"type":…
CtrlDot
- 2,463
- 14
- 11
-2
votes
1 answer
ASP.NET Core (Azure app service) application reruns Main() method if it's taking a long time
I want to get all the records from the database using EF Core and then save them to another database. I have 149541 rows in the database and I couldn't fetch them all at one time because it is very slow (maybe more than one hour) so I decided to do…
Alex
- 21
- 1
- 5
-2
votes
2 answers
Microsoft Purview - can it be used to monitor firewall rules across databases?
I have been looking for a solution, preferably native, to monitor changes to firewall rules across multiple Azure SQL databases hosted on different Azure SQL servers. While Azure Policy seemed to fit the bill initially, it later turned out to be…
Chethan S.
- 558
- 2
- 8
- 28
-2
votes
1 answer
Error when trying to delete the database in azure portal after removing from SQL pool
I am trying to delete a datapase in azure portal. After removing from SQL pool, I am getting the following error:
Msg 37106, Level 16, State 1, Line 7 The database '{databasename}' on server {'servername}' is in use by job account 'jobagent'. The…
user3247561
- 1
- 1
-2
votes
1 answer
Transfer data from Azure SQL VM to Azure SQL Database
Is there any fast way to transfer a large amount of data stored in a SQL database that is hosted on an Azure VM to Azure SQL database?
Regards
user1716729
- 387
- 1
- 6
- 19
-3
votes
1 answer
How to pass azure app service principal id to SQL Server using terraform
I have come across a situation, where i have to pass this {azurerm_app_service.app1.identity.0.principal_id to SQL Server inside User assigned managed identity? Any suggestion how to achieve that.
-4
votes
1 answer
Recommended Azure SQL Server Database Configuration
I have a web application that have 500 users. I want to migrate to Azure.
I need to know what options to choose in configuring the sql server database such as compute + storage, sql elastic pool, redundancy and pricing. What is the minimum setup…
h3n
- 5,142
- 9
- 46
- 76