Azure SQL Database
An Azure relational database service.
5,166 questions
2 answers
Azure SQL elastic pool pausing feature
Hello, There are 5 databases I need to host on Azure SQL. They will only be used during week day work hours (i.e. 10 hours a day), so it would be great if they can be paused during the night so that we can save cost. I was wondering if an elastic pool…
asked 2023-08-21T09:08:26.2633333+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, 83%, 34%)' 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)
Jack Wong
10
Reputation points
commented 2024-04-30T19:19:07.28+00:00
Oury Ba-MSFT
16,556
Reputation points Microsoft Employee
2 answers
How to generate alert for Azure SQL DB
Hi Team, Could you please suggest how to generate an alert in below scenarios in Azure SQL via Azure Monitor? Query running longer than 1 hour (long running query) Session running longer than 24 hours (long running session) Table Space --> do we…
asked 2023-10-20T04:17:07.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(211.20000000000002, 56.00000000000001%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
Parekh, Ravi
0
Reputation points
commented 2024-04-30T08:36:55.3866667+00:00
Parekh, Ravi
0
Reputation points
1 answer
Handling different date formats in Azure SQL
I need help with writing a stored procedure in Azure SQL that updates datetime values stored as varchar columns with different date formats to a consistent format of 'MM/dd/yyyy hh:mm:ss'. Specifically, the columns whose names end with 'DP' need to be…
asked 2024-04-27T06:50:10.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(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-04-30T03:41:43.3366667+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
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
commented 2024-04-30T01:18:10.16+00:00
Ankit Kumar Gupta
25
Reputation points
1 answer
ODBC Connection DSN and Linked Table Manager Giving Different Results: The link table manager in access database only gives the master tables
I am setting up a DSN and a Linked Table Manager link all on the same Access database on the same computer with the same database Login and associated User (and of course the same database). The DSN gives me the tables I need, but the Linked Table…
asked 2024-04-23T20:44:30.33+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, 50%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
EFS
0
Reputation points
commented 2024-04-29T20:43:08.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(262.40000000000003, 46%, 35%)' 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 Kallal
4,806
Reputation points
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-04-29T16:49:57.22+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, 79%, 32%)' 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)
Rahul Randive
8,521
Reputation points Microsoft Employee
2 answers
How to view SQL Azure Business Critical Tier - Qurom, replics, etc.
We just scaled from General Purpose Tier to Business Critical in our main production Azure SQL Database (not Managed Instance). Everything is running fine, and I can connect to the read only replica successfully. Besides initiated a manual failover, I…
asked 2024-04-23T14:42:05.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(54.400000000000006, 42%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
John Allen
0
Reputation points
commented 2024-04-29T16:46:45.4933333+00:00
Oury Ba-MSFT
16,556
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How to split rows and columns by using ADF?
How can I retrieve data from the following table by using ADF lookup activity and want to get the result as below? Thanks
asked 2024-04-15T15:57:51.3866667+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, 32%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZY%3C/text%3E%3C/svg%3E)
Zhu, Yueli YZ [NC]
235
Reputation points
edited a comment 2024-04-29T15:28:53.3533333+00:00
Zhu, Yueli YZ [NC]
235
Reputation points
1 answer
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
5
Reputation points
edited a comment 2024-04-29T14:36:37.96+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, 43%, 27%)' 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)
Addy
0
Reputation points
2 answers
Topic Learn: Create a dataset for .NET Framework application using the Dataset Designer
I wanted to follow this help: This walkthrough uses SQL Server Express LocalDB and the Northwind sample database. (All steps followed) Create a New Windows Forms Application Project (All steps followed) Add a New Dataset to the Application Name the…
asked 2024-04-27T15:23:31.7733333+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, 17%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMF%3C/text%3E%3C/svg%3E)
Malcolm Fellmann
5
Reputation points
answered 2024-04-29T12:56:24.47+00:00
Malcolm Fellmann
5
Reputation points
2 answers
Understanding Active-Passive Disaster Recovery and Transition Steps for Azure API Management and App Service
When setting up an active-passive disaster recovery (DR) setup, does it mean that the secondary (passive) environment is not actively processing requests or transactions? Is it essentially a standby environment that's ready to take over in case the…
asked 2024-04-13T17:42:10.39+00:00
Jagadeeskumar Lenin
121
Reputation points
answered 2024-04-29T11:36:21.7766667+00:00
Pabitra Kumar Sikdar
80
Reputation points Microsoft Employee
1 answer
Deployment of App service
I am creating an Azure SQL database and after clicking on review and create. But for hours I am getting deployment in progress and I don't know why. Any help?
asked 2024-04-26T01:46:39.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(185.6, 88%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOE%3C/text%3E%3C/svg%3E)
Olanrewaju, Emmanuel A
0
Reputation points
answered 2024-04-29T07:47:47.3666667+00:00
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee
2 answers
Synapse can't transfer data from parquet file to Azure SQL Database table
Hi! The pipeline in Synapse (workspace) transfers data from parquet files to a database using a copy activity. Everything has been working fine for months, but today it simply times out without a specific error. It seems the problem lies in…
asked 2024-04-26T10:37:45.7633333+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, 11%, 10%)' 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)
Lily
1
Reputation point
commented 2024-04-29T03:49:26.3533333+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, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
10,080
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
How does Intune license verification work?
Hello, I have a few questions that I haven't found an answer to. Intune license is per user. However, a user may have multiple devices. What's stopping you from using one account to add devices to Intune and transferring those devices to users who don't…
asked 2024-04-26T19:04:08.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(179.20000000000002, 86%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Mountain Pond
1,201
Reputation points
commented 2024-04-27T21:47:12.9366667+00:00
Mountain Pond
1,201
Reputation points
1 answer
One of the answers was accepted by the question author.
Connecting Azure Data Factory to Azure SQL Managed Instance
I am trying to connect Azure Data Factory to Azure SQL Managed Instance, but I cannot get it to work. The MI is on a private endpoint, and the Data Factor is on a private endpoint. I created the Linked Service with a private endpoint: When I create…
asked 2024-04-22T22:31:35.87+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, 66%, 22%)' 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)
Scott Klein
161
Reputation points
commented 2024-04-27T17:08:35.23+00:00
Scott Klein
161
Reputation points
6 answers
If I stop the database will it cost me in Azure?
If I stop the database will it cost me in Azure?
asked 2021-08-03T09:43:07.707+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(307.2, 0%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERJ%3C/text%3E%3C/svg%3E)
Ravindra Joshi
6
Reputation points
answered 2024-04-27T07:19:18.6966667+00:00
classificaion
0
Reputation points
4 answers
One of the answers was accepted by the question author.
need help downloading sql server on my ,mac,
Hi everyone im trying ways to download the sql server and cant do it, need help downloading sql server on my ,mac, provide a info and download link if possible
![](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, 95%, 14%)' 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)
4 answers
One of the answers was accepted by the question author.
SSMS UI bug (all versions so far)
Hello there, There is an annoying bug in the SSMS UI that I thought will be found and fixed with the latest version (19.0.1) I just installed. It persists in all the previous versions I used and is available here too. Here is the description: Connect…
asked 2023-03-20T08:34:33.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(44.800000000000004, 44%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Hristo Serafimov
35
Reputation points
commented 2024-04-26T22:24:43.5566667+00:00
Oury Ba-MSFT
16,556
Reputation points Microsoft Employee
2 answers
Azure SQL DB Autoscaling issue
Hello, I'm currently facing an issue with automating the scale up/down of my Azure SQL DB. When the DB experiences high DTU usage and the auto scale-up is triggered by an alert runbook, the query that was running on the DB gets interrupted, causing my…
asked 2024-04-17T15:38:07.7833333+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(83.2, 91%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
MoTaar
290
Reputation points
edited the question 2024-04-26T19:31:29.49+00:00
Oury Ba-MSFT
16,556
Reputation points Microsoft Employee
1 answer
Unable to deploy SQL Server bicep template using AzureAD Authentication: true
Hi, I am deploying Azure SQL Server with administratorLoginPassword using Incremental mode but it is giving me error (AadOnlyAuthenticationIsEnabled). I need to use the password while deploying and I cannot ignore it. Also, while deploying the sql server…
asked 2024-04-25T13:19:32.6266667+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, 91%, 33%)' 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)
Srikanth Vanam (PERSISTENT SYSTEMS LIMITED)
0
Reputation points Microsoft Vendor
answered 2024-04-26T19:23:19.9666667+00:00
Oury Ba-MSFT
16,556
Reputation points Microsoft Employee