Azure SQL Database
An Azure relational database service.
6,084 questions
2 answers
Azure sql database check current active running session and query
I would like to have a query to check in Azure sql database, where I can see the current running active query from which spid , user ,host,ip program . Any one has the idea ?
asked 2021-04-09T10:18:23.723+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
sakuraime
2,336
Reputation points
commented 2025-03-14T03:46:09.5633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 16%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jaideep Singh
0
Reputation points
1 answer
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…
asked 2025-03-13T15:56:19.49+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 99%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEC%3C/text%3E%3C/svg%3E)
Edwin Chan
25
Reputation points
answered 2025-03-13T23:20:36.2033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 4%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Prasad Chaganti
80
Reputation points Microsoft External Staff
1 answer
One of the answers was accepted by the question author.
SQL Azure Firewall setting
Hi, We received a brute force attack notification for our SQL Azure server. Upon investigation, we noticed that the attacker was using .Net SqlClient and returning error 18456. If I check error 18456, it refers to failed authentication... but strange…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 28.999999999999996%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
0 answers
our web based application on SQL database will notopen
I need to connect with someone to help me troubleshoot my our web based application hosted on Azure is notworking
asked 2025-03-13T14:17:01.5033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 82%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E8%3C/text%3E%3C/svg%3E)
82959036
0
Reputation points
edited the question 2025-03-13T22:53:39.2733333+00:00
Erland Sommarskog
119.4K
Reputation points MVP
3 answers
Azure SQL - can't drop system versioned tables
Hello. I'm can't drop system versioned tables in master db in Azure SQL I have a docs - https://learn.microsoft.com/en-us/sql/relational-databases/tables/stopping-system-versioning-on-a-system-versioned-temporal-table?view=azuresqldb-current but…
asked 2025-02-26T09:06:45.93+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 26%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVB%3C/text%3E%3C/svg%3E)
Vitalii Bohachov
0
Reputation points
commented 2025-03-13T22:47:39.1166667+00:00
Erland Sommarskog
119.4K
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Wanted to replicate Azure SQL hosted in UK West to US North central does it need any networking
i have a requirement to sync Azure sql managed db instance data between 2 Regions US and UK replication type Transactional, both the 2 database instances are PEP Enabled with its own VNET. The data replication does it need any network setup between 2…
asked 2025-03-11T19:28:37.51+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 8%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
Narendra Chimakurthi
20
Reputation points
accepted 2025-03-13T21:38:30.9933333+00:00
Narendra Chimakurthi
20
Reputation points
1 answer
Request for Waiver of Unintended Azure Charges & Support Ticket Issue
I recently created an Azure subscription to explore its services. I mistakenly provisioned a high-end SQL Server instance, leading to unexpected charges of over $800, even though I was not actively using the service. Additionally, I attempted to create a…
asked 2025-03-10T19:55:34.8566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 92%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
shujaat siddiqui
0
Reputation points
commented 2025-03-13T19:55:33.0066667+00:00
TP
109.4K
Reputation points
1 answer
Could not connect azure sql db from ssms
Couldnt connect live SQL db TITLE: Connect to Server Cannot connect to dbowemp.database.windows.net. ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found…
asked 2025-03-11T14:32:19.9666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 89%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sabita Sahoo
0
Reputation points
commented 2025-03-13T16:47:53.8366667+00:00
Prasad Chaganti
80
Reputation points Microsoft External Staff
0 answers
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…
asked 2025-03-13T12:35:32.0033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 11%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
Joe Alonge
0
Reputation points
commented 2025-03-13T16:37:31.28+00:00
Oury Ba-MSFT
20,446
Reputation points Microsoft Employee
0 answers
database "master" on Azure SQL server not available
Database 'master' on 'nsmazucaedb02.database.windows.net' not available. Session tracing ID of '{52C18183-CDB2-4756-A86C-466A96F6E3D6}'. (Error: 40613)
asked 2025-03-13T13:20:04.0833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 28.999999999999996%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
NSM Admin
0
Reputation points
commented 2025-03-13T14:37:17.1+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijayalaxmi Kattimani
1,720
Reputation points Microsoft External Staff
0 answers
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 48%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 41%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
0 answers
Azure Support expected db relication issue resolution time
Hello, I have a replication issue with Azure Postgres Flexible db. Resource health event has a status that someone is working on this issue. How can I get a time frame for resolving the issue? The issue started on Mar 6 and still ongoing (6 days in a…
asked 2025-03-11T14:12:28.0833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 88%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Andrii Kuzminskyi
0
Reputation points
commented 2025-03-13T08:41:34.6133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 60%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
PratikLad
240
Reputation points Microsoft External Staff
1 answer
while deploying dacpac using dacservice, facing System.IO.IOException: The directory name is invalid
While deploying DacServices, facing below error Note: after restarting machine its working fine. Issue occurred intermediate System.IO.IOException: The directory name is invalid. at System.IO.__Error.WinIOError(Int32 errorCode, String…
asked 2025-03-12T08:53:37.9133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 42%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Aleem, Rabiul
0
Reputation points
edited the question 2025-03-13T02:55:59.9833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 85%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJX%3C/text%3E%3C/svg%3E)
Jiale Xue - MSFT
49,126
Reputation points Microsoft External Staff
1 answer
How to shrink 10 TB database in Azure Managed Instance
How to shrink 10 TB database in Azure Managed Instance. is it possible?
asked 2025-03-06T05:26:58.82+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 46%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijay Kumar
2,036
Reputation points
commented 2025-03-12T21:48:43.8033333+00:00
Erland Sommarskog
119.4K
Reputation points MVP
2 answers
How to load data from azure file share to SQL managed instance?
How to load files (image, Microsoft document, pdf, etc.) in azure file share to SQL managed instance?
asked 2025-03-07T03:27:15.7833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 48%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Junhui Ma
0
Reputation points
commented 2025-03-12T18:32:37.1633333+00:00
Prasad Chaganti
80
Reputation points Microsoft External Staff
0 answers
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…
asked 2025-03-11T06:04:10.1366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 80%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Mark Lagace
0
Reputation points
commented 2025-03-12T17:16:20.4733333+00:00
Mark Lagace
0
Reputation points
1 answer
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?
asked 2025-03-06T14:48:15.5966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 10%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Shane Schlabach
0
Reputation points
answered 2025-03-12T16:15:50.1866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 95%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Saraswathi Devadula
160
Reputation points Microsoft External Staff
1 answer
Log TLS version being used for connections to Azure SQL Databsae
With Azure deprecating TLS 1.0/1.2 for SQL Database, how can I log what version clients are currently using to connect?
asked 2025-03-06T14:47:02.5466667+00:00
Shane Schlabach
0
Reputation points
answered 2025-03-12T16:03:41.7133333+00:00
Saraswathi Devadula
160
Reputation points Microsoft External Staff
1 answer
can not send email from azure manged instance database mail
set up database email profile and account in the azure manged instnace, however, when i send email, it never send. i have same settin gin premier sql server without issue. our azure manged instance is using private node. smpt auto relay email
asked 2025-02-26T00:04:20.0033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 85%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDZ%3C/text%3E%3C/svg%3E)
David Zhou
0
Reputation points
commented 2025-03-12T14:29:50.4733333+00:00
Vijayalaxmi Kattimani
1,720
Reputation points Microsoft External Staff