6,096 questions with Azure SQL Database tags

Sort by: Updated
1 answer One of the answers was accepted by the question author.

API call from Azure SQL database

I am working with an Azure SQL Database and currently using SQL Server Management Studio (SSMS) for text-based queries. I would like to know if it is possible to make an API call directly from the database. I am aware that Azure SQL Database may have…

Azure SQL Database
asked 2025-03-07T09:38:25.27+00:00
Renan 60 Reputation points
edited the question 2025-03-19T09:37:28.6+00:00
Vijayalaxmi Kattimani 1,720 Reputation points Microsoft External Staff
1 answer

Configuring Azure Database for Free Tier: Serverless Gen5, 2 vCores

I am using Azure's free general-purpose serverless 32 GB database for a website I am working on. In the past, it has been relatively easy to keep costs down by simply using the Basic tier. However, since I am now using the 'Free - General Purpose -…

Azure SQL Database
asked 2025-03-18T10:51:25.17+00:00
A 0 Reputation points
commented 2025-03-19T08:48:39.3166667+00:00
Vijayalaxmi Kattimani 1,720 Reputation points Microsoft External Staff
0 answers

INSERT INTO Fails in Azure Synapse Analytics with Error Code 1104.

Scenario: I am working on loading data from the EDWLanding table to the EDW table using a stored procedure in Azure Synapse Analytics. The stored procedure uses an INSERT INTO SELECT * statement to load data from EDWLanding table into EDW table. The…

Azure SQL Database
asked 2025-03-18T10:06:03.38+00:00
Akshay Gopal 0 Reputation points
commented 2025-03-19T08:15:00.63+00:00
Adithya Prasad K 245 Reputation points Microsoft External Staff
2 answers

Log TLS version being used for connections to Azure SQL Managed Instances

With Azure deprecating TLS 1.0/1.1 for Azure SQL Managed Instances, how can I log what TLS versions clients are currently using?

Azure SQL Database
asked 2025-03-06T14:48:15.5966667+00:00
Shane Schlabach 0 Reputation points
commented 2025-03-19T07:58:29.0033333+00:00
Saraswathi Devadula 160 Reputation points Microsoft External Staff
0 answers

Import job from a bacpac

I have a database Import job from a bacpac in azure blob storage that is stuck

Azure SQL Database
asked 2025-03-18T12:04:34.3533333+00:00
HH 0 Reputation points
commented 2025-03-19T07:54:43.04+00:00
Saraswathi Devadula 160 Reputation points Microsoft External Staff
4 answers

The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'.

Resource/subscriptions/*****/providers/Microsoft.Sql/managedInstances/smi-inf-sql-dev-east1/securityAlertPolicies/Default Operation nameUpdate managed server threat detection policy Time stampThu May 04 2023 17:26:47 GMT-0400 (Eastern Daylight Time) …

Azure SQL Database
asked 2023-05-09T13:07:51.9066667+00:00
Evan Van Scooter 50 Reputation points
commented 2025-03-19T07:29:14.19+00:00
Frerichs, R (Roland) 0 Reputation points
0 answers

I failing to set the Microsoft Entra admin for my Azure SQL server "Failed to set the Microsoft Entra admin for serverName: xxxxxx"

Using the Azure Portal, I checked in IAM and my logged in user is "Owner" for the Azure SQL server, but I am still unable to set the Microsoft Entra admin to my user, it keeps failing with the error "Failed to set the Microsoft Entra admin…

Azure SQL Database
asked 2025-03-17T08:31:32.95+00:00
jimzim 6 Reputation points
commented 2025-03-19T06:29:50.9333333+00:00
jimzim 6 Reputation points
1 answer

Trouble connecting Azure SQL Database to from my PC SSMS

I have paid for Support yet this form seems to be destined for a community forum (to judge by instructions above the box for input of Details. In the first instance how do I obtain the private support paid for, please?

Azure SQL Database
asked 2025-03-14T13:59:14.95+00:00
JP_BW 40 Reputation points
commented 2025-03-19T04:44:49.7066667+00:00
Oury Ba-MSFT 20,526 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

Not able to call extended stored procedure from user defined function in azure sql.

Hi Team, We have a stored procedure named "invoke_azure_function" that calls the 'sp_invoke_external_rest_endpoint'. Leveraging this, we have created a UDF that makes a call to the "invoke_azure_function". CREATE PROCEDURE…

Azure SQL Database
asked 2025-03-18T06:50:16.8966667+00:00
Rajesh Patel 40 Reputation points
accepted 2025-03-19T04:38:57.95+00:00
Rajesh Patel 40 Reputation points
1 answer

I'm trying to import a large database from a bacpac file from a local SQL Server 2016 backup to Azure SQL server but it's failing due to an internal error.

I have a large bacpac file (800GB) in Azure blob from a local SQL 2016 backup that will not load into my SQL server instance in Azure. I've tried importing using "Import Database" tab in Azure SQL Server, and also tried using Azure CLI. I'm…

Azure SQL Database
asked 2025-03-11T06:04:10.1366667+00:00
Mark Lagace 0 Reputation points
commented 2025-03-19T03:33:47.9233333+00:00
PratikLad 320 Reputation points Microsoft External Staff
1 answer

Batch add data inside .xlsx inside Azure SQL using .net console application

I have this code which reads data from .xlsx and update SQL inside Azure :- using System; using System.Data; using Microsoft.Data.SqlClient; using System.IO; using ExcelDataReader; class Program { static void Main() { string excelFilePath =…

Azure SQL Database
asked 2025-03-18T00:16:39.8733333+00:00
john john Pter 905 Reputation points
commented 2025-03-19T01:48:40.9533333+00:00
Mallaiah Sangi 255 Reputation points Microsoft External Staff
1 answer

Power BI, Dataverse, Project Online help

My client uses Power BI to report on a portfolio of projects in Project Online. They would like to be able to view detailed reporting over time within Power BI. They have a ton of Power BI Pro licenses. We would need some place to store the historical…

Azure SQL Database
asked 2025-03-13T14:16:18.9533333+00:00
SusieMull 0 Reputation points
commented 2025-03-19T01:23:29.9566667+00:00
Mallaiah Sangi 255 Reputation points Microsoft External Staff
1 answer

Having intermittent issue with logging into Azure Managed instance using SSMS

Developers are having intermittent issues logging into SQL Managed instance in Azure. They are using SQL Server Management Studio. Diagnostics returned the following: We ran diagnostics between 2025-03-14 13:49 UTC and 2025-03-18 13:50 UTC and were…

Azure SQL Database
asked 2025-03-18T14:01:09.35+00:00
Hajkowski, Michael 0 Reputation points
answered 2025-03-19T00:51:15.8866667+00:00
Alberto Morillo 34,556 Reputation points MVP
3 answers

We are locked out of our azure admin account. How can we restore access?

A developer has locked us out of our Azure SQL DB. How can we restore access if we are the product owner?

Azure SQL Database
asked 2025-03-14T21:20:49.77+00:00
Angela Gillisse 0 Reputation points
answered 2025-03-19T00:44:47.75+00:00
Mallaiah Sangi 255 Reputation points Microsoft External Staff
3 answers

I'm experiencing problems with EF and SQL Server when running on Azure Webservice. The same code runs fine from VS with same db.

If I turn debugging on and connect my VS to the process, the error doesn't occur. Also I can run the code just fine from Visual Studio towards the same database. I do not Lazy Load. All Queries ens with ToFirstAsync() or ToListAsync() and has a Select to…

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
779 questions
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.
8,478 questions
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
638 questions
asked 2025-02-15T10:00:46.1533333+00:00
Tomas Ekenman 0 Reputation points
commented 2025-03-19T00:00:37.5333333+00:00
Siva Nair 810 Reputation points Microsoft External Staff
1 answer

SQL Managed Instance November 2022 Feature Wave - Azure Government

Does anyone have any idea when the November 2022 Feature Wave for SQL Managed Instance is going to come to Azure Government. Every time I ask support I get the typical "We do not have a date at this time". It is so old and rolled out its in the…

Azure SQL Database
asked 2025-03-13T12:35:32.0033333+00:00
Joe Alonge 0 Reputation points
commented 2025-03-18T23:48:27.61+00:00
david perez 0 Reputation points
1 answer

Unable to find content of functions (Sys.FunctionName)

Hi Team, Inside Stored Procedure of my Database, a function of a different Database is called using DBName.Sys.Functionname. Inside this function a no. of other functions are called using Sys.functionname. For few of these functions (inside…

Azure SQL Database
asked 2025-03-18T19:47:10.3833333+00:00
Salil Singh 40 Reputation points
commented 2025-03-18T22:57:50.1233333+00:00
Erland Sommarskog 119.7K Reputation points MVP
1 answer

Azure Sql Automatic tuning is not working

How to fix Azure Sql Automatic Tuning? on the Azure portal, the recommendations page never loads. and when I run: select * from sys.database_automatic_tuning_options I get the following error: GetRecommendedActions operation failed. Error occured at…

Azure SQL Database
asked 2025-03-03T13:52:23.0733333+00:00
Juan 5 Reputation points
commented 2025-03-18T14:38:01.7266667+00:00
Juan 5 Reputation points
1 answer

Azure resource sharing among multiple users

I have created few resources under Startup Subscription, however even after trying many times and many options, I am unable to add another user to see these resources and use them (e.g. DB Creation, App deployment etc.). Can you please suggest the steps…

Azure SQL Database
asked 2025-03-01T05:12:06.6566667+00:00
TrackSeal 0 Reputation points
edited the question 2025-03-18T13:59:25.7566667+00:00
Vijayalaxmi Kattimani 1,720 Reputation points Microsoft External Staff
2 answers

Is Azure SQL Database 2014-04-01 API retirement affecting Microsoft.EntityFrameworkCore.SqlServer 1.1.1?

We received an email saying Azure SQL Database 2014-04-01 APIs will be retired on 31 Oct 2025. We have programs using Microsoft.EntityFrameworkCore.SqlServer version 1.1.1 to access the Azure SQL database service. I would like to know whether we are…

Azure SQL Database
asked 2025-03-13T15:56:19.49+00:00
Edwin Chan 25 Reputation points
edited a comment 2025-03-18T12:12:24.97+00:00
Vijayalaxmi Kattimani 1,720 Reputation points Microsoft External Staff