Content
How to connect to Azure Database using Managed Identity from Workflow framework?
Hi, I am trying to connect to Azure Managed Database Instance using Managed Identity connection string. My Connection string is in the following format: Data Source=<ServerName>; Authentication= Active Directory Managed Identity; Initial…


Access primary database instance from read replica instance
Since we are starting to use read replica in our projects, we are going to migrate the our data retrieval procedures to read only database. But, we are doing the performance track inside that procedures that we are moving to read only DB and it is…


App Architecture - Any suggestions
Hey Folks, We are developing an app using which: 1. Flow reports for KPIs should be triggered at regular intervals. 2. Users accessing the flow reports should be tracked for analytics. Anyone here has suggestions on what kind of architecture to follow.…


Upsert to Azure SQL Database Failed because Interim Table Exists
I have created a Copy Activity on Azure Data Factory that moves the data from a CSV file hosted on Data Lake to Azure SQL Database. When I select the write behavior to be INSERT, the pipeline runs fine. But when I changed to UPSERT and provide the proper…
I understand that elastic jobs are not supported when using private end points using azure sql db,are elastic database querries supported
gettting the following error when trying to use elastic database query in azure sqldatabase trying to connect to a azure sql database using private end point from another azure sqldatabase getting the error failed (error -2146893022, state 0): A…


3rd party tools for Azure SQL and Managed Instance
Hi. I want to backup Azure SQL DB (PaaS) and SQL Managed Instance using a 3rd party tool. Is it possible? any recommendation? If not possible, then do Azure Data Factory can assist in copy the data to a REST service? Thank you.


How to setup Vnet integration between ASP.NET 4.8 Azure Service V3 app and SQL Managed Instance?
I just created a simple ASP.NET Web Forms app to Azure Service - Premium V3 plan. This app runs fine as long it does not access our database in SQL Managed Instance (MI). When trying to access the database (a simple SQL SELECT statement in the…


Elastic Job Schedule
Hi, I have an elastic Job and I would like to schedule it to run Monday to Friday from 8.00 AM to 5.00 PM. Any idea how I can do it, please?


ETL logs in Azure Data Factory
Hello, I am trying to get some ETL logs in adf pipelines. Firstly i need to get the exact duration of dataflow run.You can see below. But when i check the logs,i cannot find the attribute in json logs. I can find duration as coreHour unit which…


Azure SQL - Spatial Peformance Issues
Hi all, I've recently set up an Azure SQL Database with intentions to build high-performance spatial applications. Server Config: On-Prem -> SQL Server 2022 (Xeon E5-1630 CPU // 64GB 2133mhz DDR4 RAM // Samsung 870 EVO SSD) Azure SQL -> General…


Not able to copy database with name which is deleted.
We have deleted the database (ex "ABC_DB") and it is deleted successfully. now I am trying to copy a database with the same name ("ABC_DB") which we deleted but while coping it shows "A database with the same name already exists…


Import .bacpac to local SQL Server failed with SQL72014 & SQL72045
I'm trying to create a copy from Azure SQL on my local server. I created a .bacpac file on my pc with SSMS, following the site such as [https://medium.com/awesome-azure/copy-azure-sql-database-to-local-server-bff89fd06992 Then I tried to import the…


How to fix Error when requesting export database from REST API - "error": { "code": "InvalidAuthenticationTokenAudience" "message": "The access token has been obtained for wrong audience or resource" using postman
im getting an 401 error: "error": { "code": "InvalidAuthenticationTokenAudience" "message": "The access token has been obtained for wrong audience or resource" while attempting the request via…


Issue with connecting to Azure SQL MI from on prem with windows authentication
We are trying to connect to our SQL Managed Instance in Azure from an on Prem VM. We need to have it set up using Windows Authentication for our vendor. We are using AD Cloud sync to sync the vendor account over to AAD. I followed the documentation…


Azure Key Vault Bug in SSMS 19 Preview 4
Having an issue creating a new Column Master Key for Always Encrypted using Azure Key Vault. Getting the following exception. I logged in with my admin privileged account that has full access to the key vault and is an admin on the Azure SQL Server…


An exception of type System.Data.SqlClient.SqlException was thrown.
Recieved this error when running my sharepoint configuration. An exception of type System.Data.SqlClient.SqlException was thrown. Additional exception information: Cannot open database…


always encryted vs Transparent data encryption
hi friends in what situation best suited for TDE and when we should use always encrypted and what type of azure database it is supported MI or azure SQL database


SQL settings for Azure AD connect server staging mode
Hi, I have a question regarding the SQL configuration for the second Azure AD connect server. Should it be configured to point to the instance already used by the active server? Thank you in advance for your answer.= and help.


Azure SQL databases ALL go online when connecting to server
Hi all, We have setup approx. 20 Azure SQL databases (serverless with 1 hour on auto-pause). Issue: When we make a connection with SSMS or Azure Data Studio with a server and a specified database, then only the specified database resumes and…


Azure SQL with TDE - How to secure backups when TDE Protector key has been compromised
I am aware of the basic process that we need to perform when a key has been compromised, which basically involves rotating the key and revoking the compromised one - as per steps detailed in…