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.
how to restore differential azure Sql database automatically
Hello, Please suggest best approach to restore differential azure sql database. Restore/data refresh required 1-2 times daily. if we can do something using powershell/python and automation used for auto refresh. I am familiar with azure data factory for…
How to move the Azure sql database across the Azure subscription
Use case-How i can move the azure sql database (or Azure sql server) across the azure subscription ensuring the private link of that database a, vnet of the azure sql database and all the other attributes of the Azure sql database remains AS-IS after the…
Azure SQL Database connctivity
Hi Team, I have deployed azure SQL database service and I want to connect this database within the private network or office network, which configuration need to do from azure side. which IP need to whitelist from our office network? Thanks in advance!
Unable to find package 'Microsoft.Azure.SqlDatabase.ElasticScale.Service.SplitMerge'
It is related to "Deploy a split-merge service to move data between sharded databases" I followed the steps in the "Download the Split-Merge packages" (very beginning) and tried to execute the command nuget install…
Getting error "Could not create the marketplace item" for any resource I am trying to create
Getting error "Could not create the marketplace item" while creating any resource. It was working fine an hour ago and suddenly not able to create any resource. Below is my subscription details.
Azure Function Python V2 with bindings to Azure SQL Database
I'm using Azure Functions V2 (Python 3.11). Here you can read that V2 replaces the function.json file with function decorators:…
Azure SQL Database Disaster recovery
Hi Team, can you please tell me how to configure Disaster recovery to azure sql database, and what is the difference between failover group and standby replica, both are different? if different then which solution should I go? Regards
sqlcmd fails to connect to azure sql server because of mfa, but active directory says mfa is disabled
I have been following this guide: https://learn.microsoft.com/en-us/azure/azure-functions/functions-identity-access-azure-sql-with-managed-identity and have reached the step "Grant SQL database access to the managed identity". I have…
Azure SQL Free Database Offer Charging for Storage
Hi There I have a quick question regarding the Azure SQL Free Database Offer. It seems that I got charged for database storage despite not consuming the 32gb of free storage. Is there any reason why it's charging me for storage? See image for reference.
Issue with Sign-In to Student Azure Microsoft Account
Dear Community, I hope this email finds you well. I am writing to inform you that I have created my Student Azure Microsoft account recently. I have provided all the necessary educational information, and I am eagerly waiting for verification. However,…
Alternative for xp_loginconfig in MI conection
Hi Team, We are using "xp_loginconfig" Extended SP in our project for SQL server. We are providing support for SQL Azure Managed Instance connection in our project. I didn't found procedure similar to "xp_loginconfig" or…
Remove BackSlash in result of Lookup Activity.
Hi All, I am having an order table, I have written a simple query to convert it to my required schema and it works perfect in my SSMS. Query: select(select JSON_OBJECT( 'OrderNumber': OrderNumber ) as 'values' from order for Json Path )as…
extend Azure SQL always on availability group to on prem
I have an Azure SQL always on availability group with 2 servers, i need to add another on-prem node to the AG. Azure SQL AG deployed in a single subnet with DNN listener, and i already have S2S connectivity between Azure and on-prem. do i have to migrate…
CosmosDB Analytical store delete changes in sql sink
Hi I am trying to capture delete changes from Azure cosmosdb analytical store using change data capture in Azure datafactory, Source is Cosmosdb, sink is Azure sql database. In between I am flattening my file using dataflow. My insert, update is…
Failed SQL logins to MI coming from same subnet as SQLManagedInstance
We have started monitoring failed login attempts to our managed instance and see some failed connections that we can't seem to figure out what the attempt may be. Error message: A disconnect event was raised when server is waiting for Federated…
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…
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…
Parsing row counts from json output from an ADF script to pass to Stored Procedure
I have a ADF script that simply performs the following from a ForEach Loop. @Anonymous (concat(concat('select count(*) as num_rows from ', item().table_owner_schema), '.'), item().table_name) This works fine and returns the row count in the…
Elastic pool in Azure SQL & SQL server Managed instance
I have 2 doubts ) What is the right explanation Elastic pool in Azure SQL ? ) What is SQL server Managed instance that is often heard in Azure DB services & when one should use it. I have been trying to understand its significance but did…