Azure SQL Database
An Azure relational database service.
5,205 questions
1 answer
One of the answers was accepted by the question author.
Azure Data Synch - Bulk Inserted records not synching
I am using the Azure Data Synch tool to synch data from an Azure SQL DB to On Prem. In general it is working. On one table when a bulk insert is done the bulk inserted records do not synch from the azure hub database down to the on prem database. The…
asked 2021-09-24T20:03:46.907+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, 39%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
David Burt
26
Reputation points
commented 2024-05-20T13:42:37.2966667+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(243.2, 42%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDR%3C/text%3E%3C/svg%3E)
Deekshith Reddy G
20
Reputation points
0 answers
Azure - Vector DBs Do they support encryption at REST ?
Do any of the below Azure Vector DBs support encryption at REST ? Azure AI Search: Demonstrates how to store and query embeddings from text data. Azure Database for PostgreSQL: Shows how to work with vector data in a PostgreSQL database. Azure Cache for…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,205 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.
983 questions
asked 2024-05-20T09:23:25.2566667+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, 86%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Raghavan, Srinivasan
0
Reputation points
commented 2024-05-20T13:38:07.89+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(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
13,836
Reputation points Microsoft Employee
2 answers
Sync failed due to sync group out of date although it was working fine same day
Sync failed due to sync group appear out of date with no reason. It was running perfectly until this morning then stopped all of sudden. This issue appeared today although there was no previous errors or warnings. Deleting and re-creating the sync group…
asked 2023-05-02T19:57:00.6033333+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(240, 42%, 33%)' 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)
George Raphael
0
Reputation points
commented 2024-05-20T13:26:39.0366667+00:00
GeethaThatipatri-MSFT
27,887
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
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
60
Reputation points
commented 2024-05-20T13:19:59.95+00:00
GeethaThatipatri-MSFT
27,887
Reputation points Microsoft Employee
2 answers
IP has been changed?
Hi Are there any updates/changes on the MSSQL instance in the last 1-2 days? Today we found that P has been changed. Let us know Thanks
asked 2023-07-31T14:16:08.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(259.20000000000005, 92%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Ayan Mukherjee
0
Reputation points
commented 2024-05-20T13:19:56.6466667+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, 44%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
Emil
0
Reputation points
4 answers
Transactional Replication on a SQL Managed instance as a subscriber with pull subscription
We are doing a transactional Replication to a SQL Managed instance (subscriber) with pull subscription from On-Prem(Publisher/Distributor) We are seeing uninitialized subscription on the replication monitor. How can we troubleshoot this
![](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(124.80000000000001, 84%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENV%3C/text%3E%3C/svg%3E)
2 answers
Can't able to connect the VM installed postgresql from ADF
Hi Team, We are unable to access the PostgreSQL from the ADF linked server. it's a azure PostgreSQL flexible server, and we have enabled the "Allow public services" setting within Azure for this server. However, we are still unable to create a…
asked 2024-05-14T06:10:02.6633333+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, 79%, 21%)' 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)
Aravind
20
Reputation points
answered 2024-05-20T10:52:45.1733333+00:00
ShaikMaheer-MSFT
38,126
Reputation points Microsoft Employee
2 answers
Is is possible to replicate Azure SQL Backups to a external cloud
I have configured backups for my Azure SQL database and I'm interested in replicating the LTR backups to an external cloud like AWS or GCP. For example, if I can configure Azure to place the LTR backups into a storage account, then I could build the…
asked 2024-05-14T21:10:30.66+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(86.4, 4%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Kevin Schmidt
0
Reputation points
answered 2024-05-20T10:34:36.8866667+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(313.6, 22%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
degngo
10
Reputation points
1 answer
Reclaiming free space from TempDB in azure sql managed instance
the TempDB on my azure sql managed has grown to 350 GB but 99% of that space shows as unused. i tried to shrink the database and individual files but the server is not freeing up the space. the space is still reserved for tempdb. Microsoft docs is…
asked 2024-05-17T12:34:07.53+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, 1%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH6%3C/text%3E%3C/svg%3E)
HusainIbrahem-6130
0
Reputation points
answered 2024-05-20T09:48:07.2133333+00:00
MikeyQiao-MSFT
650
Reputation points Microsoft Vendor
3 answers
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
commented 2024-05-20T09:00:54.8533333+00:00
PRADEEPCHEEKATLA-MSFT
78,986
Reputation points Microsoft Employee
1 answer
How to add Azure SQL Database as linked service to Azure Data Factory
I keep running into errors adding Azure SQL as a linked service to Data Factory. I'm new to Azure so please bear with me. Following all the online guides, I've done all of the following: On the SQL Server side: Under Microsoft Entra ID, enabled…
asked 2024-05-07T04:05:57.0066667+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, 44%, 40%)' 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)
shellkyle
0
Reputation points
commented 2024-05-20T08:12:12.92+00:00
PRADEEPCHEEKATLA-MSFT
78,986
Reputation points Microsoft Employee
1 answer
Help with an architecture design
Hello, We have a European customer who wants their data to be located in Europe. We also want to upgrade our current on-prem SQL Server to an Azure Managed Instance (Azure SQL Database is out of scope). Our main database is located in the US, and we need…
asked 2024-05-17T15:41:53.2933333+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, 60%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGJ%3C/text%3E%3C/svg%3E)
George Javadian
0
Reputation points
answered 2024-05-20T07:49:23.3033333+00:00
Marco Zemp
235
Reputation points
2 answers
Azure SQL MI Database Manual Backup & Retention Policy
why do we get such an error when we try to do manual backup for sql server managed instance? In this backup we redirect the backup to url (storage account), but it fails due to encryption error. when we also use command line it fails with the same…
asked 2024-05-19T08:21:44.4666667+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, 16%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFA%3C/text%3E%3C/svg%3E)
Fadi Alzebdeh
25
Reputation points
edited a comment 2024-05-20T05:14:38.2233333+00:00
Alberto Morillo
32,981
Reputation points MVP
1 answer
Error accessing Azure sql from Azure databricks using jdbc authentication=ActiveDirectoryInteractive
Getting below error while accessing Azure sql using jdbc from Azure databricks notebook, com.microsoft.sqlserver.jdbc.SQLServerException: Failed to authenticate the user p***** in Active Directory (Authentication=ActiveDirectoryInteractive). Unable to…
asked 2024-05-14T11:35:08.7566667+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, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Pankaj Mendi
0
Reputation points
commented 2024-05-20T05:10:21.33+00:00
PRADEEPCHEEKATLA-MSFT
78,986
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Azure Data Flow Sink - Connection string is not valid or missing Server/User/Database properties
Could you please assist here to resolve this issue below ? We are trying to read Delta table and store it as table in Azure SQL Database as using ADF Data Flow. Source Delta table via inline dataset from ADLS Gen2 its working fine and slink is getting…
asked 2024-05-13T06:36:57.6633333+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, 84%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
Kashif Ahmed
40
Reputation points
accepted 2024-05-20T05:09:42.0966667+00:00
Kashif Ahmed
40
Reputation points
2 answers
Why do I copy files to the container? docker cp Documents/sql/QuanLySP.bak azuresqledge:/var/opt/mssql/backup Successfully copied 2.87MB to azuresqledge:/var/opt/mssql/backup was successful. But when I go into
Why do I copy files to the container? docker cp Documents/sql/QuanLySP.bak azuresqledge:/var/opt/mssql/backup Successfully copied 2.87MB to azuresqledge:/var/opt/mssql/backup was successful. But when I go into…
asked 2024-05-18T09:10:39.41+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(204.8, 23%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAN%3C/text%3E%3C/svg%3E)
a47777 Nguyễn Bá Hoàng
0
Reputation points
edited an answer 2024-05-18T19:54:49.69+00:00
Alberto Morillo
32,981
Reputation points MVP
1 answer
Is it Azure Managed Instance storage having size limit to upload the backup file?
Hello, I am trying to upload the .bak files from my on-prem Sql Server database backup but it's not letting me to load it. I tried with smaller Database and that works but trying to even less then 300 MB database size but not working. Is it Database…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,205 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.
983 questions
![](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(150.4, 17%, 24%)' 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)
1 answer
How to move/change Azure SQL Server from one region to another?
We have one Azure sql server hosted in the East US location in Azure and now we want to change its location to some other location. How can I do this? Appreciate it if you give a resolution for this.
asked 2024-05-17T11:33:28.2066667+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(140.8, 76%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
RAJ KUMAR REDDY AVULA
0
Reputation points
answered 2024-05-18T15:52:30.83+00:00
Alberto Morillo
32,981
Reputation points MVP
asked 2024-05-16T18:33:09.84+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, 70%, 16%)' 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)
sherif samy
0
Reputation points
commented 2024-05-18T15:16:37.6066667+00:00
Erland Sommarskog
102.2K
Reputation points
5 answers
Error Fix (Database engine service failed in sql server 2022 and 2019)
Hello i am having troubles installing sql server 2022. my error is sql database engine fails to starts steps taken to install the sql on my laptop, was that i changed the account name of database engine service ( i did this because i have tried…
asked 2022-11-23T00:01:59.227+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(64, 54%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
Nelson Nwachia
36
Reputation points
answered 2024-05-18T08:36:47.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(249.60000000000002, 34%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
Alok Jha
0
Reputation points