Azure SQL Database
An Azure relational database service.
5,413 questions
1 answer
SqlPackage 15.0.4897.1, started failing with an error related to deployment plan generation
Why are my database update tasks failing with an error related to the 'SqlIndex' class and its 'Online' property when using SqlPackage version 15.0.4897.1, and how can I resolve this issue? PS - Based on common issues that we have seen from customers and…
asked 2024-07-19T17:34:13.52+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
answered 2024-07-19T17:36:59.13+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
1 answer
Query on Metrics, Blocked by Firewall, Deadlocks and Failed connection
We are having few queries on the below metrics . 1)Blocked by Firewall How to get the IP address and the request details which is blocked by the firewall 2)Deadlocks How to get the deadlocks details 3)Failed connections How to get the failed connection…
asked 2024-07-19T16:56:28.36+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
edited an answer 2024-07-19T17:02:18.09+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
1 answer
Why am I experiencing connectivity issues with my Azure SQL Database, including pre-login handshake errors and semaphore timeout period expired errors, and how can I resolve this?
Why am I experiencing connectivity issues with my Azure SQL Database, including pre-login handshake errors and semaphore timeout period expired errors, and how can I resolve this? PS - Based on common issues that we have seen from customers and other…
asked 2024-07-19T16:22:24.0666667+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
answered 2024-07-19T16:24:14.86+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
1 answer
How can I diagnose and resolve memory-related slowness issues in my Azure SQL Elastic Pool databases?
Our resources are experiencing memory-related problems, either within the Elastic pool or at the database level. I am aware that we have the Memory Percent Instance Metric available at both levels, as well as the 'sys.dm_os_out_of_memory_events'…
asked 2024-07-18T22:06:20.3566667+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
edited the question 2024-07-19T16:19:27.9833333+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
1 answer
Roles in SQL Database
Regarding the Roles in SQL Database. We want to grant a user a role that allows the following actions: 1.Access to all schemas within the database 2.Ability to create views on specific schemas 3.Ability to grant SELECT permissions on created views to…
asked 2024-07-18T16:11:35.95+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
edited the question 2024-07-19T16:18:18.92+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
1 answer
"We're sorry. The lab environment needed to complete the exercises in this unit is temporarily unavailable." for training "Optimize query performance in Azure SQL"
Hi Microsoft Q&A. I get this error message for all 3 exercises included in the training mentioned in the title: https://learn.microsoft.com/en-us/training/modules/explore-query-performance-optimization/8-exercise-identify-resolve-blocking-issues …
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,413 questions
Azure Training
Azure Training
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Training: Instruction to develop new skills.
1,294 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(163.2, 59%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY%3C/text%3E%3C/svg%3E)
2 answers
How to assign SPN access to a Azure SQL Database using T-SQL
I already have a SPN and I want to give it access to Azure SQL Database using T-SQL. How to do this.
asked 2024-07-16T16:19:26.9433333+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(275.2, 61%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Ayush Shrivastava
0
Reputation points
commented 2024-07-19T12:04:14.1766667+00:00
Ayush Shrivastava
0
Reputation points
0 answers
Customer Best Practices Assessment: exclude checks/false positives
Is there any way to customize the BPA in Azure ARC for SQL to exclude certain checks or to flag issues as false positives? I've got certain issues being flagged by the BPA however these can't be resolved as the application accessing the database requires…
asked 2024-07-19T09:42:13.16+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(243.2, 0%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBB%3C/text%3E%3C/svg%3E)
Berend Broekhoff
0
Reputation points Microsoft Employee
commented 2024-07-19T11:24:16.1466667+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(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
14,381
Reputation points Microsoft Employee
2 answers
Facing issues to connect with synapse workspace/azure sql db via oauth
I want to connect to and access my Synapse Workspace and SQL Pool using OAuth. For this purpose, I have created an app in Azure and assigned the following API permissions: Microsoft Graph: Directory.Read.All (Delegated) Directory.ReadWrite.All…
asked 2024-07-15T05:04:01.89+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, 23%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
SUBHAM KUMAR
0
Reputation points
commented 2024-07-19T09:26:18.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(288, 61%, 37%)' 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)
phemanth
8,645
Reputation points Microsoft Vendor
3 answers
Unable to access Azure SQL database from Azure Load Test using managed identity
Hi, I am trying to do load testing on my Azure SQL database using Azure Load Tests. I have setup user assigned managed identity on Azure Load Test and given it Reader and DB SQL Contributor role on SQL server. I am using the following connection…
asked 2024-07-16T05:17:40.3033333+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, 28.000000000000004%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Amrata Dhankhar
0
Reputation points Microsoft Employee
answered 2024-07-19T09:13:58.4133333+00:00
Amrata Dhankhar
0
Reputation points Microsoft Employee
1 answer
Unable to send message from Azure SQL to Service Bus
The goal is to send messages to Service Bus from Azure SQL Server. I have added the Managed Identity to the queue with the Azure Service Bus Data Owner permission. When I run the code to set up the credential, there is no error. OPEN MASTER KEY…
asked 2024-07-03T18:31:40.7866667+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, 97%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Spencer Thompson (Network)
0
Reputation points
answered 2024-07-19T08:49:36.04+00:00
Spencer Thompson (Network)
0
Reputation points
1 answer
Azure SQL Public IPs
I am trying to find if there is a maximum number of Public IPs I can add to the firewall rules to allow access in Azure SQL?
asked 2024-07-19T01:47:34.42+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(163.2, 23%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJF%3C/text%3E%3C/svg%3E)
Jeff Fazio
31
Reputation points
edited the question 2024-07-19T08:16:31.9266667+00:00
Erland Sommarskog
106.5K
Reputation points
3 answers
SQL Statement taking long to execute
I have two SQL Databases that is on the same SQL server but on one database it only takes 4 seconds to complete the SQL statement but on the other SQL database it takes 25 minutes to complete. Both databases uses the same SQL elastic pool and I don't see…
asked 2024-07-15T03:15:50.06+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(259.20000000000005, 75%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWS%3C/text%3E%3C/svg%3E)
WingHong Shiu
5
Reputation points
commented 2024-07-19T08:13:40.23+00:00
Erland Sommarskog
106.5K
Reputation points
1 answer
Built in SQL server in synapse is unavailable
Hi, Even after changing the firewall settings, the built in SQL server status is unavailable. Someone please assist. Step-by-step solution would be really helpful. Thanks in advance.
asked 2024-07-13T05:40:54.8066667+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(220.8, 17%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
shailaja Azure
0
Reputation points
commented 2024-07-19T05:21:00.5166667+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, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
12,615
Reputation points Microsoft Vendor
2 answers
Copy Database - Performance
Hello, We need to create a new copy of a database on a different server using the PowerShell command "New-AzSqlDatabaseCopy". Will running this command impact the performance of the live database, especially if other jobs or queries are…
asked 2024-07-17T06:49:52.86+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, 39%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Rohit
226
Reputation points
commented 2024-07-19T05:12:42.2366667+00:00
ShaktiSingh-MSFT
14,381
Reputation points Microsoft Employee
2 answers
How to Keep the backup for long term
I am facing an issue related to pricing and billing information. and want to remove the resource group (RG) but need to keep the backup of the database (DB) for a long time. Seeking advice on the best cost performance for this. PS - Based on common…
asked 2024-07-18T13:48:05.1466667+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, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Rahul Randive
9,176
Reputation points Microsoft Employee
answered 2024-07-19T04:15:40.5033333+00:00
Nandan Hegde
31,346
Reputation points MVP
1 answer
Is CREATE/DROP INDEX Automatic tuning on the Roadmap for SQL managed instances?
Hello, Azure SQL DB's automatic tuning feature is incredibly helpful for us. Is there any plan to bring these features to SQL managed instances in the future? Thank you, Greg
asked 2024-07-18T21:35:35.0366667+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, 45%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
adm.Greg Gardner
0
Reputation points
edited an answer 2024-07-19T03:19:13.3866667+00:00
Alberto Morillo
33,421
Reputation points MVP
2 answers
Can we run a stored procedure in Azure SQL Database asynchronously.
I want to run my stored procedure async using T-SQL. Can we do it ?
asked 2024-07-15T12:20:11.3033333+00:00
Ayush Shrivastava
0
Reputation points
commented 2024-07-18T22:46:31.2533333+00:00
Oury Ba-MSFT
17,791
Reputation points Microsoft Employee
1 answer
Has anyone Migrated BMC footprints Server and Database to Azure and Azure SQL Managed Instance?
I am trying to Migrate the BMC Footprints Application Server to Azure VM and the Database to Azure SQL Managed instance. I am having problems with the Database when restoring it from a backup of our on-premise SQL instance. We have issues with Java…
asked 2024-07-18T15:31:39.3766667+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, 71%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAL%3C/text%3E%3C/svg%3E)
Anaya, Luis - Admin
0
Reputation points
commented 2024-07-18T22:15:50.4166667+00:00
Oury Ba-MSFT
17,791
Reputation points Microsoft Employee
1 answer
I am not able to set an admin for Microsoft Entra ID when creating an SQL server
I am not able to set an admin for Microsoft Entra ID when creating an SQL server When creating a new server, I want it to support only Microsoft Entra ID Authentication. For authentication method, I leave the default selection selected 'Use only…
asked 2024-07-18T18:24:06.5166667+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
answered 2024-07-18T18:24:38.98+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee