Azure SQL Database
An Azure relational database service.
5,334 questions
2 answers
Unable to delete Azure SQL DB, logs display Internal Server Error
I recently created a MSSQL server, which I was trying to move to an elastic pool. In between I initiated the deletion of the database, I received the notification for successful deletion, however, the database is still present. I checked the Activity…
Azure SQL Database
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,055 questions
asked 2024-07-01T19:44:58.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(288, 87%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMJ%3C/text%3E%3C/svg%3E)
Mahesh Jaganiya
0
Reputation points
answered 2024-07-02T02:44:35.27+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,011
Reputation points Microsoft Employee
1 answer
Azure for Students Subscription - Unable to create Azure Database for MySQL Flexible Server
I have been attempting to create a Azure Database for MySQL Flexible Server for my assignment but I am unable to do so due to the below error. I have tried multiple regions but I am unable to get a successful deployment. "code":…
asked 2024-07-01T17:50:31.62+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, 6%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMZ%3C/text%3E%3C/svg%3E)
Miguel Zepeda
0
Reputation points
commented 2024-07-01T21:40:13.8266667+00:00
Oury Ba-MSFT
17,556
Reputation points Microsoft Employee
1 answer
Custom logs for SQL databases running on Azure VM
Hi , I would like to capture the databases health and some other basic SQL databases configuration related to health and send them to Log analytics agent . This is specific to SQL Databases running on Azure SQL VM . What would be right approach to push…
asked 2024-06-26T06:51:51.8433333+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(22.400000000000002, 94%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENV%3C/text%3E%3C/svg%3E)
Nikhil Verma
40
Reputation points
commented 2024-07-01T20:28:19.09+00:00
Oury Ba-MSFT
17,556
Reputation points Microsoft Employee
0 answers
Creating Certifcate Or Symmetric key Over Azure Managed Instance with Entra Service principal
Hi Team, We are connecting a database over Azure SQL Managed Instance from our C# application. We need to create Symmetric-Key/Asymmetric-Key/Certificate with TSQL statement.
asked 2024-06-28T14:13:48.8733333+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(307.2, 13%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDR%3C/text%3E%3C/svg%3E)
Deepak Rane (drane)
60
Reputation points
commented 2024-07-01T16:57:23.6733333+00:00
Oury Ba-MSFT
17,556
Reputation points Microsoft Employee
1 answer
How we can use Aggregate Functions on Encrypted Table Columns?
I have an Encrypted Table column (i.e., Deterministic ). Can we apply Aggregate Function on this column in Azure SQL Database.
asked 2024-06-27T09:47:50.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(163.2, 22%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKB%3C/text%3E%3C/svg%3E)
Khwaza Bandenawaz Sikkalagar
0
Reputation points
commented 2024-07-01T16:38:57.02+00:00
Oury Ba-MSFT
17,556
Reputation points Microsoft Employee
0 answers
System Database Backups for Azure SQL Managed Instance
I don't see the ability to backup system databases for Azure SQL Managed Instance. If the server was lost I would lose server logins, backup information. Is there any documentation regarding why we don't have to backup these databases, and the steps we…
asked 2024-06-21T20:35:16.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(83.2, 1%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECJ%3C/text%3E%3C/svg%3E)
Chancellor, Joe
0
Reputation points
commented 2024-07-01T16:24:51.8733333+00:00
Chancellor, Joe
0
Reputation points
0 answers
Get the full list of Defender sub assessments given an assessment?
We have multiple subscriptions with hundreds of different Azure resource types. I would like to work to remediate the assessments and sub assessments found on the sql server, Azure SQL and Azure SQL MI. The portal shows about 2K sub assessments on the…
asked 2024-07-01T00:07:01.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(86.4, 99%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENH%3C/text%3E%3C/svg%3E)
Nguyen, Hoa
331
Reputation points
commented 2024-07-01T13:20:35.8+00:00
Nguyen, Hoa
331
Reputation points
1 answer
Can we create elastic jobs from data base other than the host DB?
I have an elastic job agent setup on database X. I want to create jobs but from a different database. Right now I am getting SQL Error [2812] [S0062]: Could not find stored procedure 'jobs.sp_add_target_group'. Error position: Can someone help/ advice…
asked 2024-07-01T10:20:18.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(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
answered 2024-07-01T12:14:03.8733333+00:00
Amira Bedhiafi
18,341
Reputation points
2 answers
Unable to Restore SQL MI Database by SSMS
Hi team, I backed up an Azure Arc-enabled SQL Managed Instance database using SSMS to an Azure blob. However, when I try to restore it, I encounter the following error: "Restore of database 'restorebook' failed.…
asked 2024-06-24T11:11:59.4+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(96, 21%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
Demo
20
Reputation points
edited the question 2024-07-01T09:05:48.3133333+00:00
Erland Sommarskog
105K
Reputation points MVP
2 answers
Azure Data Factory - Azure SQL connectivity error : Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access
Hi I am trying to import data from onprem SQL server database to Azure SQL databases through Azure Data Factor(ADF) Copy activity , this worked for more than a year with no problems ,till few weeks back when I got the error below. I got a workaround it…
asked 2024-06-24T13:30:39.4533333+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(102.4, 25%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Mfundo Potolwana
0
Reputation points
answered 2024-07-01T08:49:18.93+00:00
Pinaki Ghatak
2,720
Reputation points Microsoft Employee
0 answers
I selected Storage Auto-growth option for my postgresql flexible server and then I restarted the server and since then the server is in 'restarting' state for 24 hours.
My Azure Postgresql Flexible Server has reached its storage limit, so I selected the Storage Auto-growth option. After 15 minutes nothing changed and I restarted the server. Since then, the server has been in 'restarting' state for 24 hours. Type of…
asked 2024-06-21T10:11:48.0633333+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(60.8, 60%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Cosmin Robert Lungu
0
Reputation points
commented 2024-07-01T06:06:53.23+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,201
Reputation points Microsoft Employee
1 answer
Issue Creating Azure MySQL Database
Hello, I am encountering an issue while trying to create an Azure MySQL database for my university assignment. I have created a new resource group named "students-rg" and attempted to set up an Azure Database for MySQL server. However, I…
asked 2024-06-30T04:39:24.6433333+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, 73%, 10%)' 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)
Sanjula De Alwis
0
Reputation points
edited an answer 2024-07-01T03:59:12.8166667+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(246.4, 4%, 33%)' 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)
Sina Salam
6,496
Reputation points
0 answers
Azure Data Factory executes stored procedure twice (and concurrently)
I have an ADF pipeline executing a stored procedure on an Azure SQL database. Retries is set to 0, so this procedure should be executed exactly once. Now it turns out that it sometimes executes twice, i.e. a second time when the first execution is…
asked 2024-06-26T14:40:32.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(316.8, 74%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Matthias Delafontaine
16
Reputation points
commented 2024-07-01T03:54:13.1433333+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, 48%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Harishga
5,420
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Renewal for My Microsoft Certified
Hi Microsoft, I have certification Azure Database Administrator Associate but at 26 may 2024 I need to renewal this certification. i forget to renewal and now i check my account, I didn't find it in my account. what should i do for renewal this…
asked 2024-06-28T02:25:19.8433333+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, 37%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFA%3C/text%3E%3C/svg%3E)
Farid Adam Abdillah
20
Reputation points
accepted 2024-06-30T16:04:49.1033333+00:00
Farid Adam Abdillah
20
Reputation points
0 answers
Azure Application Gateway Preview feature (TCP/TLS Proxy) and Azure SQL
Hello I was just wondering if anyone has attempted to use the preview feature for Azure Application Gateway to support layer 4 proxying. (https://learn.microsoft.com/en-us/azure/application-gateway/tcp-tls-proxy-overview) with an Azure SQL instance as…
asked 2024-06-07T18:42:08.03+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(92.8, 38%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
Jorge Rodriguez
0
Reputation points
commented 2024-06-28T21:26:27.0266667+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, 30%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
J.R_260
0
Reputation points
1 answer
Transcript Not Sowing Exam Passed May 9, 2024
When logged in here I can see Exam titleExam numberPassed dateAdministering Microsoft Azure SQL SolutionsDP-300May 9, 2024Administering Microsoft Azure SQL SolutionsDP-300May 9, 2024But the anonymous validation does not show it …
asked 2024-06-27T15:16:51.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(156.8, 86%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERW%3C/text%3E%3C/svg%3E)
REGAN WICK
0
Reputation points
answered 2024-06-28T18:09:41.3033333+00:00
GeethaThatipatri-MSFT
28,852
Reputation points Microsoft Employee
1 answer
Find all the path between two nodes of Azure SQL database
I wan to get columns from association table in SELECT caluse , Is there any other way around for this? SELECT subgraph, subgraph as name, Typecode,aid,nbr FROM ( SELECT i1.Typecode AS Typecode, i1.ID AS aid, i1.Number AS nbr, …
asked 2024-06-26T21:37:52.4866667+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(310.4, 9%, 40%)' 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)
priyanka
0
Reputation points
answered 2024-06-28T15:12:12.3233333+00:00
Oury Ba-MSFT
17,556
Reputation points Microsoft Employee
1 answer
Stored Proc outputs differ between SQL Server and Azure SQL DB
We have an om-prem data warehouse and are looking to migrate to Azure cloud. We've provisioned the Azure SQL serverless database and done a lift and shift on the stored procs. We are copying source data from SQL server database to Azure SQL and executing…
asked 2023-11-06T05:07:09.0933333+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(204.8, 4%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Riyaz Barkatali Budhwani
5
Reputation points
commented 2024-06-28T09:10:16.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(268.8, 42%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC9%3C/text%3E%3C/svg%3E)
CherylLee-9314
0
Reputation points
2 answers
Rollback plan for migration from on-prem SQL server 2016(2 node AG Cluster) to Azure SQL MI Business Critical
Hi, Actually migrating from on-prem SQL server 2016(2 node AG cluster) on Window 2019 Server to Azure SQL Managed Instance Business Critical node. Configured DMS replication and syncing the db, will do until the cutover. This process includes upload of…
asked 2024-06-26T07:05:47.3666667+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, 35%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Aakash CK(P)
0
Reputation points
answered 2024-06-28T08:06:18.3633333+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(134.4, 83%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENJ%3C/text%3E%3C/svg%3E)
Neuvi Jiang
465
Reputation points Microsoft Vendor
1 answer
Azure SQL VM Backup Automation Change
I have an Azure SQL VM and it is running automated backup of user databases every 5 minutes. I can't seem to identify where the automation is running from only see Managed Backup and it runs and saves to Azure storage account. No disaster recovery is…
asked 2024-06-27T19:42:19.0566667+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(80, 34%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Cherise D Woods
1
Reputation point
edited the question 2024-06-28T03:31:53.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(233.6, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
ManoharLakkoju
690
Reputation points Microsoft Vendor