Azure SQL Database
An Azure relational database service.
5,959 questions
1 answer
On-premise to Azure SQL connectivity
I'm seeking a low-cost solution for on-premise to Azure SQL connectivity. We already have an Azure environment with 4 Subscriptions in a Hub & Spoke model. Traffic from within the on-premise VPN connects to the Hub VNet via a VPN Gateway, then it…
asked 2023-06-14T16:01:58.65+00:00
TheoF
1
Reputation point
commented 2025-02-01T14:52:02.65+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, 18%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Sanjana Pushkar
0
Reputation points Microsoft Employee
0 answers
How to fix the pyodbc not found error in Azure function app
Our application, which had been running smoothly for over a month, suddenly stopped working, displaying a "pyodbc not found" error. Despite trying various solutions, including version changes, we've been unable to resolve the issue. This error…
![](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, 73%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMJ%3C/text%3E%3C/svg%3E)
0 answers
Unable to deploy the MSSQL Database Project to Azure SQL
I am trying to deploy the MSSQL database to azure SQL but the Azure DevOps pipeline is giving error "##[error]Unable to connect to target server 'XXXXXX.database.windows.net,1433'. Please verify the connection information such as the server name,…
asked 2025-02-01T06:22:22.2166667+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, 63%, 20%)' 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)
Ketan Gohil
0
Reputation points
asked 2025-02-01T06:22:22.2166667+00:00
Ketan Gohil
0
Reputation points
1 answer
One of the answers was accepted by the question author.
ADF - CSV file with more than 2000 columns, need to create multiple tables in the sqlserver using Azure Data factory
I have csv file with more than 2000 columns and 20gb file size. Have to create multiple tables in sqlserver from the csv file using Azure Data factory. here is the file columns col1 col2 col3 col4 col5 col5 ...... i have to create tables with below…
![](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(156.8, 56.00000000000001%, 25%)' 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)
1 answer
Bugs in Azure Portal With PITR Restore of a CDC-Enabled Database Between SQL Managed Instances
When using the Azure Portal to the a Point In Time Restore (PITR) of a database on SQL Managed Instance: The restored database does not have the source database’s CDC Capture's Retention period in its [msdb].[dbo].[cdc_jobs] record (it contains the…
asked 2025-01-17T18:55:34.7333333+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(28.799999999999997, 33%, 12%)' 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)
sguidos
10
Reputation points
commented 2025-01-31T23:38:41.2633333+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-31T22:24:43.0166667+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,430
Reputation points Microsoft Vendor
0 answers
Azure AD Admin cannot access the Azure SQL database over VPN
I have setup an Azure SQL database and secured behind Azure VPN. Azure VPN is already configured to use Azure AD and works fine. When connecting to the database, I can use a local IP as I have to connect to the VPN before connecting to the database.…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,959 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.
1,092 questions
asked 2025-01-31T16:31:47.0466667+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, 59%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Mano
0
Reputation points
commented 2025-01-31T20:12:24.5333333+00:00
Mahesh Kurva
2,430
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
How do I update an Azure SQL Database to a newer version of the resource API?
I got this email from Azure Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025 You're receiving this email because you use Azure SQL Database APIs. To improve performance and security, we're updating Azure SQL Database…
asked 2022-11-02T10:04:56.997+00:00
Arve Svendsen
46
Reputation points
commented 2025-01-31T15:19:46.13+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(230.39999999999998, 62%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Thomas
6
Reputation points
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-31T14:56:28.1166667+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
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
edited a comment 2025-01-31T14:52:10.8833333+00:00
Satya Varaprasad
1
Reputation point
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-31T14:38:07.6633333+00:00
Vijayalaxmi Kattimani
1,065
Reputation points Microsoft Vendor
1 answer
Geo Replication,Failover Group and DB Copy, DB backup and restore
Hello Everyone, As I and my team already know that, When you re-enable geo-replication between DB1 (the primary) and DB2 (the secondary), the replication process begins asynchronously. The time it takes for DB1 to replicate changes from DB2 after…
asked 2025-01-31T05:39:44.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(147.20000000000002, 89%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Aryaa Kotian
0
Reputation points
answered 2025-01-31T06:20:44.3233333+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
One of the answers was accepted by the question author.
High compute at 3 AM without any manually configured jobs
Hi, Recently I set up an Azure SQL database, with hardly any data in it. Current used space is 25 MB, so nothing much. However, every morning around 3 AM, I see CPU percentage going up, without any activity that I am aware of. I did not configure any…
asked 2025-01-27T06:21:11.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(9.6, 43%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Johan Beemsterboer
20
Reputation points
accepted 2025-01-31T04:23:57.86+00:00
Johan Beemsterboer
20
Reputation points
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-31T01:27:07.02+00:00
Sai Raghunadh M
2,155
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-30T23:12:54+00:00
Mahesh Kurva
2,430
Reputation points Microsoft Vendor
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
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
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,430
Reputation points Microsoft Vendor