5,400 questions with Azure SQL Database tags

Sort by: Updated
1 answer

How we can use Aggregate Functions on Encrypted Table Columns?

I have an Encrypted Table column (i.e., Deterministic ). Can we apply Aggregate Function on this column in Azure SQL Database.

Azure SQL Database
asked 2024-06-27T09:47:50.1066667+00:00
Khwaza Bandenawaz Sikkalagar 0 Reputation points
commented 2024-07-01T16:38:57.02+00:00
Oury Ba-MSFT 17,791 Reputation points Microsoft Employee
2 answers

Azure Data Factory - Azure SQL connectivity error : Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access

Hi I am trying to import data from onprem SQL server database to Azure SQL databases through Azure Data Factor(ADF) Copy activity , this worked for more than a year with no problems ,till few weeks back when I got the error below. I got a workaround it…

Azure SQL Database
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,612 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,120 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,349 questions
asked 2024-06-24T13:30:39.4533333+00:00
Mfundo Potolwana 0 Reputation points
answered 2024-07-01T08:49:18.93+00:00
Pinaki Ghatak 3,110 Reputation points Microsoft Employee
0 answers

I selected Storage Auto-growth option for my postgresql flexible server and then I restarted the server and since then the server is in 'restarting' state for 24 hours.

My Azure Postgresql Flexible Server has reached its storage limit, so I selected the Storage Auto-growth option. After 15 minutes nothing changed and I restarted the server. Since then, the server has been in 'restarting' state for 24 hours. Type of…

Azure SQL Database
Azure Database for PostgreSQL
asked 2024-06-21T10:11:48.0633333+00:00
Cosmin Robert Lungu 0 Reputation points
commented 2024-07-01T06:06:53.23+00:00
ShaktiSingh-MSFT 14,376 Reputation points Microsoft Employee
0 answers

Azure Data Factory executes stored procedure twice (and concurrently)

I have an ADF pipeline executing a stored procedure on an Azure SQL database. Retries is set to 0, so this procedure should be executed exactly once. Now it turns out that it sometimes executes twice, i.e. a second time when the first execution is…

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,120 questions
asked 2024-06-26T14:40:32.42+00:00
Matthias Delafontaine 16 Reputation points
commented 2024-07-01T03:54:13.1433333+00:00
Harishga 5,910 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

Renewal for My Microsoft Certified

Hi Microsoft, I have certification Azure Database Administrator Associate but at 26 may 2024 I need to renewal this certification. i forget to renewal and now i check my account, I didn't find it in my account. what should i do for renewal this…

Azure SQL Database
asked 2024-06-28T02:25:19.8433333+00:00
Farid Adam Abdillah 20 Reputation points
accepted 2024-06-30T16:04:49.1033333+00:00
Farid Adam Abdillah 20 Reputation points
1 answer

Transcript Not Sowing Exam Passed May 9, 2024

When logged in here I can see Exam titleExam numberPassed dateAdministering Microsoft Azure SQL SolutionsDP-300May 9, 2024Administering Microsoft Azure SQL SolutionsDP-300May 9, 2024But the anonymous validation does not show it            …

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,306 questions
asked 2024-06-27T15:16:51.19+00:00
REGAN WICK 0 Reputation points
answered 2024-06-28T18:09:41.3033333+00:00
GeethaThatipatri-MSFT 29,012 Reputation points Microsoft Employee
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, …

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,306 questions
asked 2024-06-26T21:37:52.4866667+00:00
priyanka 0 Reputation points
answered 2024-06-28T15:12:12.3233333+00:00
Oury Ba-MSFT 17,791 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…

Azure SQL Database
asked 2023-11-06T05:07:09.0933333+00:00
Riyaz Barkatali Budhwani 5 Reputation points
commented 2024-06-28T09:10:16.45+00:00
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…

Azure SQL Database
Windows Server 2016
Windows Server 2016
A Microsoft server operating system that supports enterprise-level management updated to data storage.
2,429 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.
13,306 questions
asked 2024-06-26T07:05:47.3666667+00:00
Aakash CK(P) 0 Reputation points
answered 2024-06-28T08:06:18.3633333+00:00
Neuvi Jiang 690 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…

Azure SQL Database
asked 2024-06-27T19:42:19.0566667+00:00
Cherise D Woods 1 Reputation point
edited the question 2024-06-28T03:31:53.94+00:00
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…

Azure SQL Database
asked 2024-06-20T12:33:47.4633333+00:00
Phong Nguyen (DA) 10 Reputation points
commented 2024-06-27T16:56:49.8733333+00:00
Oury Ba-MSFT 17,791 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…

Azure SQL Database
asked 2024-06-20T13:47:18.2533333+00:00
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

Azure SQL Database
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,349 questions
asked 2024-06-14T04:05:45.4566667+00:00
Ashraf Khan 20 Reputation points
commented 2024-06-27T09:19:16.4833333+00:00
Srinud 2,040 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 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,667 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,866 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,520 questions
asked 2024-06-24T16:16:33.29+00:00
Nagesh CL 641 Reputation points
answered 2024-06-27T06:31:15+00:00
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

Azure SQL Database
asked 2022-05-24T13:12:23.947+00:00
Raj0125 511 Reputation points
edited an answer 2024-06-26T21:46:34.8366667+00:00
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.

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,120 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,248 questions
asked 2024-04-15T07:24:19.01+00:00
heta desai 247 Reputation points
commented 2024-06-26T07:38:48.41+00:00
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…

Azure SQL Database
asked 2024-06-25T19:05:53.48+00:00
Fanny Lööf 0 Reputation points
answered 2024-06-26T06:15:14.3133333+00:00
Nandan Hegde 31,346 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…

Azure SQL Database
Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,329 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,612 questions
asked 2024-06-14T06:21:40.3633333+00:00
Sham 0 Reputation points
commented 2024-06-26T05:46:46.77+00:00
Mahesh Goud Juvvadi 935 Reputation points Microsoft Vendor
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…

Azure SQL Database
Azure Static Web Apps
Azure Static Web Apps
An Azure service that provides streamlined full-stack web app development.
843 questions
asked 2024-06-04T19:10:40.2733333+00:00
Mattias Clouse 0 Reputation points
commented 2024-06-25T19:41:45.19+00:00
Oury Ba-MSFT 17,791 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…

Azure SQL Database
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,541 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.
13,306 questions
Active Directory
Active Directory
A set of directory-based technologies included in Windows Server.
6,208 questions
asked 2023-05-09T05:17:22.2266667+00:00
Bikram Sana 5 Reputation points
commented 2024-06-25T18:50:42.32+00:00
Tarek Salha 1 Reputation point