Stack Overflow
Stack Overflow

Questions tagged [azure-sql-server]

548 questions
0
votes
1 answer

Run a procedure on all Azure SQL Database in a SQL Server using Automation Runbook without using a connection string

I am executing a maintenance related procedure on all Azure SQL database in Azure SQL server within a specific resource group. I am using powershell and getting all the DBs at once using Get-AzSqlDatabase cmdlet, then I iterate over the DBs and…
Anurag Arya
  • 32
  • 1
  • 5
0
votes
2 answers

Is there any way to copy incremental data from SQL Server to Blob Storage Through Azure Data Factory?

I am trying to copy incremental data from Azure SQL to Blob Storage but it overwrite all the existing data in every file. Can you provide me any work around for this problem
Somya Gupta
  • 17
  • 1
  • 8
0
votes
1 answer

How to run local host .net app connecting with Azure SQL?

I use the connection string that Azure provides but it doesnt work. Perhaps connection string of Azure app service and local host is different? Or is there anything I should fix besides my connection string for the app able to run in local host?
Nayli Fatini
  • 11
  • 1
0
votes
1 answer

simple million row update times out

Trying this: update _PECO_Detail set RunId = 37 I get: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout I've seen posts about this that say that this is a…
Kam Mistry
  • 105
  • 8
0
votes
1 answer

How to get Azure SQL Database user statistics?

I would like to know the users and their actions on my Azure SQL Database. Is there any way to get this information?
Arul
  • 1
0
votes
0 answers

Bacpac restore, timestamp/rowversion values change

I exported an Azure SQL DB in the bacpac format, and imported it to a new server. All data is restored as it should be. However my tables have a timestamp (rowversion) column. This means importing to another server changes the values in these…
user2415476
  • 211
  • 1
  • 15
0
votes
1 answer

How does authorization and authentication work in Azure SQL server?

I see a couple of different options for access control in Azure SQL server. There is a panel on Azure called access control (IAM) where roles like contributor/reader can be assigned to users. The second place is the SQL server security artifacts…
Krishnabm
  • 161
  • 8
0
votes
2 answers

How to make a Azure SQL Exec or select another table/procedure in another Azure SQL

I've two Azure SQL Servers, each one contains one database, I need to exec Selects or Stored procedures between them. For example: Server1.database.windows.net DB: local1 Server2.database.windows.net DB: remote1 in Server1: Select * from…
André Valvassori
  • 30
  • 4
0
votes
1 answer

ARM - How can I get the access key from a storage account to use in sql server audit settings later in the template

unable to fetch single access key value from array, i followed this reference https://stackoverflow.com/a/50407157/11191182 "storageAccountAccessKey": "[listKeys(resourceId('Microsoft.Storage/storageAccounts', parameters('StorageAccountName')),…
prachi sawant
  • 1
  • 1
0
votes
1 answer

Slow query when having too many conditions

I have this simple query: SELECT distinct top 100 A.[Number] FROM [Section] AS A LEFT JOIN [Customers] AS c ON c.ARef = A.Number LEFT JOIN [Guides] AS G ON G.CustomerId = c.CustomerId LEFT JOIN [Telephones] AS T ON T.CustomerId =…
Kamran
  • 1,258
  • 1
  • 16
  • 28
0
votes
1 answer

Data Load Error Using ADF V2 to Sql Server on Azure VM

I'm facing below error while trying to data load from On-Prem Db2 system to Sql Server on Azure Vm using ADF V2 A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection…
user1941025
  • 541
  • 6
  • 21
0
votes
1 answer

How to Connect to Azure SQL Server from WPF application with Azure AD token autentication : avoid Firewall

Now I develop a WPF application that access to Azure SQL Server and work in Windows10 Tablet for my client. I registered my client IP address of my PC for development,so the application can access to the sql server in development. But it does not…
MagicalJourney
  • 41
  • 2
0
votes
1 answer

Azure SQL concurrent inserts cause duplicates in incremented column

We have an integration of PowerApps with Azure SQL. The inputs provided by user is stored in Azure SQL with incremental row ID. The request ID increment operation is handled in the stored procedure. But if multiple users are adding the content at…
karthik
  • 81
  • 1
  • 1
  • 8
0
votes
1 answer

Finding Pricing tier of Azure SQL Server without access to the subscription but having admin login access

I have admin login access to an Azure SQL Server instance but it's not in my subscription. So I can't go to Azure page for this resource to find Pricing tier information. But I do have admin access to the SQL Server and can login to it using SSMS.…
Dhiraj
  • 3,396
  • 4
  • 41
  • 80
0
votes
1 answer

Is there any way to querying two tables from two different database without using external table in Azure SQL?

I have to querying two tables from two different databases in Azure SQL. Is there any option available in azure?
Prabu
  • 63
  • 2
  • 7
1 2 3
…
36 37