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…
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…
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 =…
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…
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.
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…
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…
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…
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.
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 -…
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
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…
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…
Not able to connect via authentication type ActiveDirectoryServicePrincipal
I am trying to connect through connection string and auth type ActiveDirectoryServicePrincipal but it is failing with error - Failed to parse the connection string. No connection info returned. This is the connection string i am using -…
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. …
DBCC SHRINKDATABASE and DBCC SHRINKFILE throwing "Query execution timed out." after 300 seconds
I have a standalone DB and trying to use "Query Editor (Preview)" to shrink the DB or DB file. It has 500 GB max storage, 410 GB allocated, any only 152 GB used. I want to lower the allocated so that I can also lower the max. Every query…
Azure SQL Database - named replica DB performance problem
Hello everyone, I have one performance problem and one cost problem of our Azure SQL database and it's replica. Performance problem: We have a primary Azure SQL database and also a secondary read-only named replica database, which have both relative…
Upgrade SQL server 2014 to 2019 after lift and shift to Azure
Hi, We are planning to do in-place upgrade SQL server from 2014 to 2019. The server is lift and shifted to Azure so is updating the server same as updating on premise server or is there anything different. please provide suggestions. Thank you
azure Web App (running ASP.NET (MVC) seems like it does not recognise or detect azure SQL server and database
I have an Asp.NET mvc project running on an azure Web App. I also have a SqlServer with a Sql database connected. When using the sqlserver on a local project (WPF app) it gives me the data. When I try to use it on the Webapp i just get an error message…
Translation problems in the azure ai studio when connecting azure database
I have recently connected an Azure database (ticket data) using indexers and tested this in the AI Studio. However, the database contains tickets in different languages such as dutch, french, and english. When I ask the chatbot the data from the dutch…