Author name: Kunal Rathi

With over 14 years of experience in data engineering and analytics, I've assisted countless clients in gaining valuable insights from their data. As a dedicated supporter of Data, Cloud and DevOps, I'm excited to connect with individuals who share my passion for this field. If my work resonates with you, we can talk and collaborate.

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 of Databricks, an in-memory analytics engine for big data and machine learning. In this article, we will see how to use the Databricks VACUUM command to remove unused files from […]

Databricks VACUUM Command Read More »

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.

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. Read More »

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.

Create user assigned managed identity in Azure Read More »

Create Elastic Jobs Using Azure Elastic Jobs Manager

Microsoft Azure offers Azure Elastic Job agent as a managed service, enabling efficient scheduling of T-SQL workloads on Azure SQL Databases. Similar to the SQL Server Agent job Wizard in SQL Server Management Studio, Azure Elastic Jobs Manager streamlines job deployment oversight with a Visual Studio extension, allowing seamless management from your desktop. This article demonstrates creating elastic jobs using Azure Elastic Jobs Manager, highlighting its resemblance to the SQL Server Agent job in management capabilities.

Create Elastic Jobs Using Azure Elastic Jobs Manager Read More »

Shopping Cart
Scroll to Top