Azure SQL Database
An Azure relational database service.
5,171 questions
1 answer
Unable to Modify innodb_dedicated_server variable in Azure Database for MySQL (Flexible Server) - Workarounds or Alternatives?
I'm trying to optimize performance for my Azure Database for MySQL (Flexible Server) instance. In my research, I found the innodb_dedicated_server parameter, but it's greyed out in the Azure portal, indicating it's non-modifiable,can i change this…
asked 2024-05-09T09:57:21.24+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, 79%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Niket Kumar Singh
190
Reputation points
edited a comment 2024-05-10T05:21:51.6333333+00:00
Niket Kumar Singh
190
Reputation points
3 answers
One of the answers was accepted by the question author.
sqlcmd fails to connect to azure sql server because of mfa, but active directory says mfa is disabled
I have been following this guide: https://learn.microsoft.com/en-us/azure/azure-functions/functions-identity-access-azure-sql-with-managed-identity and have reached the step "Grant SQL database access to the managed identity". I have…
asked 2024-04-27T14:28:52.5466667+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(115.19999999999999, 10%, 21%)' 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)
Sondre Dahl
20
Reputation points
edited the question 2024-05-10T05:10:06.0066667+00:00
ZoeHui-MSFT
33,296
Reputation points
2 answers
One of the answers was accepted by the question author.
Hi , I have created one Azure SQL database with Basic pricing tier. I am not able to take it offline or pause the database.
when i go to Settings -> Properties, I can see an option Status ->online for that database but I can not change it to Offline/Pause. Please help since this effect my billing.
asked 2024-04-29T01:26:13.5466667+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, 68%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Ankit Kumar Gupta
25
Reputation points
edited the question 2024-05-10T05:09:22.7466667+00:00
ZoeHui-MSFT
33,296
Reputation points
0 answers
I am facing Issues for data replication of specific tables (Bi-Directional) in SQL databases at two different regions hosted on Azure Cloud.
Hi, I have SQL Databases in Europe Region & USA Region hosted on Microsoft Azure cloud. I want to sync specific tables of both databases. I have researched about database replication approach (Transactional Replication, Snapshot Replication,…
asked 2024-05-09T18:23:13.1233333+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(115.19999999999999, 50%, 21%)' 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)
Raj, Ritu
0
Reputation points
commented 2024-05-10T03:47:38.5133333+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
13,751
Reputation points Microsoft Employee
2 answers
¿Cómo recupero la información de licencia OLP Microsoft SQL (2019 )?
¿Cómo recupero la información de licencia OLP Microsoft SQL (2019 )? Secuencia del tiempo Se toma la decisión de ordenar licenciamiento de productos usados en la nuestra compañía, Microsoft, Adobe y otros A fines del año 2017 compramos una…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,171 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.
12,795 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
496 questions
Windows Licensing
Windows Licensing
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.Licensing: Rules, regulations, and restrictions that define how software can be used and distributed.
38 questions
Windows Server Licensing
Windows Server Licensing
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Licensing: Rules, regulations, and restrictions that define how software can be used and distributed.
23 questions
asked 2024-05-09T20:37:57.65+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, 84%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Andres Ramdohr
0
Reputation points
answered 2024-05-10T01:27:12.7233333+00:00
ZoeHui-MSFT
33,296
Reputation points
1 answer
Error in Linked Service connected to azure sql db using Azure Key vault
The linked service is not working after performing CICD from dev to qa branch. All the resources are copied along with linked service. However, The linked service could not setup correctly with this error. What does this error indicate and how to…
asked 2024-05-09T15:16:14.0666667+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(144, 71%, 23%)' 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)
Sudip Bala
0
Reputation points
answered 2024-05-09T23:08:25.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(214.4, 81%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Marilee Turscak-MSFT
34,066
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
I have been charged without my knowledge for the service that i did not use!
I have been charged without my knowledge for the service that i did not use. my number is #G047412504. it gives me error when i try to get refund. even though it displays that i am eligeable.
asked 2024-05-09T17:36:27.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(204.8, 7.000000000000001%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mehmet Ali KABA
0
Reputation points
accepted 2024-05-09T21:10:29.6566667+00:00
Mehmet Ali KABA
0
Reputation points
0 answers
Issues with EF Update Command and Azure Credentials in ASP.NET Core Application
I am encountering errors while attempting to run an Entity Framework (EF) update command (dotnet ef database update) from my ASP.NET Core application. The application is connected to a database hosted on Azure. After executing the EF update command, I am…
asked 2024-05-09T18:29:21.49+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(73.60000000000001, 24%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYE%3C/text%3E%3C/svg%3E)
Yamen Edel
0
Reputation points
asked 2024-05-09T18:29:21.49+00:00
Yamen Edel
0
Reputation points
1 answer
How to add Azure SQL Database as linked service to Azure Data Factory
I keep running into errors adding Azure SQL as a linked service to Data Factory. I'm new to Azure so please bear with me. Following all the online guides, I've done all of the following: On the SQL Server side: Under Microsoft Entra ID, enabled…
![](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, 44%, 40%)' 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)
![](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)
4 answers
CosmosDB Analytical store delete changes in sql sink
Hi I am trying to capture delete changes from Azure cosmosdb analytical store using change data capture in Azure datafactory, Source is Cosmosdb, sink is Azure sql database. In between I am flattening my file using dataflow. My insert, update is…
asked 2024-04-30T13:52:46.2133333+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(112.00000000000001, 15%, 20%)' 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)
Kuldeep Bhati
0
Reputation points
answered 2024-05-09T14:12:26.07+00:00
Kuldeep Bhati
0
Reputation points
2 answers
How to create and migrate the tables from one azure database to another azure database
Use-Case- I have 130 tables in the Azure sql database, I need to create and migrate the 130 tables to another azure sql database. Can I use the Azure data factory auto-create functionality to migrate those 130 tables. How the primary keys and indexes of…
asked 2024-05-08T08:29:13.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(3.2, 68%, 10%)' 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)
Rahul
251
Reputation points
edited an answer 2024-05-09T13:29:04.32+00:00
Alberto Morillo
32,896
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Location 'southindia' is not accepting creation of new Windows Azure SQL Database servers for the subscription
I tried creating an Azure Synapse workspace. After clicking on the final 'review+create' option & it was getting deployed, I received an error (image below). However, I can see a storage account & a synapse storage account created. Only the…
asked 2024-05-09T10:11:51.47+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, 22%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jeenia Bhadra
20
Reputation points
commented 2024-05-09T12:20:34.8966667+00:00
Jeenia Bhadra
20
Reputation points
2 answers
Unable to connect to my SQL Server/Database. Listed resources on Microsoft do not address this issue.
Error codeSqlFailedToConnect DetailsCannot connect to SQL Database. Please contact SQL server team for further support. Server: 'blazor-wasm-app.database.windows.net', Database: 'BrandedFoodMacrosContent', User: [...BLANK...] Check the linked service…
asked 2024-05-04T23:34:12.1833333+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(144, 44%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Albert Kirpach
0
Reputation points
commented 2024-05-09T09:35:58.83+00:00
MikeyQiao-MSFT
560
Reputation points Microsoft Vendor
3 answers
Azure workload move tenant to tenant
Dear All, we have existing tenant with listed below workloads and we are planning to move all these workloads to new tenant. what is the best way to move it with any production impact.
asked 2024-04-22T10:02:48.6933333+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, 56.00000000000001%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rakesh Kumar
456
Reputation points
answered 2024-05-09T08:56:18.6533333+00:00
SadiqhAhmed-MSFT
38,321
Reputation points Microsoft Employee
1 answer
'Invalid column name 'is_change_feed_enabled'.'; detailedError - A database operation failed with the following error: 'Invalid column name 'is_change_feed_enabled'.'
When I tried to setup link connection between on-prem sql server and Azure sql dedicated pool, took the below error. Failed to enable Synapse Link on the source due to 'Failed to enable the source database: Some internal error happened due to 'Calling…
asked 2024-05-08T12:59:49.6566667+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(121.6, 97%, 21%)' 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)
AdmKaraH
0
Reputation points
answered 2024-05-09T06:22:38.51+00:00
AnnuKumari-MSFT
31,151
Reputation points Microsoft Employee
0 answers
User Managed identity with failover group with servers in different regions
while using user managed identity with azure sql , the connection string or token acquired using DefaultAzureCredential is dependent on the clientID of user managed identity. for the scenario when there is a sql failover switch i.e due to outage in one…
asked 2024-05-07T19:44:02.75+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, 34%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
KAMALPREET KAUR
1
Reputation point Microsoft Employee
commented 2024-05-08T23:11:15.5166667+00:00
KAMALPREET KAUR
1
Reputation point 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…
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
commented 2024-05-08T22:56:43.52+00:00
Oury Ba-MSFT
16,636
Reputation points Microsoft Employee
0 answers
ADF - CDC - enable and disable CDC tables during deployment
Hi, I have setup ADF pipeline for data sync of tables between Azure SQL Database to SQL Managed Instance databases. I am using Data Flow and CDC to track changes and sink activity to replicate it to target. However, when we deploy any table changes (add…
asked 2024-05-08T04:29:23.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(166.4, 83%, 26%)' 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)
Ashwani SRIVASTAVA
40
Reputation points
commented 2024-05-08T22:23:19.7466667+00:00
Ashwani SRIVASTAVA
40
Reputation points
0 answers
Query to identify queries executed in a specific Azure SQL DB
Hi All, I am trying to monitor queries running on Azure SQL Databases on a Premium tier Elastic Pool with ReadScale replication enabled. We redirect reporting for our OLTP system against the replicas (using ApplicationIntent = ReadOnly) which means Query…
asked 2024-05-08T12:31:13.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(211.20000000000002, 94%, 30%)' 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)
Matthews, Darren (Capita Retain)
0
Reputation points
commented 2024-05-08T22:13:38.54+00:00
GeethaThatipatri-MSFT
27,717
Reputation points Microsoft Employee
0 answers
Writing an UPDATE SQL query in Azure Data Factory
I'm relatively new to ADF. We currently have a pipeline running that reads data from 5 separate csv files in blob storage, copies them to tables in Azure SQL database, and then calls 4 separate SQL server stored procedures which update, clean, and…
asked 2024-05-08T18:11:28.3966667+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, 54%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDL%3C/text%3E%3C/svg%3E)
David Lang
0
Reputation points
edited a comment 2024-05-08T21:50:30.92+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)
BhargavaGunnam-MSFT
26,331
Reputation points Microsoft Employee