Kunal Rathi, Author at AzureOps

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.

Connect Python Azure Function to Azure SQL Using Managed Identity

Azure, Function, Managed Identity, Python

An Azure Function is a lightweight, serverless compute option in Azure that lets you execute small chunks of code in response to events or schedules without managing servers. When connecting Azure Functions to Azure SQL Database, you need a secure way to authenticate without storing credentials. That’s where Managed Identity steps in. Managed Identity allows […]

Connect Python Azure Function to Azure SQL Using Managed Identity Read More »

Data Agent in Microsoft Fabric – Here’s How it Works

AI, Microsoft Fabric

In this post, I’ll walk you through how I built a Fabric Data Agent on top of the standard AdventureWorksDW dataset (via shortcuts), and how you can too — even if you’re a complete beginner.

Data Agent in Microsoft Fabric – Here’s How it Works Read More »

SSMS 21 Copilot: Here’s How It Works

AI, Azure, Microsoft Copilot, SQL Database

SQL Server Management Studio (SSMS) version 21 introduces native Copilot integration, enhancing SQL development. Users can connect to Azure OpenAI for efficient query generation and debugging in read-only mode. Copilot aids in writing, fixing, and optimizing SQL queries without executing modifications, ensuring control and security over data.

SSMS 21 Copilot: Here’s How It Works Read More »

Cross Database Query in Azure SQL Database

Azure, SQL Database, SQL Server

In modern cloud architectures, it’s common to distribute data across multiple Azure SQL Databases. While this promotes modularity and scalability, it can pose challenges when you need to access data across these databases. Fortunately, Azure SQL’s external tables feature allows for seamless cross-database querying without data duplication. This feature is also known as Elastic Query

Cross Database Query in Azure SQL Database Read More »

Azure Analysis Services Model Missing

Analysis Services, Azure

In this article, we will see how to fix Azure Analysis Services model missing issue.

Azure Analysis Services Model Missing Read More »

CS2001 Missing AssemblyAttributes.cs when executing SSIS package deployed to the server

Microsoft BI, SQL Server, SSIS

How to resolve error : CS2001 Missing AssemblyAttributes.cs when executing SSIS package deployed to the server.

CS2001 Missing AssemblyAttributes.cs when executing SSIS package deployed to the server Read More »

The specified provider is not supported. Please choose different provider in connection manager SSIS

Microsoft BI, 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:

The specified provider is not supported. Please choose different provider in connection manager SSIS Read More »

Deploy DACPAC to Azure SQL Database

Azure, DevOps, SQL Database, SQL Server

This guide will walk you through the process of deploy DACPAC to Azure SQL database directly from Visual Studio.

Deploy DACPAC to Azure SQL Database Read More »

Create Python Azure function in Visual Studio Code

Azure, Function, Python

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 supports various programming languages, including .NET, Python, JavaScript, TypeScript, Java, PowerShell, and C#, providing flexibility and versatility for various applications. This article describes how to create Python Azure function in

Create Python Azure function in Visual Studio Code Read More »

Parse JSON in SQL Server

Azure, SQL Database, 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 of JSON’s popularity, SQL Server introduced built-in support for JSON starting with SQL Server 2016. In this article, we will explore how to parse JSON in SQL Server and extract

Parse JSON in SQL Server Read More »

Cookie	Duration	Description
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.