Azure SQL Database
An Azure relational database service.
6,281 questions
1 answer
One of the answers was accepted by the question author.
Do I need to assign RBAC Role to System Identity of Azure SQL server in order to send audit logs to Log Analytics Workspace in another subscription?
Do I need to assign RBAC Role to System Identity of Azure SQL server in order to send audit logs to Log Analytics Workspace in another subscription? I have the SQL server in Subscription-A and the Central LAW is in Subscription B. Does this require an…
Azure SQL Database
asked 2025-06-03T09:14:18.7033333+00:00
Rajesh Swarnkar
891
Reputation points
accepted 2025-06-05T05:16:02.69+00:00
Rajesh Swarnkar
891
Reputation points
0 answers
Get Azure SQL database instance specs
I would like to get detailed information about instance types used by Azure SQL like (HS_PRMS_14, HS_DC_14 and so on), the instance specs that I found are vcores, memory and cpu architecture and manufacturer, but with cpu architecture and manufacturer…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,281 questions
asked 2025-05-30T13:12:39.1333333+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(268.8, 87%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
Almos Fabian
0
Reputation points
commented 2025-06-05T04:42:21.2966667+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
4,370
Reputation points Microsoft External Staff
Moderator
0 answers
Azure Database unable to update Datasync config & Datastudio timeout
We seem to be having 2x issues with an Azure SQL database. Datasync keeps failing sync data & reconfiguring of tables to sync. The database is timing out populating the tree of table in both SQL Management Studio & Azure Data Studio. The…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,281 questions
![](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(144, 54%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
1 answer
Why are the daily costs for my Sql database increasing with little activity?
I have a database that is less than 4G and has very little activity. The activity is from myself and 1 or 2 other users for sporadic intervals that rarely last more then a few minutes. Activity is thru a small Azure app service web application and…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,281 questions
asked 2025-06-04T13:46:39.2766667+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, 62%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jeff Harris
0
Reputation points
commented 2025-06-05T00:40:57.2933333+00:00
Jeff Harris
0
Reputation points
0 answers
Azure vNet suport subnet injection doesn't work.
I followed the documentation to complete the config but the network connectivity seem not working. https://learn.microsoft.com/en-us/power-platform/admin/vnet-support-setup-configure I try to connect to the SQL managed instance from the Power app, the…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,281 questions
asked 2025-05-26T02:12:27.6266667+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, 51%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZY%3C/text%3E%3C/svg%3E)
Zhaofeng Yu
0
Reputation points
commented 2025-06-04T23:52:01.6566667+00:00
Oury Ba-MSFT
20,901
Reputation points Microsoft Employee
Moderator
0 answers
Automatic tuning is not creating indexes on our SQL database
We have automatic tuning turned on with Create Index ON, but it no longer creates indexes like it used to.
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,281 questions
asked 2025-06-04T21:06:09.1066667+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(176, 28.999999999999996%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKH%3C/text%3E%3C/svg%3E)
Kevin Hannan
6
Reputation points
commented 2025-06-04T22:46:18.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(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
4,310
Reputation points Microsoft External Staff
Moderator
1 answer
Data factory fails to run Stored Procedure when SSMS succeeds
I have a nightly job that generates an email via a stored procedure run through azure data factory. It has been in use for about 2 years with no problem. Yesterday it failed without any changes to the SQL A database operation failed with the following…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,281 questions
asked 2025-06-04T21:24:52.7533333+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(272, 17%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELB%3C/text%3E%3C/svg%3E)
Lun, Biondi
0
Reputation points
answered 2025-06-04T22:05:37.1633333+00:00
Erland Sommarskog
120.9K
Reputation points MVP
Volunteer Moderator
1 answer
Getting an Access Denied error when accessing a file in Azure Blob Storage
Files have been loaded into a blob container, and through PowerShell, that data has been loaded into the Azure SQL database successfully for over 2 years. As of last week, this process was functioning correctly. Currently encountering an Access Denied…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,281 questions
asked 2025-05-30T17:00:14.79+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(284.8, 95%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EID%3C/text%3E%3C/svg%3E)
IAA Dashboard
0
Reputation points
commented 2025-06-04T18:21:41.1133333+00:00
Mahesh Kurva
4,310
Reputation points Microsoft External Staff
Moderator
0 answers
Deployment script in West US 2 region failing to authenticate to Azure SQL with error "Login failed for user '<token-identified principal>"
As a part of our CI pipeline, we are running a deployment script in the WestUS2 region (the same region where the Azure SQL server is located) and are getting the error "Login failed for user '<token-identified principal>" when we try to…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,281 questions
asked 2025-05-28T22:05:25.59+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(67.2, 83%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Max Ackley
10
Reputation points
commented 2025-06-04T18:11:16.48+00:00
Mahesh Kurva
4,310
Reputation points Microsoft External Staff
Moderator
2 answers
How can I completely remove 'xyzh' Azure SQL managed Instance database from SSMS?
The xyzh database in Azure SQL Managed Instance has already been dropped, but it still appears in the list under SQL Server Management Studio (SSMS) Object Explorer. When attempting to drop it again using the command 'DROP DATABASE [ xyzh] GO', an error…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,281 questions
asked 2025-06-02T13:43:17.2866667+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(192, 65%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYA%3C/text%3E%3C/svg%3E)
yirgalem asore
0
Reputation points
answered 2025-06-04T17:19:17.5333333+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
1,435
Reputation points Microsoft External Staff
Moderator
3 answers
Can't connect to SQLServer virtual machine
Can't connect to Azure SQL Server from SQL SSMS TITLE: Connect to Server Cannot connect to 20.51.194.18:1433. ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,281 questions
asked 2025-06-02T17:34:15.3066667+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, 91%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
OnePage
20
Reputation points
edited a comment 2025-06-04T15:51:56.3266667+00:00
Saraswathi Devadula
4,370
Reputation points Microsoft External Staff
Moderator
1 answer
One of the answers was accepted by the question author.
Error trying to create SQL Managed Instance in West US, but works in other regions using same subscription/
When trying to create a SQL Managed Instance in a region I get error "Managed Instance is not available for the chosen subscription and region. Please try again with some other subscription, region", but selecting a different region the error…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,281 questions
asked 2025-05-28T19:25:58.4933333+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(208, 74%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Marrell Sanders
20
Reputation points
accepted 2025-06-04T12:27:58.65+00:00
Marrell Sanders
20
Reputation points
0 answers
Recon and Retry
We are working on a large-scale enterprise migration project where we are ingesting data from an on-premises DB2 Snapshot (point-in-time extract) into Azure SQL Hyperscale using Azure-native components. The architecture includes: Source: IBM DB2…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,281 questions
asked 2025-05-28T14:12:03.19+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(268.8, 56.00000000000001%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Janice Chi
40
Reputation points
edited the question 2025-06-04T08:42:16.84+00:00
PratikLad
1,435
Reputation points Microsoft External Staff
Moderator
3 answers
How to get more details(user, execution time, IP address) for a given query ID on Azure SQL DB
How can I get all the details(user, execution time, IP address, etc) for a given Query ID? I am using Azure SQL DB
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,281 questions
asked 2025-01-21T16:35:40.94+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(70.4, 54%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM3%3C/text%3E%3C/svg%3E)
MikeZheng-3371
46
Reputation points
commented 2025-06-04T08:32:30.27+00:00
PratikLad
1,435
Reputation points Microsoft External Staff
Moderator
3 answers
create hive metastore in Databricks with non-SQL DB
Hi Expert, How to create Hive Metastore in Azure databricks DB
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,281 questions
Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,556 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,458 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,550 questions
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,390 questions
asked 2023-07-17T13:56:46.3466667+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(140.8, 75%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Shambhu Rai
1,411
Reputation points
answered 2025-06-04T06:21:20.8966667+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, 44%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Dennis Schulist
0
Reputation points
0 answers
Cant get the Database Watcher to start collecting data from the Azure SQL DB
We carefully configured a database watcher as per documentation. everything is setup (Key Vault with proper permissions, executed script to create login and grant permissions (script copy-pasted), created secrets in the vault). But we don't get any data…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,281 questions
asked 2025-06-03T20:03:31.79+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(236.8, 19%, 32%)' 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)
Jurica Smirčić
0
Reputation points
commented 2025-06-04T06:05:34.6166667+00:00
Jurica Smirčić
0
Reputation points
2 answers
Deployment of a simple bicep takes too long
I have a bunch of biceps that deploy various parts of Azure infrastructure. All of them complete within reasonable timeframes except this guy. It runs forever, though, in fact, approves the private managed connection as supposed. Any thoughts? param…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,281 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,550 questions
asked 2024-02-08T01:54:19.4+00:00
Dronec
181
Reputation points
commented 2025-06-03T21:33:34.9266667+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(108.80000000000001, 0%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jacob Bass
0
Reputation points
1 answer
Does Azure SQL Hyperscale SKU supports Spatial data or GEOM columns
Hello Team, My application has 20TB+ data. At present we are using IAAS SQL to host our application data The features in AZSQL hyperscale SKU look promising to my day to day problems. I created a AZSQL Hyperscale DB but looks like issue while moving…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,281 questions
asked 2025-06-02T16:13:35.05+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(179.20000000000002, 68%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3END%3C/text%3E%3C/svg%3E)
NATH, DEEPAK
0
Reputation points
commented 2025-06-03T19:03:35.78+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(51.2, 35%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Shraddha Pore
105
Reputation points Microsoft External Staff
Moderator
2 answers
Taking long time to copy tiny database from one instance to another instance
I am copying a tiny database from azure SQL managed instance to another azure SQL managed instance using Azure portal. It is taking a long time , it is almost an hour, it still showing "coping in progress" It does not look like that it is…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,281 questions
asked 2025-05-20T18:20:50.45+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(272, 98%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Singh, Gurmel
0
Reputation points
commented 2025-06-03T16:40:20.9466667+00:00
PratikLad
1,435
Reputation points Microsoft External Staff
Moderator
1 answer
Why do index scans slow down as table size increases (constant result set)?
We tested SELECT queries on four Azure SQL tables with different row counts (100K to 4.2M), but each query always returned ~100K rows (±5K). We ran the queries under three configurations: Enforce index usage. (Via adding WITH (INDEX(NAME_OF_INDEX))) …
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,281 questions
asked 2025-05-29T11:42:05.1766667+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(265.6, 66%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Abhishek Mali
0
Reputation points
edited a comment 2025-06-03T06:38:43.72+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(140.8, 78%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Abhishek Mali
0
Reputation points