Azure SQL Database
An Azure relational database service.
5,144 questions
1 answer
Unable to find package 'Microsoft.Azure.SqlDatabase.ElasticScale.Service.SplitMerge'
It is related to "Deploy a split-merge service to move data between sharded databases" I followed the steps in the "Download the Split-Merge packages" (very beginning) and tried to execute the command nuget install…
asked 2024-05-02T16:29:54.73+00:00
Ho Ming Tam
45
Reputation points
commented 2024-05-02T22:40:25.5233333+00:00
Oury Ba-MSFT
16,391
Reputation points Microsoft Employee
1 answer
Getting error "Could not create the marketplace item" for any resource I am trying to create
Getting error "Could not create the marketplace item" while creating any resource. It was working fine an hour ago and suddenly not able to create any resource. Below is my subscription details.
asked 2024-04-19T14:00:11.5233333+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(246.4, 94%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Abhisekh Paul
0
Reputation points
edited an answer 2024-05-02T22:31:17.62+00:00
GeethaThatipatri-MSFT
27,642
Reputation points Microsoft Employee
1 answer
Azure Function Python V2 with bindings to Azure SQL Database
I'm using Azure Functions V2 (Python 3.11). Here you can read that V2 replaces the function.json file with function decorators:…
asked 2024-04-29T12:55:35.0966667+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(96, 57.99999999999999%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELD%3C/text%3E%3C/svg%3E)
Louis Deconinck
0
Reputation points
answered 2024-05-02T21:20:23.2833333+00:00
Amira Bedhiafi
15,596
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure SQL Database Disaster recovery
Hi Team, can you please tell me how to configure Disaster recovery to azure sql database, and what is the difference between failover group and standby replica, both are different? if different then which solution should I go? Regards
asked 2024-04-30T07:07:30.22+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(67.2, 55.00000000000001%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Ankush Gurjar
115
Reputation points
commented 2024-05-02T20:44:19.3133333+00:00
GeethaThatipatri-MSFT
27,642
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Azure SQL Database connctivity
Hi Team, I have deployed azure SQL database service and I want to connect this database within the private network or office network, which configuration need to do from azure side. which IP need to whitelist from our office network? Thanks in advance!
asked 2024-04-30T05:18:55.9333333+00:00
Ankush Gurjar
115
Reputation points
commented 2024-05-02T19:54:58.48+00:00
Oury Ba-MSFT
16,391
Reputation points Microsoft Employee
3 answers
One of the answers was accepted by the question author.
sqlcmd fails to connect to azure sql server because of mfa, but active directory says mfa is disabled
I have been following this guide: https://learn.microsoft.com/en-us/azure/azure-functions/functions-identity-access-azure-sql-with-managed-identity and have reached the step "Grant SQL database access to the managed identity". I have…
asked 2024-04-27T14:28:52.5466667+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(115.19999999999999, 10%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Sondre Dahl
20
Reputation points
accepted 2024-05-02T17:57:17.4033333+00:00
Sondre Dahl
20
Reputation points
1 answer
Azure SQL Free Database Offer Charging for Storage
Hi There I have a quick question regarding the Azure SQL Free Database Offer. It seems that I got charged for database storage despite not consuming the 32gb of free storage. Is there any reason why it's charging me for storage? See image for reference.
asked 2024-05-02T01:08:43.9766667+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(121.6, 51%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDN%3C/text%3E%3C/svg%3E)
Daniel Nguyen
0
Reputation points
commented 2024-05-02T16:24:48.31+00:00
Oury Ba-MSFT
16,391
Reputation points Microsoft Employee
1 answer
Issue with Sign-In to Student Azure Microsoft Account
Dear Community, I hope this email finds you well. I am writing to inform you that I have created my Student Azure Microsoft account recently. I have provided all the necessary educational information, and I am eagerly waiting for verification. However,…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,144 questions
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
944 questions
asked 2024-04-29T16:07:48.1333333+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(70.4, 31%, 16%)' 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)
Ahmad Ali
0
Reputation points
commented 2024-05-02T15:04:01+00:00
GeethaThatipatri-MSFT
27,642
Reputation points Microsoft Employee
1 answer
how to restore differential azure Sql database automatically
Hello, Please suggest best approach to restore differential azure sql database. Restore/data refresh required 1-2 times daily. if we can do something using powershell/python and automation used for auto refresh. I am familiar with azure data factory for…
asked 2024-05-01T07:44:45.57+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, 9%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Ashutosh Prashar
0
Reputation points
answered 2024-05-02T12:28:20.21+00:00
Ashutosh Prashar
0
Reputation points
1 answer
Alternative for xp_loginconfig in MI conection
Hi Team, We are using "xp_loginconfig" Extended SP in our project for SQL server. We are providing support for SQL Azure Managed Instance connection in our project. I didn't found procedure similar to "xp_loginconfig" or…
asked 2024-05-02T11:21:25.06+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(182.40000000000003, 72%, 27%)' 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)
Sayali Khot (skhot)
0
Reputation points
answered 2024-05-02T11:42:16.85+00:00
Olaf Helper
40,896
Reputation points
0 answers
Remove BackSlash in result of Lookup Activity.
Hi All, I am having an order table, I have written a simple query to convert it to my required schema and it works perfect in my SSMS. Query: select(select JSON_OBJECT( 'OrderNumber': OrderNumber ) as 'values' from order for Json Path )as…
asked 2024-05-01T16:36:06.22+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, 79%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Muthu Kugan Muthusivakumar (INFOSYS LIMITED)
0
Reputation points Microsoft Vendor
edited a comment 2024-05-02T09:48:50.79+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(288, 61%, 37%)' 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)
phemanth
5,840
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
extend Azure SQL always on availability group to on prem
I have an Azure SQL always on availability group with 2 servers, i need to add another on-prem node to the AG. Azure SQL AG deployed in a single subnet with DNN listener, and i already have S2S connectivity between Azure and on-prem. do i have to migrate…
asked 2024-04-15T13:47:40.6133333+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(22.400000000000002, 46%, 12%)' 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)
Abdalrahman Allahham
40
Reputation points
accepted 2024-05-02T07:31:40.3033333+00:00
Abdalrahman Allahham
40
Reputation points
3 answers
CosmosDB Analytical store delete changes in sql sink
Hi I am trying to capture delete changes from Azure cosmosdb analytical store using change data capture in Azure datafactory, Source is Cosmosdb, sink is Azure sql database. In between I am flattening my file using dataflow. My insert, update is…
asked 2024-04-30T13:52:46.2133333+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(112.00000000000001, 15%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKB%3C/text%3E%3C/svg%3E)
Kuldeep Bhati
0
Reputation points
answered 2024-05-02T07:24:09.3266667+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(12.8, 48%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Harishga
3,430
Reputation points Microsoft Vendor
1 answer
Failed SQL logins to MI coming from same subnet as SQLManagedInstance
We have started monitoring failed login attempts to our managed instance and see some failed connections that we can't seem to figure out what the attempt may be. Error message: A disconnect event was raised when server is waiting for Federated…
asked 2024-04-30T15:36:48.85+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(246.4, 64%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Ryan Pighin
61
Reputation points
edited the question 2024-05-02T01:23:56.8333333+00:00
CosmogHong-MSFT
23,321
Reputation points Microsoft Vendor
1 answer
How to copy the data from Amazon S3 to Azure SQL database incrementally.
Hello team, I wanted to wanted to copy data from Amazon S3(JSON format) to Azure SQL database. I wanted to learn the mechanism for incrementally updating the data from Amazon S3 to Azure SQL. Also, the environment has only SHIR deployed, so data flows…
asked 2024-05-01T20:06:01.4533333+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(131.20000000000002, 0%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Shweta Chavan
40
Reputation points
answered 2024-05-01T21:33:16.9633333+00:00
Oury Ba-MSFT
16,391
Reputation points Microsoft Employee
0 answers
Retirement of Azure SQL Database APIs 2014-04-01
The Azure SQL Database API version 2014-04-01 is retiring, I would like to understand the following things: How can we check the resources effected using the resource graph explorer? How to make the changes using code? Any prerequisite or…
asked 2024-05-01T08:54:07.26+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(179.20000000000002, 44%, 27%)' 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)
Azra Akil
40
Reputation points
edited a comment 2024-05-01T19:46:25.54+00:00
GeethaThatipatri-MSFT
27,642
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Parsing row counts from json output from an ADF script to pass to Stored Procedure
I have a ADF script that simply performs the following from a ForEach Loop. @Anonymous (concat(concat('select count(*) as num_rows from ', item().table_owner_schema), '.'), item().table_name) This works fine and returns the row count in the…
asked 2022-09-14T13:46:46.027+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(153.6, 30%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHR%3C/text%3E%3C/svg%3E)
Haliburton, Russell
21
Reputation points
accepted 2024-05-01T18:28:53.0233333+00:00
Haliburton, Russell
21
Reputation points
3 answers
One of the answers was accepted by the question author.
Elastic pool in Azure SQL & SQL server Managed instance
I have 2 doubts ) What is the right explanation Elastic pool in Azure SQL ? ) What is SQL server Managed instance that is often heard in Azure DB services & when one should use it. I have been trying to understand its significance but did…
asked 2022-05-09T14:27:22.923+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(99.2, 31%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mohammed Arshad Alikhan
86
Reputation points
commented 2024-05-01T16:33:11.8+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, 57.00000000000001%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vinay KM
0
Reputation points
1 answer
Create a data factory and pipeline using .NET SDK
Hello, this is my first post here and I hope to find a solution. I am working on a web portal (.NET) hosted in Azure Web Apps and need to create a Service Link for Azure SQL Database in Azure Data Factory when I perform specific actions. The problem is…
asked 2024-04-25T03:13:10.4833333+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(16, 72%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EET%3C/text%3E%3C/svg%3E)
Eddy Tegera
0
Reputation points
commented 2024-05-01T14:03:33.61+00:00
phemanth
5,840
Reputation points Microsoft Vendor
1 answer
How to enable SQL PrivateLink connection when SQL server is behind Active/Passive load balanced firewall pair
We have configured an Edge VNET that contains and ELB with our public IP that goes to a pair of Fortinet firewalls. Those firewalls route traffic to our spoke VNET that contains our SQL server that has a PrivateLink interface. If I leave external access…
asked 2024-04-26T17:06:55.22+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(224.00000000000003, 76%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
TGS Service Account
0
Reputation points
edited the question 2024-05-01T13:43:50.8466667+00:00
GitaraniSharma-MSFT
47,421
Reputation points Microsoft Employee