Azure SQL Database
An Azure relational database service.
5,872 questions
0 answers
Querying Azure SQL Extended Event not returning any data
I created an extended event in Azure SQL database to capture query data. The data is being written to Azure blog storage, and there is definitely data in the files: I verified that data exists by downloading one of the files and opening it in SSMS. I…
asked 2024-12-23T18:53:21.0233333+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, 18%, 10%)' 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
5
Reputation points
commented 2024-12-25T06:05:16.8933333+00:00
Scott Klein
5
Reputation points
0 answers
Azure data studio table designer error execution time out
An error occurred while generating preview report: One or more errors occurred. (Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.) at…
asked 2024-12-25T03:46:11.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(272, 38%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
Ganbaatar Bold
0
Reputation points
commented 2024-12-25T03:48:08.7433333+00:00
Ganbaatar Bold
0
Reputation points
1 answer
Why did my free Azure SQL database disappear?
I spent several days creating a free Azure SQL database, and it used up all the resources for two months to do it. Later in the second month, it disappeared. What's up?
asked 2024-12-24T08:51:35.39+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, 73%, 29%)' 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)
Christopher Tillman
0
Reputation points
commented 2024-12-24T20:05:19.7366667+00:00
Christopher Tillman
0
Reputation points
1 answer
SQL server with Trace flags 2371 and 7745
Hi Team, We are migrating the SQL server databases to Azure managed instance . The DMA reported that 2371 and 7745 trace flags enabled on SQL instance. i think 2371 and 7745 trace flages auto enabled on Managed instance. Please let me know if changes…
asked 2024-12-20T10:18:09.9266667+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, 92%, 19%)' 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)
Sanjeev K
20
Reputation points
commented 2024-12-24T16:15:03.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(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
1,470
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Azure SQL Database export operation stuck at cancelling
Azure SQL Database export operation stuck at EXPORT DATABASE Cancelling in progress: 50% Some 4-5 Hours already, deleted the storage account it was going to be exported to and server is set to private network access already
asked 2024-12-23T19:27:54.12+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, 77%, 18%)' 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)
Hugo Souza Almeida
0
Reputation points
accepted 2024-12-24T12:45:48.37+00:00
Hugo Souza Almeida
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Web App: TLS support for OLEDB-driver
Hi I have trouble running a website on Azure, using the Microsoft 'Web App'. The website is unable to connect to the SQL Server database running in the same resource group (received error: "The connection's current state is closed"). …
asked 2024-12-21T02:03:32.4833333+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(41.6, 40%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECE%3C/text%3E%3C/svg%3E)
Claes Eriksson
20
Reputation points
commented 2024-12-24T09:42:38.03+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(246.4, 4%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sina Salam
14,241
Reputation points
0 answers
Azure SQL and Logic Apps: Are We Paying for a Managed Service or Managing Azure’s Shortcomings?
Details: I’m Sasha Froyland, founder of Help4Access, and I’m reaching out to the Azure community because my team and I have spent the past six months troubleshooting what should be a "managed" service—Azure SQL Database—and Logic Apps. Instead,…
asked 2024-12-23T03:50:03.9266667+00:00
Sasha Froyland
1
Reputation point
commented 2024-12-24T07:57:31.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(35.2, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijayalaxmi Kattimani
740
Reputation points Microsoft Vendor
2 answers
Azure SQL Import/Export
We have multiple databases within a single server sizing way above 100GB of data hosted in Azure. Normally we tend to restore the same production copy to our non-prod environments using SSMS .backpac method of export and import, however in bigger data…
asked 2024-12-21T14:24:28.0433333+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, 78%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECP%3C/text%3E%3C/svg%3E)
Chetan Prakash Saraswat
26
Reputation points
commented 2024-12-24T01:40:10.6233333+00:00
Vijayalaxmi Kattimani
740
Reputation points Microsoft Vendor
3 answers
Azure SQL Ongoing operations cancel
I tried to export Azure SQL database and that got stuck for several hours in 1%. After that I cancelled export process with Powershell and now it's stuck for cancel in progress... I have tried to scale database but that didn’t do anything. What…
asked 2022-03-29T18:35:42.133+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, 78%, 19%)' 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)
ronis
21
Reputation points
answered 2024-12-23T19:35:42.1433333+00:00
Hugo Souza Almeida
0
Reputation points
0 answers
alert not triggering on azure sql
Hi , we configured alert rule for static ,aggregation type average, greater then , threshold 40% on sql db ealier alerts was worked last few days not working this prod db we are facing lot of issue unless see the metrics then we know the cpu status…
asked 2024-12-18T14:04:00.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(259.20000000000005, 85%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Surapally Sravan Kumar
0
Reputation points
commented 2024-12-23T17:53:47.4466667+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' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
3,920
Reputation points Microsoft Vendor
2 answers
How to expand my db for more markets ?
Right now SQL server db is running in one region and right now we have enabled solution for one market, in future we need to roll out for more markets and need to run in multiple regions . When we enable more markets we will millions of records . can you…
asked 2024-12-16T15:51:16.31+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, 22%, 34%)' 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)
Siva
0
Reputation points
commented 2024-12-23T14:03:29.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(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
1,605
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Azure SQL to Azure SQL Migration using Full & Differential Backup Feasible?
I have to migrate Azure SQL Database completely from one environment to another Azure SQL Database environment. There is no direct network connection between the two environments. Can Azure SQL Database Server backups (Full & Differential Backup)…
asked 2024-12-20T03:31:29.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(118.4, 33%, 21%)' 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)
Rajeskumar S L
20
Reputation points
accepted 2024-12-23T13:53:57.91+00:00
Rajeskumar S L
20
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Backup Point-in-Time Restore (PITR) Feature Details
I am seeking detailed information about the Point-in-Time Restore (PITR) feature in Azure Backup, specifically its usage, functionality, and associated costs relevant to our current setup. Currently, PITR is configured for a 7-day retention period. Is it…
asked 2024-12-18T07:23:42.3933333+00:00
Mohana Reddy
60
Reputation points
commented 2024-12-23T12:52:13.7166667+00:00
Mohana Reddy
60
Reputation points
1 answer
Login failed for user '<token-identified principal>'.
Hello, I am encountering the following error when trying to connect via Microsoft Entra Service Principal in SSMS. I -As Username I am using the Application ID. (I tried with dieguitico0007_hotmail.com#EXT#@dieguitico0007hotmail.onmicrosoft.com but it…
asked 2024-12-16T02:36:55.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(265.6, 36%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
Diego Cedeño
0
Reputation points
commented 2024-12-23T02:18:57.0766667+00:00
Vijayalaxmi Kattimani
740
Reputation points Microsoft Vendor
1 answer
I have migrated my SQL database and web app to azure database and web app services successfully while running the domain the login page shows proper but when i am inserting data and clicking on submit it give error : Named Pipes Provider, error: 40
I have migrated my SQL database and web app to azure database and web app services successfully while running the domain the login page shows proper but when i am inserting data and clicking on submit it give Error: A network-related or instance-specific…
asked 2024-12-16T11:24:58.52+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, 94%, 12%)' 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)
Ashraf Khan
20
Reputation points
answered 2024-12-22T22:05:14.0566667+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, 74%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
Divyesh Govaerdhanan
155
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure SQL Server auditing failure
error.png Hello All, I received this alert and I re-enabled the Azure SQL Auditing. So is my issue solved or I still need to be cautious about it. Also I need to need to know the reason of this alert arising and if this comes again then what are 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(166.4, 9%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOB%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
slow query on large data
Hi there, --3billion rows of accumulated data over a period of time CREATE TABLE [dbo].[large_accumulation_table]( [amt] float(24) NULL, [lastdate] smalldatetime NULL, [type] [varchar](8) NULL, [doc1] [int] NULL, [line1] [smallint] NULL, [type1]…
asked 2024-12-19T18:50:52.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(272, 69%, 36%)' 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)
RJ
186
Reputation points
commented 2024-12-20T22:31:25.0833333+00:00
Erland Sommarskog
114.6K
Reputation points MVP
2 answers
Moving Data From Oracle SQL to Azure SQL Dynamically
Hi All, @{activity('GetTableColumns').output.value[0].ColumnNames} - This line reading my columns from the lookup activity successfully when I try move data from MS SQL(Source) to Azure SQL Databases(Destination). But it's reading the columns from the…
asked 2024-12-19T19:02:46.3766667+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, 52%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
Ramesh, Harish
0
Reputation points
answered 2024-12-19T19:34:37.0866667+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, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
phemanth
12,575
Reputation points Microsoft Vendor
2 answers
Assistance Needed: Error Setting Up Azure Linked Service for On-Premises SQL Server
Hi, I am trying to set up an Azure Linked Service to connect to an on-premises SQL Server. I attempted to use the SQL Server connector but encountered an error. I have attached the error details for your reference. The settings I used are as follows: …
asked 2024-12-13T16:13:09.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(195.2, 24%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHA%3C/text%3E%3C/svg%3E)
Harikrishnan Arayakeel
20
Reputation points
commented 2024-12-19T19:00:25.61+00:00
Sai Raghunadh M
1,605
Reputation points Microsoft Vendor
1 answer
Misdelete table in Azure Database
Hello, I deleted a table in Azure SQL Database, how can I restore the deleted table?
asked 2024-12-17T10:27:01.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(25.6, 50%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Andrew Haning
0
Reputation points
commented 2024-12-19T18:35:38.2066667+00:00
NIKHILA NETHIKUNTA
3,920
Reputation points Microsoft Vendor