I got a message from Microsoft in the last few days Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025. You're receiving this email because you use Azure SQL Database APIs. To improve performance and security, we're…
We have an application that does lot of data heavy work on the server for a multi-tenant workspace. Here are the things that it do : It loads data from files from different file format. Execute idempotence rules based on…
In Azure SQL, I'm attempting to delete any text that is present between the < and > characters to my column in my table Sample text: The best part is that. < br >Note:< br >< u> reading :< /u> <…
I have mvc 5 application that is targeting .net framework 4.8. I am trying to connect to the Azure sql db using managed identity locally but getting the following error: login failed for user token-identified principal> I've spent many hours…
I am trying to implement a very basic functionality, as follows: when a row is added in an Azure SQL Database the contents of that row are sent to a Service Bus Queue. (1)How do I send the 'row' as…
I have JSON files that at the end of the day should be inserted to SQL Database. To explain what I mean, let's assume the JSON looks like this:{ name : "John", surname : "Smith", movie: "Snatch" } And database…
I'm trying to use Sql output binding functionalities for Azure function. Below is my current configuration. I'm using Visual Studio Code as IDE Found Python version 3.9.0 (py). Core Tools Version: 4.0.4736 Commit hash: N/A (64-bit) Function Runtime Version: 4.8.1.18957…
I'm restoring an Azure SQL Database (Serverless) from a deleted database backup using Get-AzSqlDeletedDatabaseBackup and Restore-AzSqlDatabase PowerShell commandlets. The restore works, but the tags and ComputeModel are not restored with the database. I've tried using Set-AzSqlDatabase: Set-AzSqlDatabase -ResourceGroupName $resourcegroupname -DatabaseName…
I am trying to connect to Azure Serverless SQL using python but getting the following error External table 'dbo.my_table' is not accessible because location does not exist or it is used by another process. I have created the External table…
I have a Az Synapse (dedicated SQL pool) configured with managed VNet in tenant A and storage account in tenant B. The storage account is firewall protected and only certain VNets and IPs can access it. I want to created…