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 Private Endpoint - can creating one cause downtime?

Suppose I have an Azure SQL Database Elastic Pool and I am accessing it from an Azure Web App via Firewall rules and everything is working fine. Now suppose I want to add a new Private Endpoint to the Azure SQL Database Elastic Pool. This would NOT…
A X
  • 469
  • 4
  • 10
  • 31
0
votes
1 answer

sp_send_dbmail succeding but sometimes failing

Also posted in Stack Overflow. Any feed back would be much appreciated. I have a need for a SQL job to send multiple emails, and I have come across this error that I am unable to find any solutions for. When I send emails this way is succeeds every…
Randy
  • 1
0
votes
1 answer

Error code ElasticPoolOverStorageUsage

I'm trying to create a new database in our Azure SQL elastic pool and getting the following error code. Error code: ElasticPoolOverStorageUsage. We have a total space of 32GB and based on the Elastic pool data storage graph, we have used only…
Andrew
  • 1
0
votes
1 answer

authenticate ASP.Net App on Azure WS2019 against Azure SQL via AAD - Access token could not be acquired No mapping between account names and securi

I try to reconfigure our ASP.Net app with .Net Framework 4.7.2 from SQL username/password Auth. to token based Azure Active Directory Authentication by using the system assigned managed identity of the VM running the Web Site. I started with…
Manfred
  • 1
0
votes
1 answer

Connection error related to sql azure database instance

I use the azure sql database service, I try to connect to the server where I have hosted the database and in a specific network I can not connect, however, from other wifi networks if I can connect. perform a telnet to port 1433 and I do not…
Federico Jimenez
  • 1
  • 1
  • 1
0
votes
1 answer

How to migrate Dedicated SQL Pool (DW) to Serveless Synapse?

I have Azure Datawarehouse which has fixed pricing tier DW100. Usage is small and assuming that Serverless can be cheaper. A) How do get information how much data processing have been occurring in last month to analyze costs? B) How to do migration…
Kenny_I
  • 101
0
votes
1 answer

"An existing connection was forcibly closed by the remote host" when trying to connect to azure sql server

I'm trying to deploy a SQL database to my azure SQL server. When I'm trying to connect to my target server, I get the error listed below. I'm using Microsoft SQL Server management studio 18 with Windows 10 1909. Any…
Gary Simmons
  • 1
  • 1
0
votes
0 answers

Enter Azure SQL Connection String in App Settings w/ PowerShell

I've deployed an Azure Web App and Azure SQL Database using PowerShell. At the moment I have the following code with a dummy value that sets a sql connection string for my web app: $connectionStrings = @{ "sqlConnection"= @{ …
jrd1989
  • 698
  • 15
  • 48
0
votes
1 answer

Azure SQL database still incurring vcore charges despite move to DTU?

So, in my MSDN subscription, myself and a developer set up an Azure SQL 480mb database to test performance, initially on the vcore model. Charges very quickly accrued and despite practically nothing being done with the database beyond the initial…
lansalot
  • 11
  • 2
0
votes
1 answer

Azure SQL. Scale out database to improve performance (read only)

We have a database that is used quite heavily (almost 100% of requests are selects), and now database becomes a bottleneck. We were looking for a solution that would let us scale this database out (horizonally) and load balance request across…
Stanislav
  • 1
0
votes
1 answer

Unable to connect to Azure SQL server through Point-to-Site VPN

Is there any possibility to connect to an Azure SQL server through Azure's P2S VPN client? More specifically, I want to force clients connected through Azure's S2P VPN client to use the VPN to connect to the DB server. One of the reasons is that the…
Aileron79
  • 259
  • 1
  • 7
0
votes
2 answers

Is an Azure Vnet really private?

I'm in the process of splitting the functions of a single VM web server on Azure across two VMs on the same Vnet. I want to check, can I assume that traffic between them is absolutely isolated and private? For example, one will host an SMTP server,…
stephen
  • 143
  • 3
0
votes
1 answer

Azure Database for MySQL servers: Location: service not available in this location for your subscription

I am trying to create an Azure DB MySQL server and under location I keep getting this error. " service not available in this location for your subscription." Could you guide me what needs to be selected here?
Sudeepti
  • 1
0
votes
1 answer

Azure SQL metric

I am not able to find few SQL metrics in Azure. Can anyone help in how to set metrics for below topics. 1)Under utilized capacity 2)Number of databases outside of pool 3)Scale up 4)Connection timeout Thanks in advance.
Gayathri K
  • 139
  • 5
0
votes
1 answer

WebApp cannot connect to Dbaas SQL server database

Since yesterday afternoon our Azure website is (again) not working because it cannot connect to its Azure SQL Server database. We haven't changed anything. The database is accessible through Management Studio and when running my website (or webjobs)…
Paul Meems
  • 101
  • 2
1 2 3 4 5
6
7