Azure SQL Database

1 answer

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…

asked

Anish Reghunandanan 0

edited a comment

Ryan Hill 15,991 Microsoft Employee

2 answers

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…

asked

Mathankumar Rajendran 0

answered

Erland Sommarskog 67,481 Microsoft MVP

0 answers

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.…

asked

Monisha Barooah 21 Microsoft Employee

0 answers

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…

asked

Su Wang 0

0 answers

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…

asked

Pamidimukkala, Ramakrishna 0

2 answers

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.

asked

Vivek Mishra 0

answered

GeethaThatipatri-MSFT 14,941 Microsoft Employee

1 answer

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…

asked

Jan J. Vopalensky 0

answered

Jan J. Vopalensky 0

8 answers

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?

asked

John Paul Attard 1

edited an answer

ramesh 0

1 answer

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…

asked

Mustafa Ispir 21

answered

Pratik Somaiya 4,026

2 answers

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…

asked

Lachlan Moerenhout 0

commented

ShaktiSingh-MSFT 4,666 Microsoft Employee

2 answers

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…

asked

manish singh 5

commented

ShaktiSingh-MSFT 4,666 Microsoft Employee

1 answer

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…

asked

Kazuaki Mizota 0

commented

ShaktiSingh-MSFT 4,666 Microsoft Employee

4 answers

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…

asked

Brian Cress 0

edited the question

ShaktiSingh-MSFT 4,666 Microsoft Employee

2 answers

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…

asked

Ryan Pighin 16

commented

Ryan Pighin 16

0 answers

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…

asked

Brown, Alex 1

commented

Erland Sommarskog 67,481 Microsoft MVP

3 answers

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…

asked

Tevon2.0 571

edited the question

Oury Ba-MSFT 9,561 Microsoft Employee

1 answer

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

asked

Anshal 816

answered

Dimple Rane 636

1 answer

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.

asked

Mamadou Coulibali 241

accepted

Mamadou Coulibali 241

2 answers