"Sync to other databases" is missing
Under Data management, select Sync to other databases is missing, I'm the Global Admin / Owner of the Database and Subscription so I think this can't be an access Issue.
How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server)
How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server) The firewall and network settings looks fine. However we are…
Issue Connecting With An Azure SQL Database from .NET WinForms Application
I'm having an issue connecting to an Azure SQL database from a WinForms application after it has been packaged using InstallShield. The database exists on a virtual network and I'm using a virtual network gateway point-to-site connection. The database is…
can we use Azure SQL Managed Instances with the latest Entra ID Connect servers v2 hosted in Azure ?
I want to know if we can use Azure SQL Managed Instances with the latest Entra ID Connect servers v2 hosted in Azure ?
Sql server Metrics : is 100% CPU percentage is a blocker for all DB operations?
HI All We have observed a case in our database where the CPU perncetage is 100% for quite some time but my application are still able to hit & operate over DB, is 100% CPU usage isnt a blocker for DB operations ?? I see 2 CPU metrics 1) CPU…
How do I create a new Server
On my initial creation of our Azure SQL account I was asked to create a server, so I started with a development server housing several databases, but now I'd like to create a test/staging and production server so that I can migrate updates to databases…
When I installed Azure Data Studio connected to SQL version 2022 and wanted to restore advanturework 2022 for practice, there was no Restore data section when right-clicking on the Database, only Filter and Refresh sections. How to fix this error? SQL Se
When I installed Azure Data Studio connected to SQL version 2022 and wanted to restore advanturework 2022 for practice, there was no Restore data section when right-clicking on the Database, only Filter and Refresh sections. How to fix this error? SQL…
Copy activity throwing an error, when a auto incremented column is there on the Sink side
Hello Team, I am trying to copy data from Amazon S3 to Azure SQL database. On Azure SQL side I have set an autoincrement column(Row_Index) in a table, however the copy activity throws an error that "Column 'Row_Index' does not allow…
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…
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…
How to fix "Failure happened on 'Source' side A task was canceled" error
Data load from Salesforce object with 1million records fails with the below error in Azure Data Factory: Failure happened on 'Source' side. 'Type=System.Threading.Tasks.TaskCanceledException,Message=A task was canceled.,Source=mscorlib,' The data load…
Creating new linked services returns SqlFailedToConnect
I'd like to start by first stating that this is a continuation of my efforts to connect an Azure SQL DB to Data Factory via the Linked services. Creating new linked services returns InvalidCredentialReference My new error is below in the azure portal in…
Azure Data Sync is taking longer than Expected for data sync.
Hi Team, I am doing POC for Bi-Directional data Sync using Azure Data Sync Approach. I am facing following Issues - The minimum time between each sync across databases is 5 seconds. Can this be minimized further. Assume we are bi-directionally…
"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."
One of the users receive this error. is this issue at our end or at microsofts ?
bit null ,0
Hey Team, have column1 datatype (bit,null) so it only takes values like 0 and 1 but i want true , false as well...how to get that in same datatype or in different one
How do I copy all columns properties with copy activity in data factory
Hi, I'm copying data from one DB to another DB with copy activity and auto create table. I noticed that when the table is creating on the target side it is creating with the column size and type but all the other properties are lost, for example…
From Synapse notebook, trouble connecting to Azure SQL using system managed identity
I can create a Linked Service to my Database using my Synapse system-managed identity. This works fine, and the "test connection" shows success. But for the life of me, I can't figure out how to do it in a Python notebook. Here is the…
Incremental ETL From Mysql to Azure
Hello Professionals, I am having a totally new experience with AZURE as I have never worked on it , but due to some conditions I have to use AZURE , I am having some issues In making a incremental Data Flow that should extract data from 4 MySQL Server…
Parameters for switch between linked services
I have a pipeline in Azure Synapse which has multiple dataflows and I have 2 linked service how can I use the pipeline parameters to switch between linked services without changing the linked services in each data manually.
Connection failed
Spark job failed: { "text/plain":…