Rahul Mehta

Author
Recent Posts

Rahul Mehta is a Software Architect with Capgemini focusing on cloud-enabled solutions. He works on various cloud-based technologies like AWS, Azure, and others.

He has worked internationally with Fortune 500 clients in various sectors and is a passionate author.

View all posts by Rahul Mehta

Finding Duplicates in SQL

February 7, 2024 by Rahul Mehta

This article will provide an understanding of identifying duplicate values in SQL.

MySQL substring uses with examples

October 14, 2023 by Rahul Mehta

This article will provide an understanding of different ways to use substring in MySQL.

MySQL group_concat() function overview

March 28, 2023 by Rahul Mehta

This article will provide an understanding of how to effectively use group concatenation in MySQL.

Introduction to SQL Escape

January 24, 2023 by Rahul Mehta

This article will provide an introduction to SQL escape characters for using special characters and their characteristics.

Python serverless functions to query Azure SQL DB

December 19, 2022 by Rahul Mehta

This article will show how to get data from Azure SQL in the Serverless Python app.

Control Retention of items using TTL in Azure Cosmos DB

November 30, 2022 by Rahul Mehta

This article will provide a detailed walkthrough for retaining items in Cosmos DB for different durations and on different levels.

Using Azure Purview to analyze Metadata Insights

April 5, 2021 by Rahul Mehta

In this article, we will learn how to explore the metadata registered in Azure Purview as well as learn how to analyze the metadata insights using the Purview Studio tool.

Cataloging metadata with Azure Purview

March 31, 2021 by Rahul Mehta

In this article, we will learn how to catalog metadata using the Azure Purview service.

Getting started with Azure Purview Studio

March 29, 2021 by Rahul Mehta

This article will get you started with Azure Purview Studio and the different facets associated with this tool.

Getting started with Azure Purview for Data Catalog and Governance

March 16, 2021 by Rahul Mehta

This article will show different features of Azure Purview as well as describe how to get started with this service on Azure.

Move local SSIS packages to Azure Data Factory

March 11, 2021 by Rahul Mehta

In this article, we will learn how to deploy SSIS packages which are typically built on developer workstations, to Azure Data Factory using Visual Studio and Data Tools.

Copy data into Azure Synapse Analytics using the COPY command

March 8, 2021 by Rahul Mehta

In this article, we will learn how to copy data from an external data source using the COPY command into a dedicated SQL pool of Azure Synapse Analytics.

Restore dedicated SQL pools in Azure Synapse Analytics

March 2, 2021 by Rahul Mehta

This article will walk you through the process of restoring dedicated SQL pools in Azure Synapse Analytics.

Analyze Azure Cosmos DB data using Azure Synapse Analytics

February 24, 2021 by Rahul Mehta

This article will help you understand how to analyze Azure Cosmos DB data using Azure Synapse Analytics.

Analyzing data hosted in Azure Cosmos DB with Notebooks

February 10, 2021 by Rahul Mehta

In this article, we will learn how to analyze data hosted in Azure Cosmos DB using Notebooks.

Getting started with Azure Cosmos DB Serverless

February 8, 2021 by Rahul Mehta

In this article, we will learn how to create a serverless instance of Azure Cosmos DB as well as understand its applicability in use-cases.

Creating external tables in Azure Synapse Analytics

February 4, 2021 by Rahul Mehta

In this article, we will learn to create external tables in Azure Synapse Analytics with dedicated SQL pools.

Populate Azure Synapse Analytics from Azure SQL databases using SSIS

February 2, 2021 by Rahul Mehta

In this article, we will learn how to populate data from the Azure SQL database into Azure Synapse Analytics using SQL Server Integration Services (SSIS).

Working with Spark pools in Azure Synapse Analytics

January 29, 2021 by Rahul Mehta

In this article, we will learn how to create a Spark pool in Azure Synapse Analytics and process the data using it.

Dedicated SQL pools in Azure Synapse Analytics

January 28, 2021 by Rahul Mehta

This article helps you create a dedicated SQL pool in Azure Synapse Analytics, which is the first step to set up a data warehousing environment in Synapse.

SQL on-demand pools in Azure Synapse Analytics

January 22, 2021 by Rahul Mehta

This article will show how to work with SQL on-demand pools and understand the fundamentals of working with this pool in Azure Synapse Analytics.

Getting started with Azure Synapse Studio

January 19, 2021 by Rahul Mehta

This article will help you get started with Azure Synapse Studio and its various features.

Creating Azure Synapse Analytics Workspaces

January 18, 2021 by Rahul Mehta

This article will help you understand the process to create an Azure Synapse Analytics workspace and some other features related to it.

How to access an Azure SQL database from Azure Data Lake Analytics

January 14, 2021 by Rahul Mehta

In this article, we will see how we can access data from an Azure SQL database from Azure Data Lake Analytics.

Processing file sets with U-SQL in Azure Data Lake Analytics

January 11, 2021 by Rahul Mehta

This article will help you process file sets with U-SQL in Azure Data Lake Analytics.