Microsoft Q&A

Azure SQL Database

4,208 questions

An Azure relational database service.

Browse all Azure tags

4,208 questions with Azure SQL Database tags

Sort by: Updated
0 answers

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

Azure SQL Database
asked 2023-09-03T21:21:29.2266667+00:00
ED 41 Reputation points
edited the question 2023-09-03T22:05:25.54+00:00
Erland Sommarskog 85,741 Reputation points
0 answers

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…

Azure SQL Database
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
1,556 questions
asked 2023-09-03T13:38:10.8666667+00:00
Allee Khan 0 Reputation points
commented 2023-09-03T14:07:39.1533333+00:00
Vinodh247 4,646 Reputation points
1 answer

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…

Azure SQL Database
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
5,466 questions
asked 2023-09-02T22:25:10.9633333+00:00
Thomas 0 Reputation points
answered 2023-09-03T03:57:16.2766667+00:00
risolis 8,676 Reputation points
1 answer

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…

Azure SQL Database
Microsoft Defender for Cloud
Microsoft Defender for Cloud
An Azure service that provides threat protection for workloads running in Azure, on-premises, and in other clouds. Previously known as Azure Security Center and Azure Defender.
948 questions
asked 2023-02-16T07:22:17.59+00:00
Rishineken Pongen 116 Reputation points
edited a comment 2023-09-03T00:31:11.0733333+00:00
Madan Agrawal 0 Reputation points
0 answers

UpdateSourceControl: Failure responding to request: 2023-09-02T18:22:03.4924222Z │ StatusCode=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 │ StatusCode=400 -- Original Error: autorest/azure: Service returned…

Azure Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
16,218 questions
Azure SQL Database
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
5,799 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,850 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
5,466 questions
asked 2023-09-02T18:29:50.88+00:00
Babychen Daisy, Dona 20 Reputation points
2 answers

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

Azure SQL Database
Azure DNS
Azure DNS
An Azure service that enables hosting Domain Name System (DNS) domains in Azure.
488 questions
Azure VPN Gateway
Azure VPN Gateway
An Azure service that enables the connection of on-premises networks to Azure through site-to-site virtual private networks.
1,109 questions
Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
1,605 questions
asked 2023-08-01T14:35:52.2966667+00:00
Fazal Ameen 0 Reputation points
answered 2023-09-02T07:11:12.0133333+00:00
msrini-MSFT 7,936 Reputation points Microsoft Employee
0 answers

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…

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,850 questions
asked 2023-08-30T18:24:16.76+00:00
Oleg Serdyuk 0 Reputation points
commented 2023-09-01T21:31:22.3966667+00:00
KranthiPakala-MSFT 42,667 Reputation points Microsoft Employee
0 answers

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…

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.
10,711 questions
asked 2023-09-01T13:36:48.5033333+00:00
Hunter B 550 Reputation points
commented 2023-09-01T21:30:10.65+00:00
Erland Sommarskog 85,741 Reputation points
2 answers One of the answers was accepted by the question author.

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…

Azure SQL Database
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
3,382 questions
asked 2023-08-28T16:47:02.39+00:00
Hunter B 550 Reputation points
commented 2023-09-01T19:59:11.2966667+00:00
MuthuKumaranMurugaachari-MSFT 15,221 Reputation points
1 answer

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…

Azure SQL Database
asked 2023-08-30T00:13:00.7033333+00:00
Sudhakar Thota 0 Reputation points
commented 2023-09-01T17:53:39.74+00:00
Sudhakar Thota 0 Reputation points
1 answer

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…

Azure SQL Database
asked 2023-08-25T17:41:01.5233333+00:00
PS 311 Reputation points
commented 2023-09-01T17:28:50.54+00:00
Oury Ba-MSFT 12,996 Reputation points Microsoft Employee
1 answer

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…

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.
3,464 questions
asked 2023-08-31T10:52:21.45+00:00
Xia 0 Reputation points
commented 2023-09-01T16:23:43.6866667+00:00
AnnuKumari-MSFT 26,386 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

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…

Azure SQL Database
asked 2023-08-28T11:10:51.8933333+00:00
Jakub Pernica 105 Reputation points
commented 2023-09-01T16:19:24.04+00:00
GeethaThatipatri-MSFT 20,836 Reputation points Microsoft Employee
1 answer

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…

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.
10,711 questions
asked 2023-07-27T12:54:20.7333333+00:00
bert 5 Reputation points
commented 2023-09-01T13:40:26.9966667+00:00
Ian Keogh 0 Reputation points
2 answers One of the answers was accepted by the question author.

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…

Azure API Management
Azure API Management
An Azure service that provides a hybrid, multi-cloud management platform for APIs.
1,380 questions
Azure SQL Database
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
3,382 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,711 questions
asked 2023-08-31T16:06:57.66+00:00
Hunter B 550 Reputation points
commented 2023-09-01T13:25:35.36+00:00
Hunter B 550 Reputation points
0 answers

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…

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
572 questions
Azure SQL Database
.NET
.NET
Microsoft Technologies based on the .NET software framework.
1,929 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
8,809 questions
asked 2023-08-31T19:25:07.13+00:00
John Pike 1 Reputation point
commented 2023-09-01T11:56:12.82+00:00
Oki Kuswanda 0 Reputation points
0 answers

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…

Azure SQL Database
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
1,905 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,850 questions
asked 2023-09-01T10:50:08.98+00:00
Jonatan 0 Reputation points
commented 2023-09-01T11:47:27.8133333+00:00
Amira Bedhiafi 2,266 Reputation points
1 answer

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…

Azure SQL Database
Azure Policy
Azure Policy
An Azure service that is used to implement corporate governance and standards at scale for Azure resources.
669 questions
asked 2023-08-24T18:26:43.4433333+00:00
Vik 0 Reputation points
commented 2023-09-01T10:20:43.25+00:00
ShaikMaheer-MSFT 34,056 Reputation points Microsoft Employee
1 answer

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

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,850 questions
asked 2023-08-26T14:15:06.2566667+00:00
Kumar, Sunil 1 Reputation point
commented 2023-09-01T10:11:40.06+00:00
ShaikMaheer-MSFT 34,056 Reputation points Microsoft Employee
1 answer

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.

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,850 questions
asked 2023-08-29T20:24:42.86+00:00
Catalina García 0 Reputation points
commented 2023-09-01T10:06:27.84+00:00
ShaikMaheer-MSFT 34,056 Reputation points Microsoft Employee