Azure SQL Database
An Azure relational database service.
5,608 questions
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,891
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,226
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
![](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,081
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,321
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,471
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,226
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,226
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
1 answer
One of the answers was accepted by the question author.
Azure Web App Slowness
Total noob here. Ported over an asp.net webforms / sql server application for testing. I went with the most basic sql database and web app. With the above selected basic options, the performance is unacceptable compared to my current hosting service.…
asked 2020-09-02T15:28:17.55+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(201.6, 72%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGC%3C/text%3E%3C/svg%3E)
Geoff Campbell
21
Reputation points
accepted 2020-09-07T21:49:31.823+00:00
Geoff Campbell
21
Reputation points
1 answer
Need powershell command to list database backup status of SQL database running in Azure virtual machine
Hi, I need a powershell command/Script to list the last database backup status and date of SQL agent running on the Azure virtual machine.
asked 2020-08-31T12:04:51.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(83.2, 28.999999999999996%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKG%3C/text%3E%3C/svg%3E)
keerthy ganesh
6
Reputation points
commented 2020-09-07T09:14:13.983+00:00
KalyanChanumolu-MSFT
8,321
Reputation points
1 answer
database migration assistance
In the Source sql server name, only default port 1433 is allow ?? where to specify the port and instance name ?
asked 2020-09-04T19:02:08.697+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(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
sakuraime
2,326
Reputation points
answered 2020-09-07T09:02:00.617+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,606
Reputation points
2 answers
One of the answers was accepted by the question author.
SSIS CSV Loading issue
I am looking for a C# solution to use a script task in SSIS so that I can load multiple csv files to SQL Tables Now If I use a data flow task, then I have to create 1 DFT per file as each file has a different metadata ( unless there is some other…
![](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(96, 72%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJK%3C/text%3E%3C/svg%3E)
