Azure SQL Database
An Azure relational database service.
5,115 questions
1 answer
How to fix network-related error while connecting to SQL Server
Hello All, Before i am reprimanded, i have looked through previous Q&A and attempted to implement the fixes but i am not having any success. I have a simple Azure SQL Server with a few databases, those databases are used for various ETL in…
Azure SQL Database
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
937 questions
asked 2024-03-28T16:27:11.0333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 57.00000000000001%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
JBrenner_SYK
0
Reputation points
commented 2024-04-22T17:57:30.0533333+00:00
Oury Ba-MSFT
16,076
Reputation points Microsoft Employee
2 answers
Azure SQL DB Autoscaling issue
Hello, I'm currently facing an issue with automating the scale up/down of my Azure SQL DB. When the DB experiences high DTU usage and the auto scale-up is triggered by an alert runbook, the query that was running on the DB gets interrupted, causing my…
asked 2024-04-17T15:38:07.7833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 91%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
MoTaar
290
Reputation points
answered 2024-04-22T17:55:30.33+00:00
Oury Ba-MSFT
16,076
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How to retrieve SQL Database price with SQL Licence, using the azure retail prices
Hello, I'm trying to retrive the SQL Database prices using the Azure Retail Prices API, but I'm not finding the SQL license price, i'm finding only the "hardware" price Example using powershell: $url =…
asked 2024-04-19T17:46:24.72+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 39%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPZ%3C/text%3E%3C/svg%3E)
Pedro Zuzi
21
Reputation points
accepted 2024-04-22T17:43:16.4333333+00:00
Pedro Zuzi
21
Reputation points
1 answer
One of the answers was accepted by the question author.
Utilizing Azure Key Vault secrets for secure password management in Apache spark connector for SQL Server
In the provided code example, our team demonstrates using a hard-coded username and password for connecting to SQL Server using the Apache Spark connector. However, for enhanced security, I want to utilize a password stored in Azure Key Vault instead of…
asked 2024-04-18T16:57:26.27+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 86%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Thomasville99
260
Reputation points
commented 2024-04-22T17:35:16.8133333+00:00
Thomasville99
260
Reputation points
2 answers
How can I copy tables and data from one azure db to another azure db
I need to copy tables from our production azure DB over to our new azure test DB for development and testing purposes. I've tried using USE and :CONNECT commands from the production DB but it will not connect to the test DB environment. Is there a way to…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,115 questions
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
937 questions
asked 2024-04-19T23:31:21.83+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 31%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
Joseph G
5
Reputation points
commented 2024-04-22T17:26:18.0866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Rahul Randive
8,181
Reputation points Microsoft Employee
0 answers
Postgresql flexible server on azure unplanned failover is not working in a Zoneredundant HA environment.
Hi all, On Azure we have a PostgreSQL-Server with Zone-redundant HA. When we trigger a forced Failover, the Server goes in the "Updating state" and that is the only information which we see about PostgreSQL flexible server on Azure. How we can…
asked 2024-04-22T14:27:14.8433333+00:00
Serkan Aytekin
0
Reputation points
commented 2024-04-22T15:30:10.35+00:00
Serkan Aytekin
0
Reputation points
2 answers
hii want to run stored procedure in synapse but ima getting an error ,can anyone help me
query: USE gold_db GO CREATE OR ALTER PROC CreateSQLServerlessView_gold @ViewName nvarchar(100) AS BEGIN DECLARE @statement VARCHAR(MAX) SET @statement = N'CREATE OR ALTER VIEW '+@ViewName+' AS SELECT * FROM OPENROWSET(BULK…
asked 2024-04-18T16:53:48.23+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 15%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
naveena kankipati
0
Reputation points
accepted 2024-04-22T10:57:21.55+00:00
naveena kankipati
0
Reputation points
2 answers
Restore Azure SQL Database from GeoBackup to a different subscription
Hi everybody, I'm facing with this issues: i need to restore an azure SQL database from GeoBackup to a different server in a different subscription, but this error occurs "Long running operation failed with status 'Failed'. Additional Info:'The…
asked 2024-04-12T09:15:18.03+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 94%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Simona Pantini
45
Reputation points
edited the question 2024-04-22T10:51:15.87+00:00
SadiqhAhmed-MSFT
37,206
Reputation points Microsoft Employee
1 answer
Azure workload move tenant to tenant
Dear All, we have existing tenant with listed below workloads and we are planning to move all these workloads to new tenant. what is the best way to move it with any production impact.
asked 2024-04-22T10:02:48.6933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 56.00000000000001%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rakesh Kumar
456
Reputation points
answered 2024-04-22T10:13:53.7266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 38%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Marcin Policht
9,655
Reputation points MVP
1 answer
Logic App - Store query result from Azure SQL in to Sharepoint and retrieve back the link
Hi All, I've very basic requirement but unable to chalk it out, how to do it. I have one standard logic app workflow. It will be http triggered. Once triggered, it will run a stored procedure on one Azuer DB table and store the result as JSON in…
asked 2024-04-22T03:33:02.6+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 31%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPD%3C/text%3E%3C/svg%3E)
Pratim Das, Partha C
266
Reputation points
edited an answer 2024-04-22T04:12:47.8266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 1%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Patchfox
3,621
Reputation points
1 answer
facing an problem while registering on primise sql server to azure purviw
facing an problem while registering on primise sql server to azure purviw as it showing invalid linked service at the time of test connection what could be the rason. adding proxy to the integration run time will cause this issue?
asked 2024-04-08T04:23:45.17+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 15%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
Thota Harsha Vardhan
0
Reputation points
commented 2024-04-22T04:05:56.7533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 11%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Sangeetha Menon
0
Reputation points
0 answers
Cross tenant writes to sql
How to write from a different tenant (say Mooncake, Fairfax) running app service (WebJob) to an Azure SQL in PME tenant without using sql conn string. Can SPN be used for the same, if yes where should the base registration lie
asked 2024-04-19T04:34:10.53+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 55.00000000000001%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Saksham Chhabra
5
Reputation points Microsoft Employee
commented 2024-04-22T03:45:34.7+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
13,271
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How to split rows and columns by using ADF?
How can I retrieve data from the following table by using ADF lookup activity and want to get the result as below? Thanks
asked 2024-04-15T15:57:51.3866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 32%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZY%3C/text%3E%3C/svg%3E)
Zhu, Yueli YZ [NC]
235
Reputation points
commented 2024-04-20T14:40:18.9366667+00:00
Ramesh D
1
Reputation point
2 answers
One of the answers was accepted by the question author.
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 2023-01-27T22:03:15.32+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 83%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
Pamidimukkala, Ramakrishna
25
Reputation points
commented 2024-04-19T23:19:09.43+00:00
Oury Ba-MSFT
16,076
Reputation points Microsoft Employee
0 answers
Getting error "Could not create the marketplace item" for any resource I am trying to create
Getting error "Could not create the marketplace item" while creating any resource. It was working fine an hour ago and suddenly not able to create any resource. Below is my subscription details.
asked 2024-04-19T14:00:11.5233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 94%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Abhisekh Paul
0
Reputation points
commented 2024-04-19T14:49:09.5866667+00:00
GeethaThatipatri-MSFT
27,017
Reputation points Microsoft Employee
3 answers
One of the answers was accepted by the question author.
Export or query for all requests SQL in DW database in Azure Synapse
Hi, I need to analyse the quantity of SQL requests in views of DW database in Azure Synapse. In the tool there is a monitor of SQL requests, but not is possible export the data. There is a table where I can see this data, or other way to consult the…
asked 2024-04-17T14:41:03.0833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 45%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJO%3C/text%3E%3C/svg%3E)
João Felipe Barbosa Cerqueira Carvalho
40
Reputation points
answered 2024-04-19T11:48:59.5766667+00:00
João Felipe Barbosa Cerqueira Carvalho
40
Reputation points
2 answers
How to read excel document from sharepoint directly dump it in Azure SQL using Azure data factory ?
I want to access excel document from SharePoint and without downloading that to data lake or blob storage, use data factory to read the content of it and directly dump it in Azure SQL.
asked 2024-04-15T07:24:19.01+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 52%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHD%3C/text%3E%3C/svg%3E)
heta desai
247
Reputation points
commented 2024-04-19T08:04:58.02+00:00
AnnuKumari-MSFT
30,601
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure Mapping Data Flow why CDC does not work with composite key?
Hello, Description: As a source I have SAP CDC dataset, as a target - Azure Dedicated SQL Pool. Created mapping data flow should take data from SAP BW and merge changes to the table in Dedicated SQL Pool. Loading approach -…
asked 2024-04-04T07:08:24.6266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 64%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
Tamashevich, Tatsiana
40
Reputation points
accepted 2024-04-19T07:43:12.7766667+00:00
Tamashevich, Tatsiana
40
Reputation points
2 answers
Migrate Azure SQL server instance to SQL managed instance
Dear forum, We're planning to migrate our DBs on a SQL server instance to a SQL managed instance. We're focussed on migration our dev/test instance first before doing production. The back-ups are done using the Azure Recovery Vault service. We would like…
asked 2024-04-18T13:26:25.6633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 14.000000000000002%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
NIJSTEN Stephen
60
Reputation points
edited the question 2024-04-19T03:52:59.58+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
ManoharLakkoju
535
Reputation points Microsoft Vendor
2 answers
Looking for guidance on integrating third-party data into our domain
Hi, My company's transactional system is MS Dynamics 365. We need to import various third-party data into our domain. I'm a Power BI developer but have been assigned this project. I'm looking for guidance on a suitable database and integration tool. …
asked 2024-04-18T16:54:37.4433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 21%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anon101
51
Reputation points
answered 2024-04-19T02:06:48.38+00:00
ZoeHui-MSFT
32,581
Reputation points