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…
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 -…
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…
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?
Import job from a bacpac
I have a database Import job from a bacpac in azure blob storage that is stuck
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) …
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…
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?
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…
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…
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 =…
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…
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…
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?
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…
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…
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 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 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…
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…