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
0
votes
1 answer

How to connect multiple sql instances installed in same azure vm via internet

I have an Azure VM which has installed two sql server instances (Sql server 2012 and sql server 2016). First I installed the SQL server 2012 and could able to connect via internet using Sql Server Management Studio. I referred this article. Then I…
sahan peiris
  • 1
0
votes
1 answer

Azure sql server read only replica

we have a database which is a SQL server PaaS offering, I would like to create a read only replica database which has a dedicated server behind it. The reason behind this is that I do not want to use the read scale out option, as this option…
learner
  • 101
  • 1
0
votes
1 answer

Will there be data loss in Azure Cosmos DB with multi-region write if one of the regions fails (outages)?

I use Azure Cosmos DB with multi-region write in two regions and I need to know what will happen if one of this regions fails (outages). Will it be data loss and if, yes, how much time will it take to recovery? Maybe someone in his project met faced…
Anastasiia D
  • 1
0
votes
1 answer

Azure App Service to SQL Server DB connection fails with generic "error occurred during the login process"

I have a project consisting of several frontend and backend apps, and several databases; I am in the process of building the deployment pipeline. It should use Azure Static App Services for the frontends, Azure App Services for the backends (.NET 6)…
xalib
  • 1
  • 1
0
votes
0 answers

Need advice on SQL Server architecture/approach for higher-ed classroom usage with large number of DB creators

I'm a sysadmin at a university. One of our College of Business programs is changing their curriculum. They are going to be teaching a database course this coming fall that potentially has 120 students. The students need to be able to create their…
Justin Cervero
  • 236
  • 1
  • 6
0
votes
0 answers

Changing database Elastic Pool disturb the indexes of the database

I have more the 5000 database and 15 Elastic Pools in Microsoft Azure and when I feel the database performance issue we change the Elastic Pool of that database. But today I note that our database indexes disturbed while changing the Elastic…
Muhammad Numan
  • 1
0
votes
1 answer

How to route Azure MSSQL queries over vnet

I've got a vnet in Azure with a private endpoint connection configured for A MSSQL server. There's a private DNS zone configured with an A record for the private endpoint connection. App Services connected to the vnet can connect to the private IP…
Utegrad
  • 125
  • 2
  • 8
0
votes
0 answers

SQL Sync Scenarios (on-prem to Azure)

I would like your help making a decision on the following: We have a local SQL server and we would like to sync to either Azure SQL on VM or Managed Instance using Sync Framework 2.1. From what I understand, the framework would work only on Azure…
Bala M.
  • 1
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
  • 382
  • 2
  • 8
  • 23
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

Azure Serverless SQL will not pause due to Azure service queries keeping it online

There is a database we use for archiving old data which I want to be 'serverless' so that it only fires up when we make a query. I changed the size from standard to serverless without issues. I have not connected to this DB since making the…
Damo
  • 405
  • 3
  • 7
  • 17
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
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
1 2 3 4
5
6 7