How to Delete Stale Delta Files in Microsoft Fabric Lakehouse
This article describes how to delete delta files from fabric lakehouse using python code and also using manual steps.
Automate Databricks Infrastructure as Code with Terraform
This article describes how to Implement Infrastructure as Code Databricks with Terraform.
CS2001 Missing AssemblyAttributes.cs when executing SSIS package deployed to the server
How to resolve error : CS2001 Missing AssemblyAttributes.cs when executing SSIS package deployed to the server.
The specified provider is not supported. Please choose different provider in connection manager SSIS
If you encounter an error in SQL Server Data Tools (SSDT) for Visual Studio while working with SQL Server Integration Services (SSIS), it could be due to the missing OLE DB or ADO.NET provider on your machine. This missing component prevents SSIS from establishing a connection, leading to the following error message:
Deploy DACPAC to Azure SQL Database
This guide will walk you through the process of deploy DACPAC to Azure SQL database directly from Visual Studio.
SQL Server 2025 Preview Announced
Microsoft has announced SQL Server 2025 preview, marking a significant advancement in database technology by integrating AI capabilities
Create Python Azure function in Visual Studio Code
Azure Functions is a serverless computing service that enables developers to deploy small pieces of code without the need to manage the underlying infrastructure. It
Parse JSON in SQL Server
JSON (JavaScript Object Notation) is a lightweight data-interchange format that has become a standard for data exchange in web and database applications. With the rise
Databricks VACUUM Command
Databricks is a unified big data processing and analytics cloud platform for transforming and processing vast volumes of data. Apache Spark is the building block
A project which specifies SQL Server 2022 or Azure SQL Database Managed Instance as the target platform cannot be published to Microsoft Azure SQL Database v12.
While deploying a DACPAC project to Azure SQL Database using Azure DevOps, you may encounter an error due to specifying SQL Server 2022 as the target platform. The article provides steps to fix this issue by changing the target platform to ‘Microsoft Azure SQL Database’ in Visual Studio and rebuilding the project.
Find Long Running Queries in Azure SQL Database
This post describes how to find long running queries in Azure SQL Database using dynamic management view query.
Create user assigned managed identity in Azure
Managed identity in Azure simplifies access management by automatically associating service principals with resources, like creating apps in Microsoft Entra when setting up a data factory. It facilitates secure access to Azure SQL without managing credentials, supporting Azure AD authentication at no extra cost. Azure offers both system-assigned and user-assigned managed identities, with the latter being customizable in the Azure portal. This technique enhances security and ease of management in Azure environments.