Azure SQL Database
An Azure relational database service.
5,573 questions
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-27T05:46:28.98+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
75
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Azure SQL Server
Please Could you help me with the following question: In Azure SQL Servers With which script(s) should a login be created using MFA authentication with T-SQL? Then with which script should the users be created within the databases of said SQL engine and…
asked 2024-08-22T18:13:19.2233333+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, 16%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFG%3C/text%3E%3C/svg%3E)
Fernando Gutierrez
160
Reputation points
commented 2024-08-26T20:01:45.9266667+00:00
Oury Ba-MSFT
18,601
Reputation points Microsoft Employee
2 answers
Azure SQL Database 2014-04-01 APIs will be retired
Hello, I would like to know where to go to see if the Azure SQL Database is using 2014-04-01 APIs. Please let me know if you need any more info.
asked 2022-11-01T08:05:49.113+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(64, 19%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Shane Van Niekerk
81
Reputation points
commented 2024-08-26T15:41:06.28+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(25.6, 11%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJW%3C/text%3E%3C/svg%3E)
James Wall
0
Reputation points
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,377
Reputation points Microsoft Employee
1 answer
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
answered 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,816
Reputation points
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
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,966
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
75
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
16,751
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)
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,573 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,149 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
75
Reputation points Microsoft Vendor
0 answers
How to overcome the Foreign key constraint issues when we configure SQL DB Sync between 2 Azure SQL Databases.
It's common that we use Foreign Keys in SQL Database. So when we configure Sync Groups and trigger a Sync, we face issues due to foreign keys. so that we have sync the tables in sequential order. is it not possible to define the order of tables while we…
asked 2024-08-14T16:39:14.8533333+00:00
Sai Kiran Maturi
61
Reputation points
edited a comment 2024-08-23T06:06:21.55+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, 95%, 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)
hema
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Connection string is not valid [87] when trying to connect to the managed instance through ODBC
Hello, I have an issue connecting to the Azure Managed Instance through OBDC SQL Server Driver 18. The error message is posted below. I was only able to connect using two of the computers, which happen to be used be admins but could connect to it using…
asked 2024-08-20T19:50:53.5366667+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, 90%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Taha Souri
20
Reputation points
commented 2024-08-22T21:45:13.0033333+00:00
Taha Souri
20
Reputation points
1 answer
Error connecting to Azure Managed Instance through ODBC
I am unable to connect to the Azure Managed Instance using the OBDC SQL Server Driver 18. The error message says the connection string is not valid [87]. I have tried different ODBC driver versions and changing the TLS version on Azure portal but it did…
asked 2024-08-20T19:51:42.22+00:00
Taha Souri
20
Reputation points
edited a comment 2024-08-22T21:43:45.1833333+00:00
Oury Ba-MSFT
18,601
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
SQL Server
Hello I would like someone to help me with the following problem I am having. From SQL Management Studio. In SQL Server, when I have to create a new Login, when I right-click on the Login folder and select new login, by default it opens the way to create…
asked 2024-08-22T14:24:50.5566667+00:00
Fernando Gutierrez
160
Reputation points
commented 2024-08-22T18:12:22.13+00:00
Fernando Gutierrez
160
Reputation points
3 answers
One of the answers was accepted by the question author.
Is UniqueIdentifier will be a good choice for Primarykey
Hello, "Is UniqueIdentifier will be a good choice for Primarykey". As I know that Uniqueidentifier identifier comparison will take more time than a number comparison. I can see a lot of issues on Uniqueidentifier. In our projects, most of the…
asked 2023-11-22T14:42:37.08+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(54.400000000000006, 59%, 15%)' 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)
Sajith A K
20
Reputation points
accepted 2024-08-22T08:00:51.3566667+00:00
Sajith A K
20
Reputation points
1 answer
unable to create sql server. getting like Your subscription does not have access to create a server in the selected region. For the latest information about region availability for your subscription, go to aka.ms/sqlcapacity. Please try another region or
unable to create sql server. getting like Your subscription does not have access to create a server in the selected region. For the latest information about region availability for your subscription, go to aka.ms/sqlcapacity. Please try another region or…
asked 2024-08-14T11:33:08.95+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, 86%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
varunreddy
0
Reputation points
commented 2024-08-22T06:33:02.9766667+00:00
ShaktiSingh-MSFT
14,816
Reputation points
3 answers
How to log from Azure SQL Database
Is there a way to log messages in Azure SQL database directly ? similar to what we do with any springboot application ? log.error or log.info("your message");
asked 2024-07-19T12:06:05.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(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
40
Reputation points
answered 2024-08-22T04:15:10.9733333+00:00
ShaktiSingh-MSFT
14,816
Reputation points
1 answer
Replicating a Pipeline Multiple Times in Azure Synapse Analytics
How can I replicate a pipeline multiple times in Azure Synapse Analytics? I need to replicate my pipeline 10 times with only a change to the table name which is passed as a parameter. Thanks in advance!
asked 2024-08-16T09:26:31.9833333+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(57.599999999999994, 69%, 15%)' 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)
Aditya Singh
130
Reputation points
commented 2024-08-21T16:35:32.7966667+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,425
Reputation points Microsoft Vendor
1 answer
Delete lock prevents editing of IP address in Azure Sql Server firewall
We are unable to edit IP addresses in Azure Sql Server firewall whilst a delete lock is in place. Some of our staff do not have static IP addresses so have to regularly update their IP addresses in the firewall. The only way to do this is to first…
asked 2022-05-19T20:59:00.66+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(35.2, 64%, 13%)' 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)
LXX
1
Reputation point
commented 2024-08-21T14:00:27.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(224.00000000000003, 74%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM3%3C/text%3E%3C/svg%3E)
MaartenK-3165
0
Reputation points