Microsoft Q&A

Azure SQL Database

3,323 questions

An Azure relational database service.

Browse all Azure tags

3,323 questions with Azure SQL Database tags

Sort by: Updated
Updated Created Answers
0 answers

How to transfer data between two Azure SQL datatables in different databases with AAD on same Server

Hi, I have tried to do this with queries and failed, i have tried to do this with Azure Data Sync in the portal and failed. I just want to share a few columns with their data between two Azure SQL datatables in two different databases with AAD (Both are…

Azure SQL Database
asked 2023-02-03T00:56:38.7266667+00:00
Shane Francis 0 Reputation points
commented 2023-02-07T18:49:13.8066667+00:00
Oury Ba-MSFT 9,566 Reputation points Microsoft Employee
0 answers

Azure SQL DB Tables not visible in SSIS OLE DB Connection Manager

Hello Community, When I try to configure an Azure SQL database into an OLE Connection Manager in SSIS, I cannot see the tables of the database. Could someone please advise on what I could check here? My knowledge is quite basic here. Thank you very…

Azure SQL Database
asked 2023-02-02T14:53:41.0433333+00:00
Michael Corcoran 20 Reputation points
commented 2023-02-07T18:43:43.8033333+00:00
Oury Ba-MSFT 9,566 Reputation points Microsoft Employee
3 answers

Is there any way to stop/pause SQL Managed Instance

Hello, Is there any way to pause a running SQL Managed Instance. From the portal it's not possible I know but is there any PowerShell script available to check the instance and start/stop as needed to save cost. Any help will be highly appreciated.…

Azure SQL Database
asked 2023-02-03T14:23:01.1333333+00:00
Atanu Gupta 111 Reputation points
commented 2023-02-07T18:10:20.89+00:00
Oury Ba-MSFT 9,566 Reputation points Microsoft Employee
2 answers

Best way to load from Azure SQL DB to dedicated SQL pool

I want to move data from an Azure SQL Database to Synapse. I have created a SQL Dedicated pool with the following conditions: 1) Load all the tables from the database automatically, without the need to be creating for each table a pipeline. 2) Load all…

Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
2,635 questions
asked 2022-09-26T14:09:05.57+00:00
kosmos 181 Reputation points
edited the question 2023-02-07T16:05:09.16+00:00
AnnuKumari-MSFT 19,121 Reputation points Microsoft Employee
2 answers

DTU calculation

How can i calculate DTU percentage that query consumed? Are there any formulas to combine CPU, Log IO and Data IO into DTU?

Azure SQL Database
asked 2021-09-24T10:07:39.653+00:00
Dmytro Lenchuk 21 Reputation points
commented 2023-02-07T11:24:02.37+00:00
Maarten Balliere 0 Reputation points
1 answer

AAD password authentication no longer working for SQL Server access

We have users who access Azure SQL databases from computers that are not Azure joined (a legacy thing, will get improved in time). They use scripts and SSMS and access the databases via Azure Active Directory Password authentication. This stopped for…

Azure SQL Database
Azure Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
12,761 questions
asked 2023-02-02T12:51:40.99+00:00
Mark Young 0 Reputation points
answered 2023-02-07T11:07:56.57+00:00
Mark Young 0 Reputation points
0 answers

How to handle negative SPID on Azure SQL MI (SPID=-5)

I am using Azure SQL MI and executing SSIS packages through ADF Pipeline. I could see that few SP's being called through SSIS packages are getting delayed as these are blocked by SPID=-5 . We have Azure SQL MI with 16 vCore Capacity . Can anyone suggest…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,585 questions
asked 2023-02-07T09:45:01.9866667+00:00
Pooja Pakade Konde 0 Reputation points
1 answer

Large deletions blocked by negative SPID

I have a nightly "archive and delete" process that writes all data from a large, busy table >150 days old to Blob storage, and deletes the same from the hosting table. The process performance is terrible - and in fact, it may take more than…

Azure SQL Database
asked 2022-03-21T13:02:46.893+00:00
Mike Wright 26 Reputation points
commented 2023-02-07T09:36:00.4066667+00:00
Pooja Pakade Konde 0 Reputation points
2 answers

Login failed for user '

After deploying/swapping my AppService applications, I am seeing the following error occurring when connecting to my Azure Sql Database: Microsoft.Data.SqlClient.SqlException (0x80131904): Login failed for user '

Azure SQL Database
asked 2022-09-10T10:38:02.293+00:00
Mike-E-angelo 226 Reputation points
edited the question 2023-02-07T09:26:06.9966667+00:00
ShaktiSingh-MSFT 4,676 Reputation points Microsoft Employee
1 answer

A network-related or instance-specific error occurred while establishing a connection to SQL Server.

I am using a macbook m1 pro while i am connecting to azure data base it is showing an error but i have done everything correctly but i dont know what is the problem occured please help me with this

Azure SQL Database
SQL Server on Azure Virtual Machines
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
444 questions
asked 2023-02-04T18:34:19.05+00:00
Ahamed Ajas 0 Reputation points
commented 2023-02-07T08:49:34.98+00:00
ShaktiSingh-MSFT 4,676 Reputation points Microsoft Employee
1 answer

Database deployment using Azure DevOps when the database is on a private virtual network

I have got a SQL server database in azure on a private network; I would like to set up a database deployment function. As the database is no longer on a public endpoint. How can I deploy SQL changes onto the SQL server database without building a…

Azure SQL Database
asked 2023-02-06T11:33:35.9066667+00:00
MrFlinstone 406 Reputation points
answered 2023-02-07T08:43:20.0166667+00:00
Bas Pruijn 661 Reputation points
9 answers One of the answers was accepted by the question author.

join 3 views in one view

Hi Expert, i wanted to join three views in one using temp table i.e. Create view test1 as select col1,col2 into #temp1 from view1 select col1,col2 into #temp2 from view2 select col1,col2 into #temp3 from view3 select col1,col2 from #temp1 a join #temp2 b…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,585 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,858 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,131 questions
asked 2023-02-03T04:01:38.42+00:00
Shambhu Rai 726 Reputation points
accepted 2023-02-07T07:08:50.6033333+00:00
Shambhu Rai 726 Reputation points
0 answers

While configuration of Azure MI link feature Distributed AG unable to connect with MI using FQDN

I have successfully configured. SQL managed instance Link feature to replicate Database from Azure SQL VM to SQL MI, after configuration, i have checked in Distributed AG where SQL mi is showing not connected, once I clicked over there to connect it's…

Azure SQL Database
asked 2023-02-06T16:29:21.6166667+00:00
Shivendra Pratap Singh 0 Reputation points
edited the question 2023-02-07T06:00:17.2133333+00:00
AjayBathini-MSFT 0 Reputation points Microsoft Employee
1 answer

How to make a local copy of a SQL Database hosted in azure?

Hi there, I need to make a local copy of a SQL Database Hosted in Azure. Could someone help me?

Azure SQL Database
Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
779 questions
asked 2023-02-06T19:13:10.3433333+00:00
Javier Castillo 0 Reputation points
edited the question 2023-02-07T02:11:38.1366667+00:00
Seeya Xi-MSFT 12,821 Reputation points Microsoft Employee
3 answers One of the answers was accepted by the question author.

Question about Azure Dedicated SQL Pool and Azure SQL Database

I have a couple of questions that came up while going through the Microsoft Documents on Azure Dedicated SQL Pool: Unlink Azure SQL Database - Single Database, there is no way to fine-tune zone redundancy or set up replica. Is this correct? In…

Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
2,635 questions
asked 2021-09-02T19:29:42.247+00:00
Jeff Lu 31 Reputation points
answered 2023-02-06T21:44:54.9333333+00:00
Rajanish Reddy Karla 0 Reputation points
1 answer

cost free etl azure

Hi, i am new to auzre. ¿is there a free cost etl? the bbdd is a microsoft sql server. thank you for your help

Azure SQL Database
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
1,218 questions
asked 2023-02-02T14:28:40.61+00:00
PWBI 0 Reputation points
commented 2023-02-06T19:44:21.9366667+00:00
BhargavaGunnam-MSFT 7,651 Reputation points Microsoft Employee
1 answer

Confusion about granting UNMASK permissions to a SQL user.

I am trying to understand who can grant UNMASK permissions for the database at the top most level. For example, I have implemented SQL Dynamic Data masking and from what I am reading, granting the UNMASK permission on a user can be done by: Users with…

Azure SQL Database
asked 2023-02-03T00:49:01.1533333+00:00
Guerrero, Erik 0 Reputation points
commented 2023-02-06T18:24:00.5433333+00:00
BhargavaGunnam-MSFT 7,651 Reputation points Microsoft Employee
1 answer

How to connect the Azure data studio python kernal as wsl python

Hi Team, I setup my local development environment in ubuntu wsl in my windows machine. i am going to start exploring and play with Azure Data Studio i want to try python kernel in Azure Data Studio. i don't want to install it again. i just want to…

Azure SQL Database
asked 2023-02-02T17:29:03.0166667+00:00
Balaji Shanmugam 0 Reputation points
commented 2023-02-06T18:22:27.7133333+00:00
BhargavaGunnam-MSFT 7,651 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Azure Data Studio - SQL Migration extension

Fellow DBA, We are using the new Azure Data Studio with the SQL Migration Extension plug in. When you select a number of databases on an instance to evaluate, then you setup collecting performance measures, is it looking at the measures ONLY for those…

Azure SQL Database
asked 2023-01-31T16:42:43.09+00:00
Mark Gordon 661 Reputation points
accepted 2023-02-06T16:09:26.16+00:00
Mark Gordon 661 Reputation points
1 answer

Export data from Azure SQL database to blob in csv format using Logic Apps

hi, I am trying to export data from Azure SQL to Blob Storage. I need data in CSV format. I have added below connectors - so I run Proc, Parse the result, initialize an array type variable which gets the result from Parse JSON 2, and then Create CSV…

Azure SQL Database
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
1,824 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
1,420 questions
asked 2023-02-01T21:19:55.18+00:00
Mahandru, Nidhi 0 Reputation points
answered 2023-02-06T08:38:21.3066667+00:00
MayankBargali-MSFT 49,721 Reputation points Microsoft Employee