Azure SQL Database
An Azure relational database service.
5,247 questions
1 answer
Azure SQL Database Free Tier Plan
Hello, Why is it that I pick the Free - General Purpose - Serverless: Gen5, 2 vCores which indicates that: First 32 GB storage free **First 100,000 vCore seconds free Yet I have received a bill of USD 250 on my card**
asked 2024-06-01T00:35:47.8933333+00:00
Sinzore
40
Reputation points
edited an answer 2024-06-01T05:36:52.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(86.4, 13%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGC%3C/text%3E%3C/svg%3E)
Gowtham CP
2,215
Reputation points
2 answers
convert pay as you go instance into reserved instance
Hi, I have nearly 12 instances and databases in different regions and I want to change them to Reserved Instances and databases. What is the procedure to implement them as Reserved Instances and databases? Can anybody help me? Do I need to purchase…
asked 2024-05-30T06:19:16.89+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(313.6, 37%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Revathi Senthilkumar
0
Reputation points
answered 2024-05-31T23:07:12.17+00:00
Oury Ba-MSFT
16,901
Reputation points Microsoft Employee
1 answer
Copy activity throwing an error, when a auto incremented column is there on the Sink side
Hello Team, I am trying to copy data from Amazon S3 to Azure SQL database. On Azure SQL side I have set an autoincrement column(Row_Index) in a table, however the copy activity throws an error that "Column 'Row_Index' does not allow…
asked 2024-05-15T22:53:21.2033333+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(131.20000000000002, 0%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Shweta Chavan
40
Reputation points
commented 2024-05-31T22:33:28.77+00:00
Oury Ba-MSFT
16,901
Reputation points Microsoft Employee
0 answers
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…
asked 2024-05-31T22:32:34.61+00:00
David Thielen
2,356
Reputation points
asked 2024-05-31T22:32:34.61+00:00
David Thielen
2,356
Reputation points
1 answer
Error with ODBC Driver - pyodbc.InterfaceError: ('IM002', '[IM002] [unixODBC][Driver Manager]Data source name not found and no default driver specified (0) (SQLDriverConnect)')
Hello, I set up a CICD pipeline to handle deploying python code to the App Service but get this screen In the console it says "Failed to load resource: the server responded with a status of 503 (Service Unavailable)" When I look in the logs,…
asked 2024-05-31T19:21:14.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(163.2, 44%, 25%)' 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)
Anon
0
Reputation points
answered 2024-05-31T20:17:33.2066667+00:00
Alberto Morillo
33,086
Reputation points MVP
2 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-31T19:06:40.6466667+00:00
GeethaThatipatri-MSFT
28,142
Reputation points Microsoft Employee
1 answer
From Synapse notebook, trouble connecting to Azure SQL using system managed identity
I can create a Linked Service to my Database using my Synapse system-managed identity. This works fine, and the "test connection" shows success. But for the life of me, I can't figure out how to do it in a Python notebook. Here is the…
![](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, 80%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
Azure SQL Database and Azure SQL Managed Instance
can anyone explain me the dff btween the "Azure SQL Database" and "Azure SQL Managed Instance"? Are they the same, or am I missing someything.
asked 2024-02-01T19:04:09.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(12.8, 47%, 11%)' 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)
dwaine
20
Reputation points
commented 2024-05-31T17:41:36.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(12.8, 45%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Romero Adrian
0
Reputation points
2 answers
How to use mTLS to secure a sql database
Hi, I'm trying to an managed sql database in Azure using either a managed sql instance or cosmosdb with the postgres interface. However I would like to secure the communication towards it using mTLS since all of the communication will come from…
asked 2024-05-30T07:43:23.8666667+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, 4%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDA%3C/text%3E%3C/svg%3E)
David Andersson
0
Reputation points
answered 2024-05-31T15:59:40.9966667+00:00
GeethaThatipatri-MSFT
28,142
Reputation points Microsoft Employee
1 answer
Data Sync Offline
I have seen this error from last night's data sync log,however the Data Sync Service was not offline. Can anyone advise what can cause the Sync Agent to be offline. Sync failed with the exception "Sync Agent 'DataSyncAgent-Prod' is offline.
asked 2024-05-30T13:43:05.3233333+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, 2%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGP%3C/text%3E%3C/svg%3E)
Gordon, Priscilla
0
Reputation points
commented 2024-05-31T15:55:00.5333333+00:00
GeethaThatipatri-MSFT
28,142
Reputation points Microsoft Employee
2 answers
Bidirectional replication between on prem SQL server and Azure sql with no primary key exist
Can you suggest possible solution for bidirectional real time sync between on prem SQL (2016) and Azure SQL with no primary key exist
asked 2024-05-30T21:51:18.5233333+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, 57.00000000000001%, 19%)' 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)
Shantanu Dekapurwar
20
Reputation points
answered 2024-05-31T15:53:03.3966667+00:00
GeethaThatipatri-MSFT
28,142
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How can I find help validating a certificate?
Indeed, I am a student in cloud computing in Morocco and I do not have enough means to obtain the AZ 900 certification and my family also does not have enough financial means. Could someone help me validate this certificate please?
asked 2024-05-30T15:54:26.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(35.2, 95%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHY%3C/text%3E%3C/svg%3E)
HAMIDOU YOUSSOUF
20
Reputation points
accepted 2024-05-31T14:55:42.77+00:00
HAMIDOU YOUSSOUF
20
Reputation points
0 answers
How to access Azure SQL Database which is connected with Azure Static Web apps from Next.js?
Hello, I deployed a Next.js app to Azure Static Web apps, and connected to Azure SQL Server via Azure Portal. and I tried to use it as explained at…
asked 2024-05-29T13:29:47.4733333+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, 80%, 27%)' 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)
Jihoo Byeon
0
Reputation points
commented 2024-05-31T12:00:42.66+00:00
VenkateshDodda-MSFT
19,396
Reputation points Microsoft Employee
0 answers
403 Forbidden Error When Running SSRS Reports from Azure Web App within VNet
Hello everyone, I’m facing an issue with accessing SSRS reports hosted on a virtual machine from an Azure Web App with the database on a separate managed instance and the SSRS on a VM with access done via URL. Here’s the situation: The reports execute…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,247 questions
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,318 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,481 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,069 questions
asked 2024-05-28T00:13:24.8333333+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(243.2, 72%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Chris Boyce
20
Reputation points
commented 2024-05-31T04:17:01.28+00:00
brtrach-MSFT
15,366
Reputation points Microsoft Employee
4 answers
Transactional Replication on a SQL Managed instance as a subscriber with pull subscription
We are doing a transactional Replication to a SQL Managed instance (subscriber) with pull subscription from On-Prem(Publisher/Distributor) We are seeing uninitialized subscription on the replication monitor. How can we troubleshoot this
asked 2024-05-16T12:03:46.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(124.80000000000001, 84%, 22%)' 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)
Nitya V
40
Reputation points
commented 2024-05-31T03:07:04.0466667+00:00
LucyChenMSFT-4874
1,815
Reputation points
3 answers
How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server)
How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server) The firewall and network settings looks fine. However we are…
asked 2024-05-21T13:10:34.7166667+00:00
Nitya V
40
Reputation points
commented 2024-05-31T03:05:40.31+00:00
LucyChenMSFT-4874
1,815
Reputation points
1 answer
One of the answers was accepted by the question author.
"Sync to other databases" is missing
Under Data management, select Sync to other databases is missing, I'm the Global Admin / Owner of the Database and Subscription so I think this can't be an access Issue.
asked 2024-05-29T08:24:57.7533333+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, 22%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EER%3C/text%3E%3C/svg%3E)
Erick Rae Q. Nobleza
20
Reputation points
commented 2024-05-30T19:51:30.58+00:00
Alberto Morillo
33,086
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
How to trigger an alert in azure monitor when the particular condition is met continuously for a specific period(say 15 mins)?
Hi Team, I am trying to set up DB metric alerts in azure monitor for a SQL DB. For Ex. Considering the CPU percentage metric, I want to trigger an alert only when the CPU percentage (Max) is breaching the threshold (90%) for 15 mins continuously. In…
asked 2024-02-06T11:00:42.8033333+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, 64%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBD%3C/text%3E%3C/svg%3E)
Barani Dharan
25
Reputation points
accepted 2024-05-30T13:19:19.81+00:00
Barani Dharan
25
Reputation points
1 answer
Azure Data Studio - Data Migration Extension
Hi We used the data migration extension in Azure data studio to migrate sql server db to SQL MI We stored all the backups to hte azure blob container We started the migration Once all the backups showed restored. We marked the db as read only. We…
2 answers
Trying to import On Prem sql server into azure managed instance but it's failing
Trying to import On Prem Sql server into azure managed instance but it's failing.What should I do?
asked 2024-05-30T00:36:18.8766667+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, 44%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
TymeMachine
0
Reputation points
answered 2024-05-30T06:22:20.1633333+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, 43%, 11%)' 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)
darin wolfe
0
Reputation points