How to get Hangfire Server working on Azure Production Database
We've got a strange Hangfire server issue. We've used Hangfire on an Azure App Service running against an Azure SQL database successfully for a few years. Both Development Production database servers work fine on some complex jobs. We are now having…
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…
I received a notice about retirement of Azure SQL Database 2014-04-01 APIs, what should I do? How do I identify the resources using the old version?
I received a notice about retirement of Azure SQL Database 2014-04-01 APIs, what should I do? How do I identify the resources using the old version? Sending this email to you guys as I was informed that you can run the KUSTO queries to get this detail. …
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!
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…
Unable to connect to Azure SQL database via Power BI
Details: "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured…
Connection to Azure database fails only at the first attempt in a series
I am running a very simple SQL-call through python on windows 10. This SQL-call is a part of a larger tool. When this tool is ran for the first time after, say 1 day, then the very first SQL-call that is connecting to an Azure database is failing with…
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…
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…
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…
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…
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…