Content
SQL Server is Inaccessible
Hi @MICROSOFTMICROSOFTMICROSOFT , I got an issue saying that my SQL Server is Inaccesible. This started last Friday 1st of September at about 4PM New Zealand time. Are you able to shed light on this? Cheers, Eden
What are the recommended best practices for optimizing SQL Server performance in a high-transaction database environment?
Hi there hope you guys be fine I want to know about my SQL database actually I'm currently working on allee.store this website base AI Tools & snaptik.mom is based tiktok video downloader I need some assistance about SQL database my windows panel…
Can't Find My Resource
This is going to sound incredibly dumb, but I am a developer trying to figure out this whole Azure thing so please have patience with me. I created a website many many months ago, and I hosted it in Azure. I know it is hosted in Azure because it has a…
VA2108 - Minimal set of principals should be members of fixed high impact database roles
Got this alert . VA2108 - Minimal set of principals should be members of fixed high impact database roles and I have attached the screenshot below . The only user id that I see different is bulkadmin. If I'm planning to remove it , how should i go ahead…
UpdateSourceControl: Failure responding to request: 2023-09-02T18:22:03.4924222Z [31m│[0m [0mStatusCode=400 -- Original Error: autorest/azure: Service returned an error. Status=400 Code="BadRequest"
When I am running terraform apply in azure release pipeline, Iam getting error UpdateSourceControl: Failure responding to request: 2023-09-02T18:22:03.4924222Z [31m│[0m [0mStatusCode=400 -- Original Error: autorest/azure: Service returned…
Unable to connect SQL database with Private Endpoint over VPN
Hello , I configured Private Endpoint for azure SQL database but i am unable to connect with private endpoint over the private network and also i need to attach tha database with vpn so that i can connect database with VPN directly.(P2S VPN).
The input is not a valid Base-64 string as it contains a non-base 64 character
The goal is to read data from azure sql db and load it into Azure Data Lake Storage Gen2. I created parametrized Linked Service that connects to ADLS gen2. Supplied URL and Access Key - test connection works fine. After that I created CSV dataset and…
How to use Less than and greater than query parameters with Input Binding in SQL Database
I'm using input binding to display a sample SQL database table through an API, and I've got it working to return the entire table. Now, I'm trying to allow users to input their own query parameters. I want to know if users can use query parameters with…
How to present SQL Database data in browser using Azure Function in APIM
I'm currently working on a company project and although I'm a little bit familiar with using APIM, Azure Functions, and Azure AD B2C, I am not as familiar with using SQL databases with them. My specific question involves presenting SQL data. How would I…
Business critical tier - IOs - min and max inserts into the table are 340 and 18061 - wide variation. Unable to understand why such a big gap in IO
I am running 32 parallel threads from 2 machines, each having 16 processors to call 16 procedures in the database just inserting one record by each one. I am doing this for testing the IO limits that are promised for Business Critical tier…
Importing a database into SQL Elastic Pool is taking longer than expected
Hi All, I am currently working on a POC and attempting to import a 300mb DB into SQL Elastic Pools. While the process initially started fine, it has been over 14 hours and it's still not complete. Can anyone provide any insights into why it may be…
Synpase Data flow debug with no line to insert but insert duplicates when running pipeline
I'm using Data flow in Azure Synapse to read csv files and insert/update data into SQL Database. The data has composite primary key of 5 columns, all in format nvarchar(4000). I add lookup to join both source based on key I add alter row to insert only…
Deploy Azure SQL Database programmatically
Hello, I'd like to know what are my options for such scenario: Let's say I have a multitenant application. I want to onboard new tenants from my admin GUI. Each tenant will needs it's own SQL Database deployed in Azure. After specifying things like…
Replication Monitor not connecting to Azure Managed instance in SSMS 19. But works in SSMS 18
Hi As part of a migration from server side SQL Server to Azure Managed Instance, I have configured replication successfully, however I am unable to add the Publisher (the Managed Instance) to Replication Monitor in SSMS 19. I follow these steps: Right…
Error with linking Azure Function hosted in APIM to SQL Database
Hi, I've been trying to link my Azure Function hosted in APIM to my company's SQL database. Below is the Azure Function's code; I added "SqlConnectionString" to my application settings as well. For some reason, it hasn't been working. My Azure…
Sync data of Table A between SQL Server 1 and SQL Server 2
One is live and SQLSVR2 is a backup. From time to time, I may need to switch them so I am writing a sync application that uses ADO .Net to read the modified/new rows from SQLSVR1->Table A and update/insert/delete them from SQLSVR2->Table A. These…
Having problems with my mapping data flow with JSON as input
Hello, I previously posted this: https://learn.microsoft.com/en-us/answers/questions/1323602/having-problems-with-my-daily-load-of-data-through Since I'm not getting any responses I'm doing a new thread with the latest update. So we believe to have found…
Built-in Policy "Deploy - Configure diagnostic settings for SQL Databases to Log Analytics workspace" is not working for "Dedicated SQL pool" resources
Built-in policy "Deploy - Configure diagnostic settings for SQL Databases to Log Analytics workspace" applies to all the resources of type "Microsoft.Sql/servers/databases". Although it has been working fine for the actual SQL…
How to use ADF copy activity to map complex JSON to table
I would like to insert the data from copy activity (REST API as source) to Snowflake table (Sink). While using the mapping provided by copy activity is giving option to map all the elements in the nested JSON to columns in table. In the below example,…
How can I setup that my stored procedure start first than other components in pipeline
I created a pipeline to copy data from blob to sql database and add a stored procedure component, so I need that first the copy data activity be execute and then the stored procedure.