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/

92 questions
2
votes
2 answers

Azure automation runbooks access to Azure SQL Database

I am trying to run some SQL statements against my Azure SQL database using an Azure Automation runbook. In all examples I can find on https://docs.microsoft.com they are using an Automation credential and an connectionstring like in the code below: …
Andreas
  • 299
  • 1
  • 5
  • 15
2
votes
1 answer

Azure - can't remove SQL server

Something went wrong, I can't connect to Azure SQL server. I try to remove it but get an error: Failed to delete the server: ***. ErrorCode: 504 ErrorMessage: {"error":{"code":"GatewayTimeout","message":"The gateway did not receive a…
Oleg Sh
  • 123
  • 4
2
votes
2 answers

How to set up a nightly job that runs a script on Azure SQL?

I'm looking for a way to set up a nightly job that will run a small SQL Script, to rebuild fragmented indexes on an Azure SQL database. Resources I have found online seem to be either dated, or involve setting up the job on a local machine.
jackmott
  • 177
  • 1
  • 6
2
votes
1 answer

Azure SQL Elastic Pool: increase data size max GB with no downtime

We have an Azure SQL elastic pool with a data size max GB setting. We would like to increase this setting to a larger value. The question is: can you increase the size of the elastic pool max size with no downtime? Said differently, does changing…
A X
  • 382
  • 2
  • 8
  • 23
1
vote
1 answer

Is there any scheduled downtime with Azure DB?

With a standard SQL Server platform (with no replication or redundancy), some downtime is to be expected for weekly/monthly patching and reboots. Is this still the case for Azure DBs (elastic pools, serverless, managed instances, etc) ? Or can I…
userSteve
  • 1,503
  • 4
  • 20
  • 32
1
vote
2 answers

Query regarding Azure SQL database setup

I am new to Azure and I am required to create a Azure SQL database. So far I have created a Azure SQL server and post that sql database. Now my main concern comes as to how to access that database? do we really require a virtual machine for that?
NJ1
  • 21
  • 1
1
vote
1 answer

how to export Azure Database for MySQL server to blob?

is there a way to export Azure Database for MySQL server to a blob or a container ? my main goal is to keep the backup for over 35 days in blob/container and still be able to restore it after? i want to be able to save backups in the cloud and with…
Omer Anisfeld
  • 111
  • 4
1
vote
0 answers

What is the fastest way to backup an Azure SQL Server Database?

I have a medium sized database that is running within Azure. It is about 30GB. I used the Azure console to do an export to an Azure storage account- that seems to be the way to do it. However, it has so far taken 3 hours to backup 25% and has…
Rob
  • 111
  • 2
1
vote
1 answer

Change Azure Master Database Collation ARM Template

I'm deploying an environment in Azure using ARM Templates. I'm using Azure SQL Server and 4 databases. I went to restore a bacpac file and got an error complaining about different collation settings between my master database and the database my…
jrd1989
  • 628
  • 10
  • 35
1
vote
1 answer

How to minimize latency between Azure App Service and Azure SQL Database?

We have an Azure App Service application using Java Tomcat 8.5 running in West US Region. The Service Plan for this Service is Standard, Big. This App Service application is connected to a SQL Database Service that belongs to an Elastic Group also…
Daniel Ardison
  • 111
  • 1
  • 5
1
vote
0 answers

Azure SQL Built-in Backup not completing

I've configured the retention policy in 'Manage Backups' for my Azure SQL Server but nothing is appearing under 'Available Backups'. Does there need to be an associated storage account? If so, how do I set it up? Previously, I thought it was…
mpipe3
  • 271
  • 1
  • 2
  • 4
1
vote
2 answers

What's the difference between Azure Database Backup, Copy, and Export

I tried searching online for an answer to the above question but all I see are the long documentations on performing these operations. What I'm looking for is a brief description of how do the following operations differ and when one is preferred…
nam
  • 217
  • 1
  • 11
1
vote
1 answer

Unable to connect as a database contained user to an Azure SQL database

On my free trial Azure account, I'm working on Exercise 5 of this official Azure lab tutorial to work on the section Connect as a database contained user to an Azure SQL database. I've successfully created the ADSQLUser as described in the previous…
nam
  • 217
  • 1
  • 11
1
vote
1 answer

Unable to login to Azure SQL Server using Azure Active Directory account

Using Azure Trial Free account to practice on their lab tutorials. I'm not clear on steps 5 and 6 of Exercise 4 on this Azure Official Lab. When I login using ADSQLAdmin it says (as expected) account does not exist. 4. From the Azure Active…
nam
  • 217
  • 1
  • 11
1
vote
2 answers

Add Azure SQL Server in to Azure VNET

Is it possible to add Azure SQL Server into a Azure Virtual Network? Currently I see only a separate firewall for SQL server. But I want to maintain a single Network Security Group and have all my VMs,SQL Servers and AppServices in the VNET. Just…
Sency
  • 109
  • 4
1
2
3 4 5 6 7