Azure SQL Database
An Azure relational database service.
5,348 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,059 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
commented 2024-07-03T10:02:18.7933333+00:00
Erland Sommarskog
105.8K
Reputation points MVP
7 answers
One of the answers was accepted by the question author.
Microsoft SQL Server Studio - Dark Mode
Is there any official method to use Microsoft SQL Server Management Studio Studio with Dark Mode?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,348 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,830 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,217 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,592 questions
asked 2023-12-19T13:11:52.4966667+00:00
Kıvanç ÖZDEMİR
125
Reputation points
commented 2024-07-03T04:42:42.13+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(41.6, 90%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Harsh Sugandhi
0
Reputation points
1 answer
One of the answers was accepted by the question author.
How do I give a user access to a single App Server, SQL Database, & Azure Storage
Hi; I want to have my QA team do some load testing of the dev slot of our web app. I want to give them full administrative access to the dev slot app service and its associated SQL Database and BLOB Storage. I do not want them to have any administrative…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,348 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,579 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,294 questions
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
236 questions
asked 2024-05-31T22:32:34.61+00:00
David Thielen
2,526
Reputation points
edited the question 2024-07-03T04:21:15.9266667+00:00
Ryan Hill
26,866
Reputation points Microsoft Employee
1 answer
Azure Management Instance Business Critical
Hi people, I have two questions about SQL Management Instance Business Critical. 1 - When I activate Zone Redundancy, I can't select which redundancy zone I want one of the nodes to be in? 2 - When I have zone redundancy in a failover with Business…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,348 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,217 questions
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
236 questions
asked 2024-05-08T19:12:41.2266667+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, 99%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EES%3C/text%3E%3C/svg%3E)
Emerson Sousa
0
Reputation points
edited the question 2024-07-03T04:18:26.9666667+00:00
Ryan Hill
26,866
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Can Azure SQL Database be set to auto scale up?
Hi all; Once I take my system live, I have the SQL Database set to Standard, 10 DTUs, 2GB. Is there a way I can have it scale up/down as needed depending on demand? My application at first should be hitting the database with 0 - 100 queries/minute. With…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,348 questions
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
236 questions
asked 2024-04-01T11:33:50.74+00:00
David Thielen
2,526
Reputation points
edited the question 2024-07-03T04:14:56.14+00:00
Ryan Hill
26,866
Reputation points Microsoft Employee
1 answer
how to fix an issue where records are not syncing from Dataverse to Azure Database intermittently?
Successfully generated a summary I am experiencing an issue where records are not syncing from Dataverse to Azure Database intermittently, specifically for the Payment (evx_payment) entity. The affected records only sync when the customer manually…
asked 2024-07-02T21:16:35.34+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, 49%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Gustavo Mercado (LTIMINDTREE LIMITED)
20
Reputation points Microsoft Vendor
answered 2024-07-02T23:33:25.1+00:00
Gustavo Mercado (LTIMINDTREE LIMITED)
20
Reputation points Microsoft Vendor
2 answers
How do I back up a SQL database to Azure from Microsoft SQL Server Management Studio
I don't have access to the Azure portal to do it from that instance. I need to migrate the database to another server
asked 2024-06-19T21:08:18.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(275.2, 82%, 36%)' 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)
Sergio Sanchez
0
Reputation points
commented 2024-07-02T19:50:43.9666667+00:00
Oury Ba-MSFT
17,631
Reputation points Microsoft Employee
1 answer
Azure SQL Database Delete issue
Hi Azure Support Team, I am encountering an issue where a SQL database that I deleted reappeared and caused unexpected high costs on our Azure account. Background: On June 11, my boss asked me to review our Azure bill and remove any unnecessary…
asked 2024-07-02T06:04:57.22+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(182.40000000000003, 6%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMY%3C/text%3E%3C/svg%3E)
Mert Yacan
0
Reputation points
commented 2024-07-02T19:44:29.9566667+00:00
Oury Ba-MSFT
17,631
Reputation points Microsoft Employee
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
commented 2024-07-02T18:42:46.66+00:00
Amira Bedhiafi
18,741
Reputation points
1 answer
One of the answers was accepted by the question author.
any posiblility to restore sql backup from more than 7 days?
I didn't set up backup and now I want to restore the database that is more than 2 weeks old. Do I have any chance to recover that database or did I lose the changes permanently?
asked 2024-07-02T08:11:50.0533333+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, 21%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
ACConsultor
20
Reputation points
accepted 2024-07-02T09:07:53.93+00:00
ACConsultor
20
Reputation points
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
commented 2024-07-02T07:48:20.9233333+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,281
Reputation points Microsoft Employee
2 answers
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
answered 2024-07-01T21:40:13.8266667+00:00
Oury Ba-MSFT
17,631
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,631
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,631
Reputation points Microsoft Employee
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
105.8K
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,795
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
ShaktiSingh-MSFT
14,281
Reputation points Microsoft Employee
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,590
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
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
29,007
Reputation points Microsoft Employee