Stack Overflow
Stack Overflow

Questions tagged [azure-sql-server]

548 questions
0
votes
3 answers

Is it required to tell my SQL Azure firewall to let incoming requests from my Azure App Service?

I have an ASP.NET Web API deployed on an App Service Web App, and a SQL Azure instance separately. I created the two using the Web App + SQL template in Azure. I have allowed the SQL Azure access to my own localhost's IP so I can open it in SQL…
Water Cooler v2
  • 32,724
  • 54
  • 166
  • 336
0
votes
1 answer

How to prevent database bottlenecks on server less computing?

The benefits of serverless computing are obvious yet when it needs connections to databases (for example sql server) usually when too many requests exist it may create bottlenecks and connection pool exhaustion. What is the best solution for…
Carlos Alves Jorge
  • 1,919
  • 1
  • 13
  • 29
0
votes
1 answer

In SQL, bulk insert from blob is giving error

I have CSV file in Azure Blob storage and I want to insert file content to my MS SQL table. My CSV file and table which I'm using in my code are having same number of columns. I have used Bulk insert command as specified here: Importing data from a…
Saibaba B
  • 1
  • 1
0
votes
2 answers

Azure SQL DTU Jumps up and gets "stuck"

I have been having issues with Azure SQL often maxing out DTU at random times with no change in query load. I generally see a big jump in dataIO followed shortly after by a jump in CPU. DataIO will then subside but CPU usage appears to get stuck…
Bob D
  • 1
  • 2
0
votes
1 answer

Connect to Azure SQL from on premise network

We are developing a web API with Azure SQL for data persisting that is completely hosted on Azure. We need to push some data from on premise to Azure SQL. Our info-security team is not ready to open the port 1433 to provide outbound connectivity.…
Dotnet Learner
  • 41
  • 2
  • 8
0
votes
2 answers

SQL Data Sync Feature - Trouble refreshing Schema between 2 SQL Azure DB's (Hub & Member DB)

Agenda: We want to achieve a scenario where we should be able to sync all of the data pushed in our production SQL azure DB to Test SQL Azure DB [ Hosted under the same SQL server ] via "Sync To other Database" feature in SQL Azure. Error: "Database…
Girish Kalamati
  • 11
  • 3
0
votes
1 answer

Azure - Copy an existing SQL database to another server using Transact-SQL and SSMS

I have two subscriptions on Azure, for the ease of argument, lets call them subscription1 and subscription2. I have a SQL database of size 30 GB on subscription 1, and I want to move it to subscription2. One way is to take a backup of the database…
Asadullah Awan
  • 25
  • 1
  • 5
0
votes
1 answer

SQL Server to Azure Cosmos DB Migration

Please let me know whether we can migrate stored procedure from Microsoft SQL server to Microsoft Azure Cosmos DB ? Either with DocumentDB migration tool or any other tool
Sumeth MK
  • 1
0
votes
1 answer

Azure login to user db with pyodbc from a Azure webjob

I am trying to login to Azure sql server with pyodbc which logs me in a master db rather than the userdb like 'xyzdb' that i provide in the connection string. The solution to this seems changing to a DSN less based logins that needs configuring the…
user10725830
  • 1
  • 1
0
votes
0 answers

Not able to run ALTER DATABASE [DatabaseNameHere] SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE On Azure

I have created SQL Database on Azure SQL server service, and trying to enabled Service Broker, but getting below Error. Error :The operation cannot be performed on database "DatabaseNameHere" because it is involved in a database mirroring session or…
Nilesh Mohite
  • 55
  • 9
0
votes
1 answer

Upgrading Azure SQL Server pricing tier while being under failover group

I have 2 Azure SQL databases both are backing each other up in a failover group. However, each of them is in a different pricing tier (one in a basic and the other one in a standard). I want them both in the same pricing tier (standard) but when…
Santiago
  • 21
  • 2
0
votes
0 answers

Problems with connecting Database

I created a SQL Server on Azure (https://saigkillsbacktrace.database.windows.net) with a Database. Now i'm trying to connect with it via SQL Studio. Studio tells me, that the host is unknown. But what to do?
Sascha Manns
  • 2,331
  • 2
  • 14
  • 21
0
votes
1 answer

Kubernetes A network-related or instance-specific error occurred while establishing a connection to SQL Server

I have docker that running on kubernetes, the site is able to browse from the browser. When performing request API, that requires a connection to the database. The database is hosted on SQL Azure NOT on another docker. I got this error A…
Herman
  • 2,832
  • 6
  • 25
  • 37
0
votes
1 answer

Azure SQL Legacy Cardinality Estimation Not Working Like SQL Server 2016

We have two identical databases (exact same data, structure etc.) one in Azure Sql (Premium 500 DTU) and the other on a VM on Azure running SQL Server 2016 SP1 (8 vcore, 64 GB RAM). We have a query that when run with "Legacy Cardinality Estimation"…
Ken Brannigan
  • 607
  • 8
  • 16
0
votes
1 answer

Grant Azure Function access to ARM REST API

Earlier this year, I created an Azure Function which used the Azure REST API to copy a database programmatically. This worked, but has now stopped working for some reason. To authenticate, the code in the Azure Function gets an auth token ... var…
Dan
  • 5,692
  • 3
  • 35
  • 66
1 2 3
…
36 37