Questions tagged [azure-sql-server]
548 questions
0
votes
1 answer
Change "Allow access to Azure services" settings of Azure SQL Server using powershell
I want to modify (enable/disable) "Allow access to Azure services" settings of Azure SQL Server using powershell, based on a value from my JSON configuration
I do have referred couple of StackOverflow, all the answers are to create a firewall rule…
Manjunath Rao
- 1,397
- 4
- 26
- 42
0
votes
2 answers
Can i populate different SQL tables at once inside azure data factory when the source data set is Blob storage?
I want to copy data from azure blob storage to azure sql database. The destination database is divided among different tables.
So is there any way in which i directly send the blob data to different sql tables using a single pipeline in one copy…
Gagan Madaan
- 59
- 1
- 7
0
votes
1 answer
Limit access to Azure SQL Server to specific azure web apps
Is it possible to allow access to azure sql server, only to specific azure web app.
If possible , then do we have to configure start and end IP address of web app in azure sql server in "Firewall and Virtual Network". Also how to find start and end…
kartik iyer
- 243
- 3
- 11
0
votes
2 answers
How to delete rows in merge statement for specific date where target doesnt match source
I have a merge statement that runs every day as new data is dumped into my table every day, here is a sample of my code:
MERGE SQL_Backup as Target
USING Temp as Source
ON target.code = source.code
WHEN MATCHED THEN update SET
target.saledate =…
Corey Williams
- 17
- 1
- 5
0
votes
1 answer
How to find duplicates from Unique code column and delete the rows they're attached too, while still keeping the original row?
I have a table in my azure sql server named dbo.SQL_Transactional, and there are columns with headers as code, saledate, branchcode
code is my primary key, so if there is ever 2 or more rows with the same code, they are duplicates and need to be…
Corey Williams
- 17
- 1
- 5
0
votes
1 answer
Querying SQL Database returned an error: Login failed for user 'Free Trial
so currently I am doing a connection from Azure IoT Hub - Data Stream Analytic - SQL Database. and when I wanted to test the output connection that I have declared in Stream Analytics Job, suddenly error popped-up "Querying SQL Database returned an…
andrew sunartio
- 11
- 1
0
votes
1 answer
How to exclude duplicates when counting?
Say I have data like below:
id, dateVisited
1 3/4/2019 --Monday
1 3/4/2019 --Monday
1 3/5/2019 --Tuesday
2 3/4/3019 --Monday
2 3/5/2019 --Tuesday
2 3/7/2019 --Thursday
3 3/7/2019 --Thursday
4 3/5/2019 --Tuesday
5 3/8/2019 …
Abe Miessler
- 82,532
- 99
- 305
- 486
0
votes
1 answer
connect to azure sql server through datacenter ip address
I trying connect to azure sql server (xxxx.database.windows.net) through datacenter ip addres, i changed connect policy by proxy, but now i don't know how connect to instance the sql…
0
votes
1 answer
Independent azure Web job is not able to connect to SQL Server hosted in an Azure VM
Independent Azure Web job is not able to connect to SQL Server hosted in an Azure VM.
But we are able to connect to the same SQL SERVER from our local computers.
Error details :
The underlying provider failed on Open.
The job failed with exception…
Sab
- 1
0
votes
3 answers
How to import Azure Storage Blob JSON into Azure SQL Server
{
"Events":
[
{
"dataOne":7.5555555555555555,
"dataTwo":7.5555555555555555,
"dataFive":1025,
"dataSix":0,
"dataSeven":1025,
…
Chen
- 171
- 3
- 14
0
votes
2 answers
Bulk Insert or BCP in Azure SQL Server
I am trying to load data into Azure SQL server using BULK Insert and BCP. I am able to load data into my table without any issues, but load performance is the issue in my case. BCP is faster in most cases then BULK Insert.
BCP
Loading data from…
Jo.........
- 190
- 1
- 3
- 13
0
votes
2 answers
SELECT [all columns] takes 1:02 for table with 163,020 rows
This is an Azure SQL database. It's a small table, really. I'm not doing a SELECT * FROM. I'm naming all of the columns in the table.
The table has PK with a clustered index. It also has a non-clustered index with two columns in it.
Originally, the…
Casey Crookston
- 13,016
- 24
- 107
- 193
0
votes
4 answers
Clone database content into an existing database
I have two AzureSQL databases, let's call them "A" and "B". During our deployment process I want to copy schema + data from A to B. How to do that with as little as possible code? Is there a built-in task or PowerShell command to do that?
I've found…
D.R.
- 20,268
- 21
- 102
- 205
0
votes
0 answers
Create server login and database user in Azure SQL in C# in a transaction
I am trying to create a login and database user all in the same transaction but I am getting a time out.
First I am opening transaction via TransactionScope and inside I am opening two connections:
First connection is to the master database where I…
Robert
- 2,407
- 1
- 24
- 35
0
votes
1 answer
Azure SQL: What is the cost of running a specific SQL query like create database as copy
What are the costs of running the following operation in Azure?
drop database MyDB;
create database MyDB as copy of MyDB_Clean;
The scope of the above operation is to restore an existing database to its clean version to improve web site…
alex
- 1,300
- 1
- 29
- 64