Azure SQL Database
An Azure relational database service.
5,412 questions
0 answers
CROSS DATABASE QUERY IN AZURE SQL DB
I have two DBs named CARE1 and CARE2 in the same server on AZURE. Both DBs are currently working perfectly on local SQL servers and I have windows desktop application. Now, I'm trying to shift my DB into the cloud. Both my application code and Stored…
asked 2020-09-17T07:32:14.86+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 62%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
LISCARE
1
Reputation point
commented 2020-09-17T08:09:23.167+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Anurag Sharma
17,586
Reputation points
1 answer
One of the answers was accepted by the question author.
Data Factory Pipeline to Azure SQL Server - fails on firewall IP
Hi Team, I'm not sure what I've done wrong here. I've got an Azure Data Factory pipeline that copies data from an on-prem SQL Server (using the Self-Hosted Integration Runtime) up into a database running on an Azure SQL Database. I can grab the…
asked 2020-09-15T08:12:13.74+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 20%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Matt Russell
36
Reputation points
accepted 2020-09-17T07:27:38.333+00:00
Matt Russell
36
Reputation points
1 answer
new-azsqldatabaseexport error: "Unable to authenticate request" -AuthenticationType AdPassword
Hello together, i have written a powershell script to export azure SQL databases into a blob. I use the parameter new-azsqldatabaseexport -AuthenticationType AdPassword ... But I get an error: "Unable to authenticate request " The…
asked 2020-09-12T17:03:20.147+00:00
Guido Jeuken
71
Reputation points
commented 2020-09-17T05:28:09.293+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
Alternative to using Azure SQL Managed Instance for Complex calculations
I have inherited an Architecture which carries out complex calculation in Azure SQL Managed Instance via Databricks. The Databricks is connected via Apache Spark connector. The Databricks does the calculations in SQL and the end results are in Tables…
asked 2020-09-02T16:31:09.39+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 90%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Kman
41
Reputation points
commented 2020-09-16T19:45:52.69+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
MartinJaffer-MSFT
26,061
Reputation points
1 answer
Azure SQL AlwaysON performance in availability zones vs Availability set
Hi, Our Client would want us to setup SQL AlwaysON in Availability zones for greater availability(99.99%), so the setup would be like two SQL servers in synch in two availability zones. Region is West Europe. I have previously worked on alwayson…
asked 2020-09-13T16:24:50.107+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 93%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPG%3C/text%3E%3C/svg%3E)
Pardha Ganta
1
Reputation point
commented 2020-09-16T18:49:27.013+00:00
prmanhas-MSFT
17,901
Reputation points Microsoft Employee
0 answers
Slow loading for application
My web application seem to be loading very slowly recently. I have increased my DTUs, but seems no changes. Its state server location is in south east asia. Anyone with similar issue?
asked 2020-09-08T09:51:58.213+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 33%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVL%3C/text%3E%3C/svg%3E)
vanilla Law
1
Reputation point
commented 2020-09-14T17:27:54.38+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 93%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
Not able to delete any resource
Please help me regarding this error. Not able to delete resource group.
asked 2020-09-10T09:57:36.12+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 89%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
demo case
1
Reputation point
commented 2020-09-14T07:51:40.453+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 9%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HarithaMaddi-MSFT
10,136
Reputation points
2 answers
No SQL connector for Azure Key Vault in SQL Managed Instance
Hi, The SQL connector for Azure Key Vault is not pre-installed and configured in Azure SQL Managed Instance. This prevents from using Column level Encryption using Key from AKV. Please note, that The 'Always Encrypted' feature does not meet my…
asked 2020-09-11T11:28:20.85+00:00
Surbhi Nijhara
36
Reputation points
answered 2020-09-14T07:41:23.35+00:00
Surbhi Nijhara
36
Reputation points
1 answer
Azure SQL Data Sync fails for bulk data
I'm using Azure Data Sync to synchronize two databases Everything was working fine until a few days ago when I inserted around 30 users in the Hub Database. Since then I'm getting the following error. Sync failed with the exception…
2 answers
Azure SQL Database Port 1433 Workaround - Data Factory Enable Staging option not working
Hello, I have developed data pipelines and database to store data while I was working from home. However, I am not able to access the database in the corporate network. After some research I found that port 1433 Outbound should be open for Azure SQL…
asked 2020-08-13T16:51:59.177+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 5%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Chandrasekaran, Raji
1
Reputation point
commented 2020-09-11T20:37:28.483+00:00
MartinJaffer-MSFT
26,061
Reputation points
1 answer
Parsing json to azure sql db - mapping
Hello I have a blob storage with json files comming from API and loaded there ones per day. The case is to parse the jsons and import to azure sql db on a daily basis. The jsons contains about 70 attributes with values. The structure is not always the…
asked 2020-09-04T08:07:24.977+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 26%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
braxx
436
Reputation points
commented 2020-09-11T09:44:16.747+00:00
HarithaMaddi-MSFT
10,136
Reputation points
1 answer
Webapp to extract Excel data
Hi there - I am trying to create a database from existing Excel model files, and then access the data through webportal or through PowerBI. Unfortunately the data is not currently structured as a table and these files are fairly complex. Could I…
asked 2020-09-07T22:48:03.497+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 24%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
Nicholas Ahn
1
Reputation point
commented 2020-09-11T09:41:23.79+00:00
HarithaMaddi-MSFT
10,136
Reputation points
1 answer
Setting Shards - ListSharding command not working
Hello, I have executed the below command as indicated in the documentation for list sharding but I am getting command not recognized error: $ShardMap = New-ListShardMap -KeyType $([int]) -ListShardMapName 'ListShardMap' -ShardMapManager…
asked 2020-09-10T19:06:30.577+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 39%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Raja1203
1
Reputation point
answered 2020-09-11T07:08:55.603+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 10%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KalyanChanumolu-MSFT
8,316
Reputation points
2 answers
Can't access txt file with json format from Data Lake Gen2 inside a Data Flow
I have stored a txt file with json format (coming from a MongoDB) in my Data Lake Storage Gen2 and inside my Data Flow I would like to access that file, convert it into a column structure, transform the data and shift it to my Azure SQL DB. Currently I…
asked 2020-08-19T11:37:03.847+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 73%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Joko123
1
Reputation point
commented 2020-09-10T20:03:06.417+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft
19,381
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
SQL and Storage Backup
Hi there, We would like to backup our Azure SQL DB and Storage account to a different Azure region to where they currently reside. The main reason for this is for disaster recovery. What would be the best approach to do this please? I have looked…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 95%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETW%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
How to communicate to Secondary database in case of Primary Failover in C# Rest Service Applciation
Hi We have Rest Service developed in C# Deployed in Azure Web App communicating to Azure Sql Database. We recently added the Geo-Replication feature for our Primary data base in Azure Sql Database we need to fail-over to Secondary database in case…
asked 2020-09-09T01:58:39.273+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 76%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Amar-Azure-Practice
661
Reputation points
accepted 2020-09-09T16:53:09.357+00:00
Amar-Azure-Practice
661
Reputation points
7 answers
How to Remove additional speces after add Replace function
Hi Team, Currently i have faced issue as a after add replace function to SQL column to remove comma, then output parsing as a addotional spaces on the SQL column data feilds, According to i have used below trim method but its not worked, Could you…
asked 2020-09-02T17:51:44.293+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 19%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Mahesh Madhusanka
216
Reputation points
answered 2020-09-09T04:07:50.263+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 76%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
EchoLiu-MSFT
14,581
Reputation points
1 answer
No IP gateway of North Europe to communication with existing Azure SQL Database gateways ?
We received one mail about :Allow communication with existing Azure SQL Database gateways, may I know if this is the right way to config it. open sql server In firewall and virtual network tab Add IP to the list, for example if sql server is in…
asked 2020-09-03T02:15:31.613+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 12%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBZ%3C/text%3E%3C/svg%3E)
Bin Zhao (PACTERA TECHNOLOGIES INC)
1
Reputation point
commented 2020-09-08T16:45:03.977+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
Is it possible to have guest user in Azure SQL?
Hi, I would like to create Azure SQL DB and user can access tables inside it without any credentials (Anonymous). I knew we can create REST API and use it as an Anonymous. Is it possible in Azure SQL? Thanks, Samir
asked 2020-09-01T10:14:17.32+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 27%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Samir KHIMANI
21
Reputation points
commented 2020-09-08T16:44:16.273+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Problem running the command
I am having a problem running the command from the link below: sqlcmd -S <server-name>.database.windows.net -d <db-name> -U <aad-user-name> -P "<aad-password>" -G -l 30 …
asked 2020-09-08T06:53:16.093+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 79%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
PingpongSet
36
Reputation points
accepted 2020-09-08T10:37:34.53+00:00
PingpongSet
36
Reputation points