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


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


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…


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?


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…


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…


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…


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 '


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


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…


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…


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…


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?


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…


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


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…


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


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…

