Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [azure-sql]

Azure SQL Database is a general-purpose relational database-as-a-service (DBaaS) based on the latest stable version of Microsoft SQL Server Database Engine.

SQL Database is a general-purpose relational database managed service in Microsoft Azure that supports structures such as

  • Relational data
  • JSON
  • Spatial
  • XML

SQL Database delivers dynamically scalable performance within two different purchasing models: a vCore-based purchasing model and a DTU-based purchasing model. SQL Database also provides options such as columnstore indexes for extreme analytic analysis and reporting, and in-memory OLTP for extreme transactional processing. Microsoft handles all patching and updating of the SQL code base seamlessly and abstracts away all management of the underlying infrastructure.

Ask any question related to Azure SQL and read more at https://docs.microsoft.com/en-us/azure/sql-database/

99 questions
0
votes
1 answer

Azure SQL Watchdog for Analytics

unsure if the right place for my question. In the Azure portal there are many tools for Analytics and Monitoring; however they all seem to be for server related metrics such as CPU usage, query times, etc. I'm looking to write my own queries that…
gompertz
  • 113
  • 1
  • 4
0
votes
1 answer

Azure CLI list Azure SQL Server DB backups

I'm trying to make an automated script that restores from the latest LTR backup of an Azure SQL server database. Using this command: az sql db restore --dest-name $newdbname --name $dbname--resource-group $resourcegroup --server $servername In docs…
robliv
  • 101
  • 1
0
votes
1 answer

Azure Monitor Metrics

About 4 weeks ago we had a development SQL database on azure and it was great as we could see the CPU and other information. After doing what we needed to do to make our database work with Azure, we created a new resource group, and SQL database…
Rodney Ellis
  • 101
  • 2
0
votes
2 answers

Backing up Azure SQL Server databases to external destination

I run a bunch of Azure SQL Server databases, and they are backed up internally in Azure to storage. This is great for most cases. However, to mitigate risk (if for example, we lose access to the azure account), I would really like to back it up to…
Kjensen
  • 1,039
  • 10
  • 28
  • 39
0
votes
1 answer

how to restore Azure Database for MySQL in azure using data factoryy Destination data store

i want to save data from Destination data store via data factory to blob or some other storage in azure cloud and then get it back to Azure Database for MySQL , but the only options in the UI screen data factory->Author & Monitor ->Destination data…
Omer Anisfeld
  • 111
  • 4
0
votes
1 answer

Error While Creating Azure SQL Server Failover Group

I am trying to implement a failover group in Azure for my SQL servers but I am getting this error while doing so. Further, I have question too. I got to know that Secondary Server should not be in the same region, but I am anxious to know whether it…
hiFI
  • 101
  • 2
0
votes
1 answer

can't connect to my sql DB server

I'm trying to connect to my sql DB in azure with my primary username and password (I don't have any other username and password) and its failed. I'm 100% sure I entered the right username and password. is there anything I can do to connect my…
Itzik Vaisman
  • 1
0
votes
1 answer

Azure Key vault, getting suffice permissions to develop/administrate a customers environment

I need to administer azure key vault for a client to store VM creds, Data Factory creds, SQL creds etc. I have guest account access to their environment, setup with contributor access to the azure subscription we are building the solution in. What…
Font_writing_code
  • 3
  • 2
0
votes
0 answers

Azure mysql server portal shows 150 GB extra used space than actual db size

I'm using azure mysql database, Azure portal shows total of 350 GB of used space but when I analyzed using schema inspector the total size used is 205 GB. what might be cause of extra storage. My assumption are, Azure redundancy Server parameter…
Aki Lan
  • 1
0
votes
1 answer

Autoscaling Azure SQL Database

I'm looking to set up some type of method to autoscale (vertically) my Azure SQL Databases based on CPU or some other performance metric. My environment is in govcloud and I don't see any options for autoscale. I've create a logic app that will…
jrd1989
  • 698
  • 15
  • 48
0
votes
1 answer

Azure Webapp and SQL Secure networking

I believe i'm trying to do simple pretty basic with Azure, yet so far I didn't found anything "safe". Basically, I just want to have a Azure WebApp and a Azure SQL Server (no VMs) communicating to each other, the WebApp been public on internet, and…
frank
  • 133
  • 1
  • 1
  • 5
0
votes
2 answers

Convenient way to dump Azure SQL DB database

Using geo-replication is a nice way of duplicating data but it requires the two servers to be registered on the same Azure account. That could be a potential security risk if an employee decides to log in and delete both servers. In that case there…
judehall
  • 123
  • 5
0
votes
1 answer

Pricing for SQL database/ per SQL server

I'd like to know if I'm doing something wrong about Price Tiers and SQL Databases. Is the price paid per server or per database? I thought it was per database, só if I get a client, they can pay X per as a sample a 10 DTU sql server, and inside I…
Karko
  • 1
0
votes
2 answers

AZURE SQL DATA IMPORT

I want to move data from one azure sql database to new azure sql database. From the first one I have exported .bacpac file. I import it to the second one and I get Import operation for failed. ErrorCode: N/A ErrorMessage:…
Marek Szmalc
  • 101
0
votes
1 answer

Azure ARM Template - multiple Microsoft.Compute/virtualMachines/extensions for VM

I am trying to do auto restore of a bacpac to azure mssql VM when it is provisioned but failing to do so using custom scripts extensions. I generated the Azure MSSSQL VM ARM template using automation scripts in portal and If I see this in detail, i…
Rajan Bhayana
  • 53
  • 1
  • 9
1 2 3
4
5 6 7