Azure SQL Database
An Azure relational database service.
5,539 questions
1 answer
One of the answers was accepted by the question author.
How do I update an Azure SQL Database to a newer version of the resource API?
I got this email from Azure Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025 You're receiving this email because you use Azure SQL Database APIs. To improve performance and security, we're updating Azure SQL Database…
asked 2022-11-02T10:04:56.997+00:00
Arve Svendsen
46
Reputation points
commented 2024-08-26T14:15:50.23+00:00
Steinke, Andy
1
Reputation point
0 answers
I/O Consumption at 100% after the new release
we recently released a software update where we released a couple of log tables and other things. after the release , the I/O consumption reached at 100% . the perfomance of the website has gone down drastically . there are a lot of read write operation…
asked 2024-08-21T02:36:06.7066667+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, 20%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Rishi Parpyani
0
Reputation points
commented 2024-08-26T14:02:31.14+00:00
GeethaThatipatri-MSFT
29,107
Reputation points Microsoft Employee
0 answers
Request to Enable PostGIS Extension on Azure PostgreSQL Server
I am hosting a PostgreSQL server on Azure and need to use the PostGIS extension for my project. However, when attempting to install the extension with the azure_pg_admin user, I receive the following error: ERROR: extension "postgis" is not…
asked 2024-08-25T05:18:06.2366667+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, 70%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
tugce tay
0
Reputation points
commented 2024-08-26T13:38:15.77+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,791
Reputation points
1 answer
How to restore a MABS with the DPMSync
Got some error when im trying to recover a MABS to another computer.what happened is as follow. first i backuped the dpmdb of the MABS to Azure,and we can call this server "M04" secondly i clothed the M04 and move it out of the domain i…
asked 2024-08-23T07:11:00.51+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, 25%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
li_shouheng
20
Reputation points
answered 2024-08-26T09:51:51.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(32, 57.99999999999999%, 13%)' 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)
Amardeep Saini
925
Reputation points Microsoft Employee
2 answers
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
answered 2024-08-26T07:50:08.6333333+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
0
Reputation points Microsoft Vendor
1 answer
Cosmos database analytical store Vs SQL Database with read replica
Hi Team, I am currently exploring Azure cosmos database and come across the 'Analytical store' feature of cosmos database. I was reading MS documents related to use & benefits of analytical store, but my questions is how it's different than Azure SQL…
asked 2024-08-22T06:44:18.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(3.2, 77%, 10%)' 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)
Jaydeep Suryawanshi
26
Reputation points
commented 2024-08-26T06:27:09.7566667+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(249.60000000000002, 14.000000000000002%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECT%3C/text%3E%3C/svg%3E)
Citius Tech - Jaydeep Suryawanshi
0
Reputation points
1 answer
Azure Entra ID Authentication fails on Azure APP Services
On Local applicaitons we are able to validate connection Server=tcp:XXXXX.database.windows.net,1433;Initial Catalog=demo;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;Authentication=Active Directory Default; Once deployed in azure same…
asked 2024-07-10T18:52:40.6633333+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, 24%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E2%3C/text%3E%3C/svg%3E)
21887231
0
Reputation points Microsoft Vendor
commented 2024-08-26T06:19:55.5866667+00:00
Sai Raghunadh M
0
Reputation points Microsoft Vendor
1 answer
How to make exclusiv config changes on a managed instance
We want to make a change to the configuration of a DB which seems to be done best when there are no active users/connections to the DB. In our case we want to set READ_COMMITTED_SNAPSHOT to ON We thought of using SINGLE_USER Mode like described here:…
asked 2024-08-05T09:22:33.1333333+00:00
Thimo König
0
Reputation points
commented 2024-08-26T05:31:10.4933333+00:00
ShaktiSingh-MSFT
14,791
Reputation points
0 answers
how to fix connect timeout while copiying from mysql to azure sql using AZURE DATA FACTORY
I have this error while deploying the task of copiying 5 tables from mysql to azure sql on datafactory Operation on target ForEach_qx9 failed: Activity failed because an inner activity failed; Inner activity name: Copy_qx9, Error:…
asked 2024-08-20T10:06:29+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, 34%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Arturo Beltran
0
Reputation points
commented 2024-08-26T04:59:28.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(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' %3EN%3C/text%3E%3C/svg%3E)
NIKHILANETHIKUNTA
1,025
Reputation points Microsoft Vendor
1 answer
I'm not identifying if my account will have problems with the migration on 31 August 2024
Quais serviços clássicos terão problemas com a migração das contas de armazenamento classico que será realizada no dia 31 de agosto. Uso um banco de dados MS SQL, chamadas via HTTP aspx e vbx. Acho incrível eu pagar um serviço que não existe nenhum tipo…
asked 2024-08-16T21:38:41.7+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' %3EAT%3C/text%3E%3C/svg%3E)
Aristóteles Melo
0
Reputation points
commented 2024-08-26T04:52:34.04+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(150.4, 64%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
Nehruji R
6,196
Reputation points Microsoft Vendor
1 answer
How to identify it is one update operation for table which has enable cdc
We know that we can use change data capture to monitor the data change on sql database table. I tried to run UPDATE TABLENAME SET PKColumn=NewValue where PKColumn=OldValue We can see that there will be one row marking the delete operation and one row…
asked 2024-07-11T08:51:41.18+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, 59%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
WisonHii
81
Reputation points
commented 2024-08-26T04:36:15.3433333+00:00
Sai Raghunadh M
0
Reputation points Microsoft Vendor
1 answer
End of Life reminder: Migrate to Azure Database for MySQL Flexible Server by 16 September 2024 to avoid impact
Hi Support. Per your email dated on 17/5 regarding the EOL for Azuare Database for SQL Single Server after 16-Sep-2024, we would like to clarify : What does it mean by force migrate in a phased manner? Will our existing MySQL Single Server be…
asked 2024-08-12T03:30:41.61+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, 54%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOV%3C/text%3E%3C/svg%3E)
Object Valley
0
Reputation points
commented 2024-08-25T00:17:08.89+00:00
Vinodh247
15,701
Reputation points
1 answer
source is azure sql server tables are moving from azure adf piplelines but user is refreshing from powerbi showing mentioned error.
source is azure sql server tables are moving from azure adf piplelines but user is refreshing from powerbi showing mentioned error.
![](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, 38%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
0 answers
Can no longer connect to Azure SQL Database
I have a database client application running on Windows with the option to connect to three separate databases on Azure. Each database has a separate client logon credentials. This client application and databases have been working great for several…
asked 2024-08-23T12:38:50.0133333+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, 30%, 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)
Andrew Fraser
91
Reputation points
commented 2024-08-23T22:45:05.5833333+00:00
Oury Ba-MSFT
18,361
Reputation points Microsoft Employee
2 answers
Write Operations on primary database latency issue
I have a Azure SQL database replicated to two regions. As per azure documentation secondary databases are read only. In that case all my write operations will be directed to primary. Will that cause latency issue? because my regions are not closer to…
asked 2024-08-20T13:33:05.2566667+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, 18%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
Neela
0
Reputation points
answered 2024-08-23T22:05:13.0366667+00:00
Oury Ba-MSFT
18,361
Reputation points Microsoft Employee
1 answer
changing Entra Admin in SQL server bicep template
I have deployed an Azure SQL server with some Entra Id admin through bicep template: but when i redeploy by changing the entra admin, It is not allowing me to do so it throws an error like the provided adminlogin is not valid. I gone through the…
asked 2024-08-22T07:35:04.04+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(28.799999999999997, 45%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Smriti
0
Reputation points
answered 2024-08-23T21:06:13.18+00:00
Sedat SALMAN
13,735
Reputation points
1 answer
Storing JSON in Azure SQL Table
How can I store JSON responses received from a web activity within Azure Data Factory in an Azure SQL table? The JSON output contains special characters that need to be preserved in the table. I have tried passing the JSON as a string to the stored…
asked 2024-08-14T07:09:39.53+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(201.6, 90%, 29%)' 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)
Sodi, Deepthika
0
Reputation points
commented 2024-08-23T17:48:06.2466667+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, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bhargava-MSFT
30,051
Reputation points Microsoft Employee
1 answer
Configure service account in Azure SQL Server
Good morning, I have an SQL Server running on an Azure Virtual Machine, and I've been tasked with creating a 'Service Account' and configuring the SQL Server services (SQL Server and SQL Server Agent) to use this new account. Currently, my SQL Server is…
asked 2024-08-16T13:43:28.21+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, 18%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECA%3C/text%3E%3C/svg%3E)
Cristopher Aguilera
91
Reputation points
commented 2024-08-23T12:36:08.11+00:00
Cristopher Aguilera
91
Reputation points
1 answer
ACI needs MS SQL access which is on an azure VM, how do I achieve this?
Hi, I have deployed a container instance which has a connection string which points to a SQL database which is hosted on an azure virtual machine. The virtual machine has its own public IP address. However, the container instance cannot "see"…
asked 2024-07-03T11:19:30.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(118.4, 7.000000000000001%, 21%)' 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)
Sean Kelly
0
Reputation points
edited a comment 2024-08-23T11:57:14.5266667+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
0
Reputation points Microsoft Vendor
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 SQL Database
An Azure relational database service.
5,539 questions
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,139 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-08-23T09:25:14.1233333+00:00
Sai Raghunadh M
0
Reputation points Microsoft Vendor