Azure SQL Database
An Azure relational database service.
5,954 questions
1 answer
Azure SQL Database - on master - long execution of a query program TdService
On Azure SQL Database in Azure there is a really long query running (many days). The details: database_name master program_name TdService It looks like a bug from an Azure SQL Service. On diagnostics while trying to send a support ticket: The…
asked 2025-01-13T14:30:08.76+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, 69%, 11%)' 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)
RaTheMigthy
0
Reputation points
commented 2025-01-30T15:41:11.5266667+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(195.2, 21%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Martin Smith
1
Reputation point
2 answers
How to import multiple json files present in a container of azure blob storage into Azure SQL Database using Openrowset
I have a scenario where i have to load json files present in a folder of a container in azure blob storage to azure sql database. I tried passing wildcards in data_file_path but seems it's not working. Can you please provide alternatives or an example.
asked 2023-07-10T09:59:26.0033333+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, 79%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBV%3C/text%3E%3C/svg%3E)
Bhanu Venkata Satya Shiva Sai Inturi
5
Reputation points
commented 2025-01-30T15:31:39.34+00:00
Martin Smith
1
Reputation point
3 answers
How can I get all the failure SQL queries logs o
I want to track all the failure SQL in the log metrics, how can i get the output
asked 2025-01-29T13:45:01.7433333+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(275.2, 0%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Robert Antwi
0
Reputation points
commented 2025-01-30T14:52:14.2466667+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(35.2, 49%, 13%)' 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)
Vijayalaxmi Kattimani
1,065
Reputation points Microsoft Vendor
3 answers
how do I find resources that may use Azure SQL Database resources that use version 2014-04-01 APIs
Get an email from Microsoft telling me that all version 2014-04-01 APIs will be retired on 31 October 2025. Further, the email says You’re receiving this email because you use Azure SQL Database APIs. How do I find in my Azure subscription, I am using…
asked 2025-01-29T13:38:41.9133333+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(128, 64%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGR%3C/text%3E%3C/svg%3E)
Guy Russell
0
Reputation points
commented 2025-01-30T14:50:15.8233333+00:00
Vijayalaxmi Kattimani
1,065
Reputation points Microsoft Vendor
1 answer
Request for Insights on Enabling CDC with ADR on Azure SQL Managed Instance
I am reaching out to check if anyone has prior experience or insights on enabling and managing these features together in Azure SQL Managed Instance. Specifically, we are interested in understanding: • Any challenges or considerations when enabling CDC…
asked 2025-01-10T06:30:36.1366667+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, 46%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Satya Varaprasad
1
Reputation point
commented 2025-01-30T12:44:26.0233333+00:00
Satya Varaprasad
1
Reputation point
1 answer
How to migrate from SQL Server 2016 to Azure SQL DB
I plan to migrate 1.2 TB Database from SQL 2016 (on Proem) to Azure SQL DB. What is the best way to migrate from on-prem to Azure DB? Can I take a full backup and restore it on Azure SQL DB?
asked 2025-01-28T20:35:11.6866667+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(0, 0%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
chuck DM
101
Reputation points
commented 2025-01-30T01:30:36.28+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(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M
2,155
Reputation points Microsoft Vendor
1 answer
Login failed for user '<token-identified principal>'.
Hello, I am encountering the following error when trying to connect via Microsoft Entra Service Principal in SSMS. I -As Username I am using the Application ID. (I tried with dieguitico0007_hotmail.com#EXT#@dieguitico0007hotmail.onmicrosoft.com but it…
asked 2024-12-16T02:36:55.21+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, 36%, 35%)' 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)
Diego Cedeño
0
Reputation points
commented 2025-01-30T00:15:49.7966667+00:00
Oury Ba-MSFT
20,106
Reputation points Microsoft Employee
1 answer
Restoring backups from a Standard tier DTU based Azure SQL Database
I am testing an environment. I have SQL server (serverless) and database using standard DTU model in UK south region, as it's a very small database. I set the backup storage to globally redundant. It seems that when I try to create a database in UK…
asked 2025-01-28T17:31:53.6266667+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, 69%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
Tim Herman
45
Reputation points
commented 2025-01-29T22:50:06.6666667+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(252.8, 60%, 34%)' 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)
Mahesh Kurva
2,425
Reputation points Microsoft Vendor
1 answer
Microsoft Azure Azure SQL Database 2014-04-01 APIs
Got this email. How do i determine which, if any, of our SQL Databases use 2014-04-01Azure SQL Database - 2014-04-01 APIs will be retired on 31 October 2025You’re receiving this email because you use Azure SQL Database APIs.To improve performance and…
asked 2025-01-27T20:06:06.0866667+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(188.79999999999998, 25%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDE%3C/text%3E%3C/svg%3E)
David Evans
0
Reputation points
commented 2025-01-29T22:38:03.7533333+00:00
Mahesh Kurva
2,425
Reputation points Microsoft Vendor
1 answer
Guidance With Azure DMS Tool For Maria DB Database Migration
Hello, I am currently working on a Database migration project migrating data from a MariaDB database hosted on AWS over to an Azure SQL DB as part of a cloud consolidation program using an IPsec VPN tunnel. While Azure Database for MariaDB would seem…
asked 2025-01-10T15:48:06.91+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, 13%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Marc Hedgley
165
Reputation points
commented 2025-01-29T21:44:15.6333333+00:00
Oury Ba-MSFT
20,106
Reputation points Microsoft Employee
1 answer
How to Sync Data Between Azure Database
I am setting up a microservice system that will have 2 systems, and each system will have 1 dedicated database. I would like to know which technology to use to synchronize data from specific tables? Is it possible to apply a filter to the…
asked 2025-01-27T18:03:26.91+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, 60%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPO%3C/text%3E%3C/svg%3E)
Pedro Otávio
20
Reputation points
commented 2025-01-29T17:44:59.83+00:00
Mahesh Kurva
2,425
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Scalability LEFT JOIN vs MERGE
Hi there, I'm UPSERTING AND handling 70 + millions of rows of UPSERT. I'm the only developer on the DB. GP_Gen5_6 LEFT JOIN DURING UNIT TEST OF ALL RECORDS 12 mins SCALED UP OVERNIGHT PROCESS GP_Gen5_20 History of existing MERGE process same operation…
![](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(272, 69%, 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)
3 answers
The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'.
Resource/subscriptions/*****/providers/Microsoft.Sql/managedInstances/smi-inf-sql-dev-east1/securityAlertPolicies/Default Operation nameUpdate managed server threat detection policy Time stampThu May 04 2023 17:26:47 GMT-0400 (Eastern Daylight Time) …
asked 2023-05-09T13:07:51.9066667+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(284.8, 70%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEV%3C/text%3E%3C/svg%3E)
Evan Van Scooter
45
Reputation points
answered 2025-01-29T15:23:17.3333333+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(188.79999999999998, 46%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECH%3C/text%3E%3C/svg%3E)
Cody Holmes
10
Reputation points
1 answer
What are the possible ways to connect an SQL db with Azure AI Search ?
I want to connect Azure AI search with SQL data base, I know it is effective to use azure sql service, but most of my data is on SQL server and the data gets updated frequently, so making copy of my data in azure sql seems inefficient. Is it possible to…
asked 2025-01-10T05:29:45.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(316.8, 49%, 40%)' 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)
Adarsh Augustine
0
Reputation points
commented 2025-01-29T10:39:47.4966667+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(227.2, 60%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHV%3C/text%3E%3C/svg%3E)
Harshitha Veeramalla
1
Reputation point Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Unstand the migration strategy from Azure SQL Managed instances
Hi Team, Is there any way to migrate our SQL managed instances from one tenant to another tenant. Do we have any detailed documentation regarding this? We should be using azure native tools to perform this lift and shift activity, let us know the…
asked 2025-01-27T11:48:50.8833333+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, 30%, 22%)' 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)
KrupaVani Gundraju (ADM)
20
Reputation points
accepted 2025-01-29T09:36:15.5533333+00:00
KrupaVani Gundraju (ADM)
20
Reputation points
1 answer
how to setup permission to user to connect azure database for power bi user
how to setup permission to user to connect azure database for power bi user
asked 2025-01-29T01:54:49.34+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, 73%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anandhswarupp
85
Reputation points
answered 2025-01-29T07:24:26.5633333+00:00
Nandan Hegde
33,711
Reputation points MVP
1 answer
How to get more details(user, execution time, IP address) for a given query ID on Azure SQL DB
How can I get all the details(user, execution time, IP address, etc) for a given Query ID? I am using Azure SQL DB
asked 2025-01-21T16:35:40.94+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, 54%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM3%3C/text%3E%3C/svg%3E)
MikeZheng-3371
46
Reputation points
commented 2025-01-28T19:31:39.6433333+00:00
Mahesh Kurva
2,425
Reputation points Microsoft Vendor
1 answer
Azure sql database taking empty space and not freeing them
My DB size is 1.2 GB something and it only has two tables with 18 and 16 rows respectively with no indexes. I used SHRINKDATABASE and the size reduced to 66MB !!! This is a significant size decrease. I am trying to understand what might be the…
asked 2025-01-24T13:55:14.0633333+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(44.800000000000004, 0%, 14%)' 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)
Ayush Shrivastava
0
Reputation points
commented 2025-01-28T19:29:40.9166667+00:00
Mahesh Kurva
2,425
Reputation points Microsoft Vendor
1 answer
Problem Retire Older Version Azure SQL APIs
Hi everyone I've gotten several emails from Azure that says Action required - Upgrade Azure SQL Database 2014-04-01 APIs to a newer version by 31 October 2025 followed by the sentence '*You’re receiving this email because you use Azure SQL Database…
asked 2024-08-26T15:53:53.9+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, 98%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Art DUNHAM
15
Reputation points
commented 2025-01-28T16:06:56.3933333+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(9.6, 95%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECL%3C/text%3E%3C/svg%3E)
Caroline L. Assucena
0
Reputation points
1 answer
Unable to connect azure SQL with r2dbc spring boot using AD group authentication
I am trying to connect with azure sql instance using AD group authentication with my spring boot reactive application using r2dbc but it seems there is no way to custom initialize the ConnectionFactory bean in configuration so that I can paas the AD…
asked 2025-01-24T04:45:36.5133333+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(89.60000000000001, 10%, 18%)' 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)
Vaibhav Kumar Singh
0
Reputation points
edited a comment 2025-01-28T14:45:28.72+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, 4%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sina Salam
16,536
Reputation points