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
ADF - CDC - enable and disable CDC tables during deployment
Hi, I have setup ADF pipeline for data sync of tables between Azure SQL Database to SQL Managed Instance databases. I am using Data Flow and CDC to track changes and sink activity to replicate it to target. However, when we deploy any table changes (add…
Azure SQL Server Database serverless or Elastic pool
I'm just getting started with Azure SQL Database and have some questions about pricing. I currently have about 7 databases in use with a free student subscription plan for a development environment. Most of the databases are only used occasionally when…
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…
Unable to purchase support plan
Hello, I am trying to purchase a support plan with Azure. I am unable to because I receive this message when choosing to purchase Developer support. This is preventing me from filing a support ticket for another issues I am having with a Azure…
Unable to purchase support plan
When buying a Standard Support Plan, I always encounter this error: The problem is now existing several months, but today I have a really critical issue and can contact no one about it.
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…
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…
Migrating On-prem Sql DB to Azure Managed Sql Instance
Hello, I have created recently Azure Managed Instance and looking some expert guidance as I need to restore on-prem Database first for testing but my database is in simple recovery mode as it's non-prod DB. Do I need to change recovery model to FULL then…
how to migrate azure sql database to azure synapse
I would like to migrate standalone Azure SQL database into a schema of the Azure Synapse database. How to achieve this?
Pricing for a Azure SQL database is confusing
Hi, I have created a Azure SQL database and currently am using the free version, which allows 100,000 vcore seconds. I have used the 'pause' option to stop the database once the free limit is up. Unfortunately, the 100,00 vcore seconds have ended within…
ADF Data Flow - CDC - Schema Drift not working
Hi, I have setup ADF pipeline for data sync of tables between Azure SQL Database to SQL Managed Instance databases. I am using Data Flow and CDC to track changes and sink activity to replicate it to target. Since there are multiple tables involved, I am…
Transactional Replication on a SQL Managed instance as a subscriber with pull subscription
Can we have Transactional Replication on a SQL Managed instance as a subscriber with pull subscription
Accessing environment variable in azure web app (python)
I have a django application where I am trying to fetch the environment variables required in the app. (I have refered this blog) But still I am not able to fetch the environment values. This is the code block for fetching the db connection from the…
Need to find out the IP address for the ADF
Hi Team, I have a small query. We need to grant ADF access to the production database. However, we cannot allow anyone to access the database freely. To overcome this, I need to share my ADF IP addresses so that they can be whitelisted to access the…
'Invalid column name 'is_change_feed_enabled'.'; detailedError - A database operation failed with the following error: 'Invalid column name 'is_change_feed_enabled'.'
When I tried to setup link connection between on-prem sql server and Azure sql dedicated pool, took the below error. Failed to enable Synapse Link on the source due to 'Failed to enable the source database: Some internal error happened due to 'Calling…
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…
While i am trying to do Prepare data in Power BI Desktop lab we need to navigate to the D:\Allfiles\Labs\01-prepare-data-with-power-query-in-power-bi-desktop\Starter folder. but there are no files in D drive to practice
we have a lab in module 3 after lab environment is ready when I am trying to load data from D drive which is mentioned that In the Open window, navigate to the D:\Allfiles\Labs\01-prepare-data-with-power-query-in-power-bi-desktop\Starter folder. But when…
Deployment of a simple bicep takes too long
I have a bunch of biceps that deploy various parts of Azure infrastructure. All of them complete within reasonable timeframes except this guy. It runs forever, though, in fact, approves the private managed connection as supposed. Any thoughts? param…