Azure SQL Database
An Azure relational database service.
5,425 questions
1 answer
Impact of Increasing Storage and Cores for Azure SQL Database in Business Critical Tier
Hi Team, What is the impact of maximum storage size for Azure SQL Database within the Business Critical service tier. we are currently using a Business Critical configuration with 8 cores and 2TB of storage, and plan to increase it to 12 cores and 2.5TB…
asked 2024-07-12T17:42:26.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(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
9,176
Reputation points Microsoft Employee
edited an answer 2024-07-16T15:58:38.16+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
1 answer
Issues with mi IP address
Hi guys. I am doing a course about Azure and I was checking the section to connect a Blob Storage to SQL Database. When I was setting up my Firewall rules, the first issue I found was that Azure didn't recognize my IPv4 but IPv6 instead so I have to…
asked 2024-07-15T07:53:30.32+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, 16%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Reinaldo Munoz
0
Reputation points
commented 2024-07-16T09:00:12.8166667+00:00
AnnuKumari-MSFT
32,011
Reputation points Microsoft Employee
1 answer
Failed to save 'sql servers on machines' plan for subsribtion 'N/A'
Trying to turn off Azure Defender for Cloud but have error: How to do it successfully ?
![](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, 69%, 22%)' 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)
1 answer
One of the answers was accepted by the question author.
Workday and alternative
Hi, I have a table which needs to duplicate with weekday and alternative create table table3 ( col1 varchar(20) , col2 varchar(20)) expected results Insert into table1 values('catch', 'catch1') …
![](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, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
1 answer
How to replace Data flow activity having transformations inside it in ADF with other activity.
I have Azure data factory pipeline which have data flow activity. Data flow activity points to source file in storage account gets data from it as a source then performs different transformations on data using conditional split, derived column, flatten…
asked 2024-07-11T20:07:42.1866667+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(67.2, 12%, 16%)' 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)
Rahi Jangle
0
Reputation points
commented 2024-07-16T05:32:45.37+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, 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)
Harishga
5,910
Reputation points Microsoft Vendor
0 answers
Microsoft Applied Skill 4 - Failure to create Databases 1-4
While attempting the "Migrate SQL Server Workloads to Azure SQL Database" it failed to create Databases: DB1, DB2, DB3, and DB4. While DB5 was a partial. Has anyone else had this happen to them? What steps have you taken to resolve this…
asked 2024-07-14T02:43:10.5333333+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, 92%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jacob Shuster
0
Reputation points
commented 2024-07-16T04:53: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(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
14,386
Reputation points Microsoft Employee
2 answers
sp_invoke_external_rest_endpoint returns json parse error on @response
i am running azure sql and call various MS graph and external rest endpoint via Azure API manager using the sp_invoke_external_rest_endpoint procedure. On 1 instance calling the proc, I get the following error returned: Msg 11558, Level 16, State 202,…
![](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(291.2, 65%, 38%)' 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)
1 answer
One of the answers was accepted by the question author.
how to add user assigned managed identify in azure sql database using powershell?
how to add user assigned managed identify in azure sql database using powershell? I tried two methods as follow and they didn't work. 1.add parameter userassignedidentityid when create az sql database . # Create Azure SQL Database $databaseName =…
asked 2024-07-12T08:21:12.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(70.4, 63%, 16%)' 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)
Brian D H ZHANG
20
Reputation points
accepted 2024-07-15T06:11:29.14+00:00
Brian D H ZHANG
20
Reputation points
4 answers
One of the answers was accepted by the question author.
How to install SQLPackage and Powershell on Windows Azure Agent
Hello, I have a windows Azure Agent which has been setup by our Azure Admin team. The agent does not have the SQLPackage and Powershell installed on it which is required for SQL DACPAC file generation. As part of my release pipeline I am using a…
asked 2022-04-18T14:15:04.397+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, 0%, 35%)' 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)
sachin gupta
376
Reputation points
edited a comment 2024-07-15T05:03:24.1166667+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(316.8, 23%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Raw Milk Dubai
0
Reputation points
2 answers
Getting Azure Synapse Analitics Tables Size - Query on documentation does not return correct data
Hello, I've a Synapase Workspace with a Sql Pool that has a SQL Server version 12.0.2000 . My requirement is to get the phisical space storage for each table in my database. Many peoples pointed me at…
asked 2023-03-20T14:37:18.55+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, 44%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFN%3C/text%3E%3C/svg%3E)
F N
20
Reputation points
commented 2024-07-14T13:03:04.0166667+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(51.2, 88%, 14%)' 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)
Sharma, Rahul
80
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure SQL Managed Instance Scaling Both Primary & Secondary
I have two SQL Managed Instances, one is using it as the primary and the other one is for secondary-geo replication . At the moment both of them have the same specs (Service Tier - Hardware Generation- vCore - Storage), I would like the scale up the…
asked 2024-07-11T22:22:43.0366667+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(281.6, 37%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
ِAhmed Barahim
20
Reputation points
accepted 2024-07-13T14:31:13.61+00:00
ِAhmed Barahim
20
Reputation points
1 answer
One of the answers was accepted by the question author.
Delete data from an Azure SQL database after copyingit to an Azure Blob
How can I create a pipeline in ADF to delete data from an Azure SQL database after copying it to an Azure Blob, without using the copy or lookup activities to execute the query? I need to create a view and perform some activity. Is there a custom method…
![](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, 45%, 39%)' 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)
2 answers
System Database Backups for Azure SQL Managed Instance
I don't see the ability to backup system databases for Azure SQL Managed Instance. If the server was lost I would lose server logins, backup information. Is there any documentation regarding why we don't have to backup these databases, and the steps we…
asked 2024-06-21T20:35:16.1766667+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, 1%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECJ%3C/text%3E%3C/svg%3E)
Chancellor, Joe
0
Reputation points
answered 2024-07-13T00:10:36.53+00:00
Chancellor, Joe
0
Reputation points
1 answer
Retention period for various DMVs such as sys.dm_db_resource_stats, sys.dm_os_wait_stats
I want to understand retention period for various DMVs (Dynamic Management Views). I specifically want to know the retention period for DMVs such as sys.dm_db_resource_stats, sys.dm_os_wait_stats, sys.dm_database_replica_states,…
asked 2024-07-12T17:45:45.6966667+00:00
Rahul Randive
9,176
Reputation points Microsoft Employee
answered 2024-07-12T17:59:21.6066667+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
2 answers
"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."
One of the users receive this error. is this issue at our end or at microsofts ?
asked 2023-10-25T20:03:28.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(64, 5%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZA%3C/text%3E%3C/svg%3E)
zubaid ahmed
0
Reputation points
commented 2024-07-12T13:19:50.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(300.8, 17%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGR%3C/text%3E%3C/svg%3E)
Goede, Rhonda
0
Reputation points
3 answers
Unable to Restore SQL MI Database by SSMS
Hi team, I backed up an Azure Arc-enabled SQL Managed Instance database using SSMS to an Azure blob. However, when I try to restore it, I encounter the following error: "Restore of database 'restorebook' failed.…
![](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, 21%, 19%)' 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)
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
answered 2024-07-12T09:27:44.57+00:00
ShaktiSingh-MSFT
14,386
Reputation points Microsoft Employee
1 answer
SSMS slow connecting to Azure SQL
I am running MS SQL 2019 on Azure and using SSMS from my laptop. It was slow running SSMS from my laptop. Did i missed something to have a good speed running SSMS connecting to Azure SQL.? Appreciate that assistance.
asked 2024-07-10T07:24:25.81+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, 1%, 33%)' 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)
Ahmad Hazari Haris
0
Reputation points
commented 2024-07-12T05:32:27.03+00:00
ShaktiSingh-MSFT
14,386
Reputation points Microsoft Employee
3 answers
Will I get charged for azure sql server
Hi, please help me out, I'm so confused here. I made a free account with Azure to use azure sql server and database. So far I haven't been charged, but 30 days are up and my subscription expired but my server and database are still showing as available.…
![](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(140.8, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMC%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(156.8, 57.99999999999999%, 25%)' 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)
1 answer
A connection was successfully established with the server, but then an error occurred during the pre-login handshake
Hi all; I have my app running on Azure App Server and it talks via Entity Framework to Azure SQL Database. Both are in the same datacenter. This has all been running fine for months. But today, after connecting it up to Application Insights, I sometimes…
asked 2024-07-11T22:14:22.02+00:00
David Thielen
2,796
Reputation points
edited an answer 2024-07-12T02:43:55.2+00:00
Alberto Morillo
33,426
Reputation points MVP