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…
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…
On Premises and Azure SQL VM Always On Availability Groups
I am wondering if it is possible to create a SQL Always On Availability Group with on-premises servers and SQL Azure VMs. Please validate two scenarios below.
vadlidation failed -insuffisient quota cannot create / update/move resources
Hai team, im writting this beacuse I'm attempting to deploy the openAI resource, but an error message appears. stating that "vadlidation failed -insuffisient quota cannot create / update/move resources" Not sure what exactly is the issue and i…
"The multi-part identifier "sys.schemas.name" could not be bound.
Driver version 12.4.0.jre8 SQL Server version Microsoft SQL Azure (RTM) - 12.0.2000.8 Feb 2 2024 04:20:23 Copyright (C) 2022 Microsoft Corporation Problem description When we use jdbc to connect to the Azure sqlserver, if we invoke the mssql jdbc api…
how to accses azure free trial without credit card.
hello i am after al student waiting for my results. my parents dont allow me to get credit card. so how can i access azure trial. i want to learn cloud computing.
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…
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.
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…
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…
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…
Is it possible to remove the paired server in a failover group and still have the failover group itself and the listener active?
I'm configuring our stage environment to mimic production for our failover groups, but in stage I don't want to leave the West coast paired server online. I'm hoping that I can leave the fail-over groups in place so that the listener DNS entry remains…
Create Partitioned Temp Table Hit Error "Msg 1921, Level 16, State 1, Line %n Invalid partition scheme '%s' specified.
Hi all, I tried to create a partitioned table to help speed up some queries that need large range scan (so index is not helpful). There is performance improvement and the such tables can be discarded after short term use. However, the customer has…
Azure workload move tenant to tenant
Dear All, we have existing tenant with listed below workloads and we are planning to move all these workloads to new tenant. what is the best way to move it with any production impact.