Stack Overflow
Stack Overflow

Questions tagged [azure-sql-server]

548 questions
0
votes
1 answer

Azure select query gets slower and slower

I have a table in azure that has +20M rows. When I try to fetch e.g. 300k rows: select * from table where clientId=2 the first 30k get loaded fast, in a few seconds, but the rest take forever. Why does it slow down that much? The DTU when reaches…
user122222
  • 2,179
  • 4
  • 35
  • 78
0
votes
1 answer

Dacpac deployment on Azure Sql server: "Cannot perform delete operation because following scope(s) are locked"

I am trying to deploy a .dacpac on my newly created azure sql database. Both the server and the database have a lock on top of them: I am deploying my dacpac through Azure Devops Pipeline by using SqlAzureDacpacDeployment task. Everything seems in…
Tarta
  • 1,729
  • 1
  • 29
  • 63
0
votes
1 answer

Copying specific data from one db to another in Azure Sql Db

How can we select some data from a table in DB1 and insert into table in DB2 in Azure sql Server without using Azure Data Factory ? I have searched the internet and I found about using SSMS to generate query for data and run that query in DB2 but…
Shadow
  • 21
  • 5
0
votes
1 answer

Cisco Anyconnect VPN IP Address not being used to connect to Azure SQL Server

I am able to connect to Azure SQL Servers by defining my IP address in the firewall rules for a server. Although due to working from home and having a dynamic IP address, this can become tedious and annoying for other databases that I have to…
NiallMitch14
  • 1,198
  • 1
  • 12
  • 28
0
votes
1 answer

How powerapps quit azure sql connection?

We are using Azure SQL database in Powerapps. We suffered from extremely slow performance in one of our apps in previous days. Azure supports found out it may be the connection limitation of the plan. It improved after we scaled up the plan. We hope…
ahmug
  • 1
  • 4
0
votes
1 answer

Azure SQL Server Login failed after Free-trial

I am currently using Azure for studies. My 30-day free trial is now over. However, I can see that after this free trial, there would be a period of another 11 months or so of free products, list in which SQL Server is included. I have a SQL Server…
RNA
  • 63
  • 2
  • 8
0
votes
1 answer

SQL server to Azure process workflow migration

We are supporting a legacy system for our organisation. In the current scenario, we receive a SQL Server backup (.bak files) from the application vendor on an FTP location. For every weekend on Sunday it is a Full backup and for every other day its…
roman
  • 11
  • 1
0
votes
1 answer

Query takes way longer to run when selecting only one column

this is my first post here. I'm fairly familiar with SQL queries (though it's not my main focus) but I'm stumped on a sudden issue. I have a query that has been in use for probably at least 2 years with no issue. Today, it is suddenly taking way…
Nick Mains
  • 3
  • 2
0
votes
1 answer

Compare data between two Azure SQL DB's

I have a requirement where I have to compare data between two tables from two different Azure SQL DB's. Both the database have same schema so i just need to compare the data. What are all the options i have since i cant do a cross SQL querying in…
Sam
  • 3
  • 1
0
votes
1 answer

Multiple SQL instance on Azure

I'm preparing a migration plan to migrate on-premises SQL Server to Azure. On our on-prem there are two sql instance (DevSQL01\Dev and DevSQL01\Demo) running on single VM. Can we create a same scenario on azure, i.e. can we create two SQL instance…
Jagan Sekaran
  • 78
  • 2
  • 7
0
votes
1 answer

AZURE SQL MI Error: Stale/aborted version cleanup was aborted for database id '10' due to database shutdown

I am trying to restore SQL server .bak file to Azure SQL Managed Instance database through SSMS but getting an error Msg 22003, Level 16, State 1, Line 18 Stale/aborted version cleanup was aborted for database id '10' due to database shutdown. Msg…
Hemant Sudehely
  • 49
  • 1
  • 10
0
votes
1 answer

Azure SQL "An error occurred while executing GlobalQuery operation: Encountered an unsupported intrinsic expression AT TIME ZONE."

I have started encountering this error today in an Azure SQL environment. There have been no changes to the Azure SQL environment from our end. No changes to schema objects, resources, etc. I have two databases on the same azure sql server and this…
Antony
  • 3,781
  • 1
  • 25
  • 32
0
votes
1 answer

Why is sql script not valid when referenced by post deploy

I have a Script.PostDeployment.sql which references DataFactoryRights.sql ScriptPostDeployment.sql, build action PostDeploy: :r .\DataFactoryRights.sql DataFactoryRights.sql, build action None: CREATE USER [dataFactory] FROM EXTERNAL…
Sindresvends
  • 180
  • 1
  • 1
  • 10
0
votes
0 answers

Azure SQL Server User Provisioning

When provisioning a new Azure Active Directory user's access to an Azure SQL Data Warehouse or Database does the user need to be added to the master database in the Azure SQL Server? This documentation only talks about adding the Azure Active…
codechurn
  • 3,870
  • 4
  • 45
  • 65
0
votes
1 answer

Erorr exporting Azure sql database to blob storage with powershell

I'm trying to use Azure management API to export a SQL database to a bacpac file in a blob storage. The process seems fairly simple: obtain a token, and then: $sqlAzureBackupHeaders = @{ Authorization = "Bearer…
Aleks G
  • 56,435
  • 29
  • 168
  • 265
1 2 3
…
36 37