Azure SQL Database
An Azure relational database service.
5,943 questions
0 answers
High compute at 3 AM without any manually configured jobs
Hi, Recently I set up an Azure SQL database, with hardly any data in it. Current used space is 25 MB, so nothing much. However, every morning around 3 AM, I see CPU percentage going up, without any activity that I am aware of. I did not configure any…
asked 2025-01-27T06:21:11.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(9.6, 43%, 10%)' 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)
Johan Beemsterboer
0
Reputation points
asked 2025-01-27T06:21:11.5133333+00:00
Johan Beemsterboer
0
Reputation points
0 answers
SqlPackage Parameter `/p:RestoreSequenceCurrentValue` Not Working in Azure DevOps Release Pipeline
Hi, An Azure DevOps release pipeline is being used to deploy a DACPAC to an Azure SQL Database using the Azure SQL Database deployment task (version 1.*). To maintain the existing sequence current value, the parameter /p:RestoreSequenceCurrentValue=False…
asked 2025-01-27T05:48:33.0633333+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(304, 42%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
Vinci Poon
1
Reputation point
asked 2025-01-27T05:48:33.0633333+00:00
Vinci Poon
1
Reputation point
2 answers
Connect Fabric warehouse in Azure Sql server
I need assistance with querying a Microsoft Fabric Warehouse using Azure SQL Server. I want to perform join operations between tables in Azure SQL Database and Fabric Warehouse. I have explored options such as linked servers however it doesn't support,…
asked 2024-07-12T09:19:29.8166667+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, 5%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Chandu R
5
Reputation points
edited the question 2025-01-27T04:29:09.1733333+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, 16%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
Rakesh Gurram
11,475
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Connect to an Azure SQL server from Microsoft Fabric
I am trying to connect to an Azure SQL server using Dataflows on Fabric, however whenever I try connect i get the error "Reason: An instance-specific error occurred while establishing a connection to SQL Server. Connection was denied since Deny…
asked 2024-07-23T11:07:09.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(115.19999999999999, 21%, 21%)' 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)
Mcmahon, Amy [GPSIE NON-J&J]
20
Reputation points
edited the question 2025-01-27T04:28:51.7966667+00:00
Rakesh Gurram
11,475
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
How to figure out the total number of doses within a time span given to a client as dose are being added and stopped.?
If the cadence values are different, even if the dates overlap the records must be separate. If an order for the same dose and cadence value (including nulls) starts on the same day or the next day (+or-1 day) the record should continue. outlook of…
asked 2024-07-22T22:24:04.8633333+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(278.4, 2%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAO%3C/text%3E%3C/svg%3E)
andrew omofonma
61
Reputation points
edited the question 2025-01-27T04:28:08.7933333+00:00
Rakesh Gurram
11,475
Reputation points Microsoft Vendor
2 answers
Request for clarification on Serverless Compute for DTU and vCore Models for Azure SQL Database and Azure SQL Managed Instance
While researching on Serverless options for Azure SQL Database I came across a link that provides some insight, but I am still not able to follow. What service tier in vCPU AND DTU models support it. Additionally whether it is supported in Azure SQL…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,943 questions
Azure Training
Azure Training
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Training: Instruction to develop new skills.
1,985 questions
![](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, 74%, 40%)' 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)
![](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, 2%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
0 answers
I am integrating the dataflow activity which removes duplicates from the csv file to the existing pipeline i have. I need a help to configure the parameters.
I created a dataflow activity which removes duplicates from the source files( csv formatted files). So now i integrated this dataflow activity to existing pipeline i have. but i am not able to parametrize the source files. It would be helpful if i get…
asked 2025-01-24T08:02:14.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, 37%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Lakshmi Moulya Nerella
0
Reputation points
commented 2025-01-27T03:23:04.06+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
13,150
Reputation points Microsoft Vendor
1 answer
How to get more details(user, execution time, IP address) for a given query ID on Azure SQL DB
How can I get all the details(user, execution time, IP address, etc) for a given Query ID? I am using Azure SQL DB
asked 2025-01-21T16:35:40.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(70.4, 54%, 16%)' 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)
MikeZheng-3371
46
Reputation points
commented 2025-01-27T02:56:52.1633333+00:00
MikeZheng-3371
46
Reputation points
1 answer
How to download payloads from Azure Cosmos DB efficiently?
I need help figuring out how to download specific payloads from Azure Cosmos DB efficiently. While exploring the Azure interface, I noticed an option to delete data, but I couldn’t find a straightforward way to download it. For example, I want to…
asked 2025-01-23T09:15:43.25+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, 39%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
crynos_001
0
Reputation points
commented 2025-01-27T02:50:47.9+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,915
Reputation points Microsoft Vendor
1 answer
Unable to connect azure SQL with r2dbc spring boot using AD group authentication
I am trying to connect with azure sql instance using AD group authentication with my spring boot reactive application using r2dbc but it seems there is no way to custom initialize the ConnectionFactory bean in configuration so that I can paas the AD…
asked 2025-01-24T04:45:36.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(89.60000000000001, 10%, 18%)' 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)
Vaibhav Kumar Singh
0
Reputation points
commented 2025-01-26T22:43:37.6633333+00:00
Vaibhav Kumar Singh
0
Reputation points
1 answer
Azure sql database taking empty space and not freeing them
My DB size is 1.2 GB something and it only has two tables with 18 and 16 rows respectively with no indexes. I used SHRINKDATABASE and the size reduced to 66MB !!! This is a significant size decrease. I am trying to understand what might be the…
asked 2025-01-24T13:55:14.0633333+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, 0%, 14%)' 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
0
Reputation points
commented 2025-01-26T10:59:27.5333333+00:00
Erland Sommarskog
116K
Reputation points MVP
3 answers
One of the answers was accepted by the question author.
Run SQL Statements Parallel within a SP
Hi there, Is there a way to run SQL Statements in parallel within the same SP? Thanks for your time. CREATE PROCEDURE CustomerPARALLEL AS BEGIN EXEC DBO.CUST1 - TAKES 20 MINS (INDEPENDENT) EXEC DBO.CUST2 - (TAKES 20 MINS (NO DEPENDENCY)) HOW TO…
asked 2025-01-22T18:28:57.0533333+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
266
Reputation points
answered 2025-01-25T22:29:15.7166667+00:00
Erland Sommarskog
116K
Reputation points MVP
10 answers
One of the answers was accepted by the question author.
Microsoft SQL Server Studio - Dark Mode
Is there any official method to use Microsoft SQL Server Management Studio Studio with Dark Mode?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,943 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,378 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.
14,374 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,682 questions
asked 2023-12-19T13:11:52.4966667+00:00
Kıvanç ÖZDEMİR
135
Reputation points
answered 2025-01-25T19:04:25.2733333+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(0, 70%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Joshua Moonstar
0
Reputation points
1 answer
Azure SQL Database - on master - long execution of a query program TdService
On Azure SQL Database in Azure there is a really long query running (many days). The details: database_name master program_name TdService It looks like a bug from an Azure SQL Service. On diagnostics while trying to send a support ticket: The…
asked 2025-01-13T14:30:08.76+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, 69%, 11%)' 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)
RaTheMigthy
0
Reputation points
commented 2025-01-25T14:53:31.4+00:00
RaTheMigthy
0
Reputation points
1 answer
How can I locally develop my Spring Boot application against an Azure SQL DB using passwordless connections?
According to the documentation, the passwordless option is only for the hosted environment. This creates a challenge for developing locally because the authentication mechanism is different. How do I set up my local development so that it works 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(76.8, 97%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
1 answer
Export Managed Instance Databases to archive blob storage to another Tenant
Hello, I would like to export some of my azure managed instance databases from one of my tenants to archive blob storage in a completely another new tenant. How can I achieve this goal? Any helpful information or website links will be highly…
asked 2025-01-21T15:33:22.6933333+00:00
Islam, MD Ashikul
0
Reputation points
commented 2025-01-24T16:08:42.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(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
4,425
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
How to reach support regarding a payment
I have a problem with a billing and could only ask for a refund for one of them. I want to speak or send an email to the support but doesn't have any clue how, because this can't be solved with their automatic process for refunding. Anyone know how…
asked 2025-01-24T10:38:26.5766667+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, 30%, 33%)' 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)
Kevin Kallin
20
Reputation points
commented 2025-01-24T12:15:26+00:00
Kevin Kallin
20
Reputation points
1 answer
One of the answers was accepted by the question author.
My Azure Data factory copy activities are failing that grab the data from REST api and Azure storage from US WEST region, linked service connection failing. how to resolve this issue?
I am using ADF to get REST API data and move it to azure sql db and also moving data from blob storage to sql db. in both the cases pipeline status is Queue/ in Progress. linked service is failed to connect and timeout issue. please let me know how long…
asked 2025-01-15T22:50:44.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(3.2, 37%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Swapna Nelanti
25
Reputation points
accepted 2025-01-24T00:43:59.7666667+00:00
Swapna Nelanti
25
Reputation points
1 answer
Lanencia alta ao fazer conexão com Azure
Boa tarde, fizemos a migração de um banco de dados para o Azure e temos um problema: Latência de cinco minutos para abrir uma tabela específica do banco de dados SQL Server 16.0.5688 tanto na rede de desenvolvimento quanto na rede de produção. As…
asked 2025-01-21T18:10:11.1033333+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, 5%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Sergio Giudicelli
0
Reputation points
commented 2025-01-23T22:18:36.7266667+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
2,095
Reputation points Microsoft Vendor
2 answers
Issue with Creating Linked Server from Azure SQL Managed Instance to On-Premises SQL Server
Hi, Interestingly, I was able to create a linked server in the reverse direction—from the on-premises SQL Server to my Azure SQL MI—using a remote login and password for authentication. However, when I attempt to establish the link from Azure SQL MI to…
![](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, 15%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)