Azure SQL Database
An Azure relational database service.
5,703 questions
2 answers
One of the answers was accepted by the question author.
How to increase quota
HI, I have azure SQL data base, I need to increase the quota, can anyone please assist me the process??
asked 2024-10-18T18:57:32.14+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(294.40000000000003, 39%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELP%3C/text%3E%3C/svg%3E)
Learning Psycho
20
Reputation points
accepted 2024-10-19T00:08:10.4666667+00:00
Learning Psycho
20
Reputation points
0 answers
SQL Database is very very very slow
Hello I have got SQL database on Azure. I have got classic web page connect with Azure database. But the data transfer is very slow. I have got local hosting provider with SQL database and it is very fast than Azure. So our local hosting provider is very…
asked 2024-10-17T19:01:11.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(153.6, 99%, 24%)' 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)
Eskioglu, Salih
20
Reputation points
commented 2024-10-18T21:41:24.25+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, 69%, 29%)' 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)
Sai Raghunadh M
645
Reputation points Microsoft Vendor
1 answer
Unable to create elastic job agent : The client 'xxxxxx8a1a67d5483' with object id 'xxx7d5483' does not have authorization to perform action 'Microsoft.Sql/servers/jobAgents/write'
com.azure.core.management.exception.ManagementException: Status code 403, "{"error":{"code":"AuthorizationFailed","message":"The client 'xxxxxx8a1a67d5483' with object id 'xxx7d5483' does not have…
asked 2024-10-16T12:41:40.74+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
120
Reputation points
commented 2024-10-18T14:04:31.88+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(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
2,790
Reputation points Microsoft Vendor
0 answers
VA2107 - Remove members who should not have access to the database role
ALTER ROLE [UserRole] DROP MEMBER [Principal], is this the correct remediation script for VA2107
asked 2024-10-17T06:20:38.8533333+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(44.800000000000004, 7.000000000000001%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Biswas, Sauvik
0
Reputation points
commented 2024-10-18T14:03:16.1366667+00:00
NIKHILA NETHIKUNTA
2,790
Reputation points Microsoft Vendor
1 answer
Database migration from Single server instance to Flexible server instance
Our application Database has been migrated from single server instance to Flexible server instance. It is stating in the Azure portal that the migration was successful. But we are unable to find our Database under our subscription.
asked 2024-10-15T08:17:52.2166667+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(240, 0%, 33%)' 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)
rv385
0
Reputation points
answered 2024-10-18T12:43:22.6533333+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
245
Reputation points Microsoft Vendor
1 answer
How to restrict non-ssl connection in Azure AD SQL managed instance
Hi, I trying to connect Azure AD SQL managed instance with java. URL for non encrypted…
asked 2024-10-17T05:33:42.8866667+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, 47%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJV%3C/text%3E%3C/svg%3E)
Jeevitha Vasu
0
Reputation points
commented 2024-10-18T10:59:05.11+00:00
Mahesh Kurva
245
Reputation points Microsoft Vendor
1 answer
Azure Arc SQL Server Resource still showing up
I installed SQL 2022 developer and enabled the Azure extensions option and selected the appropriate resource group for development in my azure subscription. Well I noticed it created a bunch of artifacts in the resource group. Well I followed the steps…
asked 2024-10-15T23:27:15.3566667+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, 87%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
Daniel Woodhouse
0
Reputation points
commented 2024-10-18T04:38:38.5066667+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
15,321
Reputation points
2 answers
What is the best way to migrate SQL database to another SQL server in Azure. Minimal downtime.
Hi! I am fairly new to Azure, but have good onprem experience. Asked to migrate two databases (both used by an app) to another subscription/rg/location. Databases are hosted on Azure SQL Logical Serve, that is also the target. Standard tier. So the…
asked 2024-10-12T09:25:12.3266667+00:00
|_SQLViking_|
26
Reputation points
commented 2024-10-18T02:29:14.0733333+00:00
LucyChenMSFT-4874
4,815
Reputation points
2 answers
Upgrade Azure SQL Managed Instance to November 2022 Feature Wave
How can an Azure SQL Managed Instance (GP Premium Series) be upgraded to the November 2022 Feature Wave? The current version is [Jul 2 2024 15:39:01] via SELECT @@VERSION. The goal is to utilize the Next-gen General Purpose tier for increased database…
asked 2024-10-14T19:52:46.8+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, 52%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIK%3C/text%3E%3C/svg%3E)
Ian Keogh
5
Reputation points
commented 2024-10-17T19:06:03.37+00:00
Sai Raghunadh M
645
Reputation points Microsoft Vendor
1 answer
How to achieve appending records to CETAS External tables in Sql Server MI?
Hello ! Basing explanation on https://techcommunity.microsoft.com/t5/azure-sql-blog/export-capability-cetas-for-data-virtualization-in-azure-sql/bc-p/4270848#M1972 : Data Virtualisation/Archival of Sql Server through Create External Table As Select…
asked 2024-10-15T10:27:09.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(310.4, 59%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELR%3C/text%3E%3C/svg%3E)
Lonely Rogue
30
Reputation points
commented 2024-10-17T18:12:58.8+00:00
Sai Raghunadh M
645
Reputation points Microsoft Vendor
1 answer
Cross subscription Azure SQL VM database restore using Azure CLI
Hi , Anyone tried restoring sql database running on Azure SQL VM and backed up via Azure Backup . Via recovery vault , we are able to perform the cross subscription restore but not using the Azure CLI . All desired permissions in place as documented by…
asked 2024-10-14T08:16:53.7466667+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-10-17T18:07:19.21+00:00
Mahesh Kurva
245
Reputation points Microsoft Vendor
1 answer
Unable to create zone redundant Azure SQL Server and App Service Plan in any region
Hello! Pretty much the title. I'm unable to create a zone redundant Azure SQL Server and App Service Plan in any region. Here's the output of a script I wrote to test this. Any help or advice would be appreciated. QMS Update - Status: ResourceType:…
asked 2024-10-14T20:32:25.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(80, 17%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
gabe
0
Reputation points
commented 2024-10-17T17:37:07.22+00:00
Sai Raghunadh M
645
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Merge two tables from diff env
Hi, I have to merge data from UAT environment into Prod env azure sql server. For eg, I have a table called TGT.Employees in both prod and UAT. I need to merge these two tables and store the final version of data into prod server. What are the different…
asked 2024-10-15T14:12:20.3+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(19.2, 54%, 11%)' 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)
Santhi Dhanuskodi
305
Reputation points
accepted 2024-10-17T16:32:00.3533333+00:00
Santhi Dhanuskodi
305
Reputation points
2 answers
Azure SQL database restore to Synapse
we need to do restore sql server database from restore point to dedicated sql pool on synapse on same resource group we are trying to do restore azure sql server db on same restore group where we have synapse but it ends up with error ERROR1.JPG Command…
asked 2024-09-11T14:01:57.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(48, 80%, 14%)' 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)
Andrea Galardi
0
Reputation points
answered 2024-10-17T14:52:09.0066667+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(153.6, 82%, 24%)' 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)
Julian Francis
0
Reputation points
8 answers
Retirement notice: Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025
We’re constantly making updates to Azure SQL Database APIs to ensure optimal security and performance. As part of these updates, we’ll retire Azure SQL Database API version 2014-04-01 on 31 October 2025. See our documentation for a detailed list of all…
asked 2022-11-02T22:58:09.407+00:00
GeethaThatipatri-MSFT
29,397
Reputation points Microsoft Employee
commented 2024-10-17T09:43:16.6+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(211.20000000000002, 57.99999999999999%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
KLAIBER, Anthony
5
Reputation points
1 answer
MSSQL - Error Creating Managed Instance - Polling Failed
Trying to deploy a MSSQL Managed Instance via terraform. We have checked our parameters and configurations. We have reached out to our app support team and continue to fail to deploy. We are getting the following error message: --Please note I have…
asked 2024-09-27T21:12:52.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(51.2, 9%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Gunnar Smith
0
Reputation points
commented 2024-10-17T09:30:24.2833333+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(230.39999999999998, 96%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Samrat Basra
20
Reputation points
1 answer
One of the answers was accepted by the question author.
How to restore Azure managed instance database Spilt backup or FILT backup files from Azure to Local server .
We are trying to restore Azure managed instance database Split or FILT backup files from azure to local server , how to restore multiple Split backup files in Local SQL server at a time .
asked 2024-10-08T10:57:00.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(6.4, 44%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Srinivas Naraipeddi
20
Reputation points
commented 2024-10-17T09:28:53.61+00:00
Srinivas Naraipeddi
20
Reputation points
1 answer
SQLServerException: An item with the same key has already been added.
Running the query: SELECT name FROM [" + catalog + "].sys.schemas ORDER BY name I got exception: 10:05:26 [com.microsoft].sqlserver.jdbc.SQLServerException: An item with the same key has already been added. RequestId:…
asked 2024-10-03T17:18:28.88+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(188.79999999999998, 57.99999999999999%, 28%)' 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)
dprutean
0
Reputation points
commented 2024-10-16T16:23:36.1533333+00:00
Oury Ba-MSFT
19,346
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Error encountered while deploying Azure Data Sync Template
I am encountering the following errors while attempting to deploy an existing Azure Data Sync template to set up a new data sync. Failed to perform data sync operation: '' is invalid schema master (Code: SyncOperation_GenericFailure) Advisor…
asked 2024-10-10T16:51:55.9366667+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(128, 39%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Subramanian Hariharan
20
Reputation points
commented 2024-10-16T15:33:08.02+00:00
Subramanian Hariharan
20
Reputation points
2 answers
One of the answers was accepted by the question author.
Unable to unit test AzureResourceManager.java operations
I have this method in my java code and I am trying to unit test this AzureResourceManager azure = // assume that this is getting initialised properly return azure.sqlServers() .manager() .serviceClient() .getJobAgents(); I am not…
asked 2024-09-29T08:28:31.7066667+00:00
Ayush Shrivastava
120
Reputation points
accepted 2024-10-16T12:28:44+00:00
Ayush Shrivastava
120
Reputation points