Azure SQL Database
An Azure relational database service.
5,348 questions
1 answer
Find all the path between two nodes of Azure SQL database
I wan to get columns from association table in SELECT caluse , Is there any other way around for this? SELECT subgraph, subgraph as name, Typecode,aid,nbr FROM ( SELECT i1.Typecode AS Typecode, i1.ID AS aid, i1.Number AS nbr, …
asked 2024-06-26T21:37:52.4866667+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, 9%, 40%)' 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)
priyanka
0
Reputation points
answered 2024-06-28T15:12:12.3233333+00:00
Oury Ba-MSFT
17,631
Reputation points Microsoft Employee
1 answer
Stored Proc outputs differ between SQL Server and Azure SQL DB
We have an om-prem data warehouse and are looking to migrate to Azure cloud. We've provisioned the Azure SQL serverless database and done a lift and shift on the stored procs. We are copying source data from SQL server database to Azure SQL and executing…
asked 2023-11-06T05:07:09.0933333+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(204.8, 4%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Riyaz Barkatali Budhwani
5
Reputation points
commented 2024-06-28T09:10:16.45+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, 42%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC9%3C/text%3E%3C/svg%3E)
CherylLee-9314
0
Reputation points
2 answers
Rollback plan for migration from on-prem SQL server 2016(2 node AG Cluster) to Azure SQL MI Business Critical
Hi, Actually migrating from on-prem SQL server 2016(2 node AG cluster) on Window 2019 Server to Azure SQL Managed Instance Business Critical node. Configured DMS replication and syncing the db, will do until the cutover. This process includes upload of…
asked 2024-06-26T07:05:47.3666667+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, 35%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Aakash CK(P)
0
Reputation points
answered 2024-06-28T08:06:18.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(134.4, 83%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENJ%3C/text%3E%3C/svg%3E)
Neuvi Jiang
545
Reputation points Microsoft Vendor
1 answer
Azure SQL VM Backup Automation Change
I have an Azure SQL VM and it is running automated backup of user databases every 5 minutes. I can't seem to identify where the automation is running from only see Managed Backup and it runs and saves to Azure storage account. No disaster recovery is…
asked 2024-06-27T19:42:19.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(80, 34%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Cherise D Woods
1
Reputation point
edited the question 2024-06-28T03:31:53.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(233.6, 46%, 32%)' 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)
ManoharLakkoju
690
Reputation points Microsoft Vendor
2 answers
Update your scripts to point to a new folder for Server level audit logs
I received this notice from MS and I logged int my Azure portal looking for this but unable to locate. Where can I find this to update the required information? You're receiving this notice because you use Azure SQL Database Server Audit. In February…
asked 2024-06-20T12:33:47.4633333+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(275.2, 89%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPN%3C/text%3E%3C/svg%3E)
Phong Nguyen (DA)
10
Reputation points
commented 2024-06-27T16:56:49.8733333+00:00
Oury Ba-MSFT
17,631
Reputation points Microsoft Employee
0 answers
Azure SQL Managed Instance - Unable to create Symmetric key and Certificate for Microsoft Entra Service Principles and Azure Active Directory Integrated authentication
Hi Team, I am working on Azure SQL Managed Instance and trying to run the SQL statement below from the SQL server with Microsoft Entra Service Principles authentication in the Azure Managed Instance environment but getting an error - 'Cannot find the…
asked 2024-06-20T13:47:18.2533333+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(80, 77%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Abhishek Modi (amodi)
0
Reputation points
commented 2024-06-27T14:55:29.03+00:00
Abhishek Modi (amodi)
0
Reputation points
1 answer
I have migrated database and web app to azure and done the proper connection string as well but in my code which I have published All the Images in web app in UI are not showing because it is hard code and given the path of C: Drive
No Images are showing in my app service but while running in IIS server its working proper in visual studio
asked 2024-06-14T04:05:45.4566667+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
0
Reputation points
commented 2024-06-27T09:19:16.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(313.6, 35%, 40%)' 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)
Srinud
1,965
Reputation points Microsoft Vendor
3 answers
VS2017 - SSIS Project
Hello Team, We are using VS2017 with SSDT installed (PFB the screenshot) We cannot find BI projects, unable to create SSIS projects. Please advice. Regards, Nagesh CL
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,348 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,630 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,830 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,503 questions
asked 2024-06-24T16:16:33.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(179.20000000000002, 53%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
Nagesh CL
641
Reputation points
answered 2024-06-27T06:31:15+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, 84%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
Praveen Kumar Tummalapati
0
Reputation points
2 answers
One of the answers was accepted by the question author.
How to get list of Tables and count of rows from table
Hi, How to get list of Tables and count of rows from table by writing single Query. Expected O/P as below
asked 2022-05-24T13:12:23.947+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(217.60000000000002, 3%, 31%)' 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)
Raj0125
511
Reputation points
edited an answer 2024-06-26T21:46:34.8366667+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, 10%, 12%)' 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)
Sreedhar V
0
Reputation points
3 answers
How to read excel document from sharepoint directly dump it in Azure SQL using Azure data factory ?
I want to access excel document from SharePoint and without downloading that to data lake or blob storage, use data factory to read the content of it and directly dump it in Azure SQL.
asked 2024-04-15T07:24:19.01+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(297.6, 52%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHD%3C/text%3E%3C/svg%3E)
heta desai
247
Reputation points
commented 2024-06-26T07:38:48.41+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(108.80000000000001, 53%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDL%3C/text%3E%3C/svg%3E)
Dixan Lal Thomas
60
Reputation points
2 answers
Charging in the Azure portal
Hey! I'm trying this exercise but get charged for creating an Azure SQL database resource. Is there a way to explore azure without getting…
asked 2024-06-25T19:05:53.48+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, 83%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFL%3C/text%3E%3C/svg%3E)
Fanny Lööf
0
Reputation points
answered 2024-06-26T06:15:14.3133333+00:00
Nandan Hegde
30,871
Reputation points MVP
2 answers
Estimating Total Cost for Power BI Service with Azure Storage and SQL Database
Hi, I'm planning to use Power BI Service, and I understand that it is built on Azure, utilizing Azure Blob Storage for data uploads and Azure SQL Database for metadata storage. Could you help me estimate the total cost for these Azure services in…
asked 2024-06-14T06:21:40.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(169.60000000000002, 90%, 26%)' 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)
Sham
0
Reputation points
commented 2024-06-26T05:46:46.77+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(32, 3%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Mahesh Goud Juvvadi
930
Reputation points Microsoft Vendor
1 answer
Alerts in Managed instance
Hi I am looking at setting up alerts on the managed instance based of https://video2.skills-academy.com/en-us/sql/ssms/agent/create-an-alert-using-an-error-number?view=sql-server-ver16 where it states it applies to MI However I encounter error. I need to…
asked 2024-06-04T17:09:30.0833333+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
answered 2024-06-25T20:01:37.88+00:00
Oury Ba-MSFT
17,631
Reputation points Microsoft Employee
0 answers
Having issue fetching data from azure sql databse to satatic web app (error 400)
I am trying to create an application that displays my database that I have made in azure sql server. I have a swa-db-connections folder with my db entity along with my connection string and everythign else. in my workflow, I have api and data-api set to…
asked 2024-06-04T19:10:40.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(246.4, 65%, 33%)' 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)
Mattias Clouse
0
Reputation points
commented 2024-06-25T19:41:45.19+00:00
Oury Ba-MSFT
17,631
Reputation points Microsoft Employee
4 answers
How to fix the error: The transaction log for database is full due to 'log_backup'.
Hi Team, I am getting the below error: The transaction log for database is full due to 'log_backup'. Whereas SQL Always on Clustering has configured and for testing purpose we are monitoring for few days that is working or not properly even no…
asked 2023-05-09T05:17:22.2266667+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(76.8, 41%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bikram Sana
5
Reputation points
commented 2024-06-25T18:50:42.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(211.20000000000002, 40%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tarek Salha
1
Reputation point
2 answers
One of the answers was accepted by the question author.
Sql server Metrics : is 100% CPU percentage is a blocker for all DB operations?
HI All We have observed a case in our database where the CPU perncetage is 100% for quite some time but my application are still able to hit & operate over DB, is 100% CPU usage isnt a blocker for DB operations ?? I see 2 CPU metrics 1) CPU…
asked 2024-05-27T01:27:28.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(137.6, 91%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Manoj Mathe
20
Reputation points Microsoft Employee
accepted 2024-06-25T18:29:39.9366667+00:00
Manoj Mathe
20
Reputation points Microsoft Employee
3 answers
How to view new JSON data type in SSMS from Azure SQL?
I created a new Azure SQL database and used the Azure GUI to create a table with the new JSON data type (released May 2024). I then started the latest SSMS and connected to the Azure database. Next I tried to view the table design and received this…
asked 2024-06-25T17:50:32.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(67.2, 19%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBP%3C/text%3E%3C/svg%3E)
Brian Peal
0
Reputation points
answered 2024-06-25T18:29:23.78+00:00
Danish Gul Khattak
335
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
edited the question 2024-06-25T17:25:12.22+00:00
KapilAnanth-MSFT
39,461
Reputation points Microsoft Employee
2 answers
Accessing a SQL Server without going via VM
Good day Members I have connect using an IPSec to a on prem SQL DB(this is the only way). I can connect to the SQL DB in a VM. I have been using PowerBI and SSMS in the VM. I want to sink the data into an Azure SQL and use it without going via VM. I…
asked 2024-06-19T07:54:17.1+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, 23%, 19%)' 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)
StudentLearner
0
Reputation points
edited the question 2024-06-25T17:17:01.52+00:00
KapilAnanth-MSFT
39,461
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
I am being charged for a free Azure SQL Database which is free for 12 Months
Hi, I see that I am being charged for the use of MS SQL Server. I thought this service was free for 12 months. I believe I may have made a mistake while creating the database. Could you please assist me in identifying the problem and guide me on how to…
asked 2024-06-24T18:45:07.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(76.8, 11%, 17%)' 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)
alefleitas
20
Reputation points
edited an answer 2024-06-24T23:22:34.3533333+00:00
Oury Ba-MSFT
17,631
Reputation points Microsoft Employee