Gauri Mahajan

Author
Recent Posts

Gauri is a SQL Server Professional and has 6+ years experience of working with global multinational consulting and technology organizations. She is very passionate about working on SQL Server topics like Azure SQL Database, SQL Server Reporting Services, R, Python, Power BI, Database engine, etc. She has years of experience in technical documentation and is fond of technology authoring.

She has a deep experience in designing data and analytics solutions and ensuring its stability, reliability, and performance. She is also certified in SQL Server and have passed certifications like 70-463: Implementing Data Warehouses with Microsoft SQL Server.

View all posts by Gauri Mahajan

Distributed tables in Azure Synapse Analytics

September 20, 2021 by Gauri Mahajan

This article talks about the table distribution styles supported in Azure Synapse and how to use them for creating distributed tables.

Executing stored procedures from data pipelines in Azure Data Factory

September 13, 2021 by Gauri Mahajan

This article aims to walk you through the process to execute a stored procedure hosted in Azure SQL Database from a data pipeline in Azure Data Factory.

Importing data from OData APIs using Azure Data Factory

September 6, 2021 by Gauri Mahajan

In this article, we will learn how to use Azure Data Factory to import data from OData APIs on Azure storage repositories.

Creating Replicas in Azure Database for PostgreSQL

September 2, 2021 by Gauri Mahajan

In this article, we will learn how to create and manage read replicas in Azure Database for PostgreSQL.

Data Flow Transformations in Azure Data Factory

August 30, 2021 by Gauri Mahajan

This article will help you get introduced to all the transformations offered in the Data Flow component of Azure Data Factory.

Develop ETL templates for Data Warehousing using Azure Data Factory

August 26, 2021 by Gauri Mahajan

In this article, we will learn how to develop ETL templates for data warehousing using Azure Data Factory.

Data Migration from Azure SQL Database to Azure Database for PostgreSQL

August 23, 2021 by Gauri Mahajan

In this article, we will learn how to migrate data from Azure SQL Database to Azure Database for PostgreSQL using the Azure Data Factory.

Filtering data in Azure Database for PostgreSQL

August 18, 2021 by Gauri Mahajan

In this article, we will go over some of the most fundamental ways to filter data hosted in PostgreSQL.

Validating data ingestion with Postgres check constraint

August 12, 2021 by Gauri Mahajan

In this article, we will learn how to create a simple PostgreSQL server on the Azure platform and learn how to use the Postgres check constraint to implement data validation.

Integrating APIs into data pipelines with Azure Data Factory

August 9, 2021 by Gauri Mahajan

In this article, we will learn how to invoke an API and process the data returned by the API using Azure Data Factory.

Web scraping data with Azure Data Factory

August 3, 2021 by Gauri Mahajan

This article will show you how to web scrape data using Azure Data Factory and store the data on one of the Azure data repositories.

Getting started with Azure Database for PostgreSQL – Citus server

July 30, 2021 by Gauri Mahajan

This article will show how to deploy the Hyperscale (Citus) server group of Azure Database for PostgreSQL and explore its configuration options.

Getting started with Azure Database for PostgreSQL – Flexible server

July 14, 2021 by Gauri Mahajan

This article will walk you through the process to create a Flexible server model of Azure Database for PostgreSQL and learn the unique features offered by it.

Data Wrangling with Power Query in Azure Data Factory

July 6, 2021 by Gauri Mahajan

This article will help you get started with Power Query in Azure Data Factory to perform Data Wrangling.

Consuming datasets from Azure SQL Database in Azure Machine Learning

June 29, 2021 by Gauri Mahajan

This article will show how to source data from Azure SQL Database into Azure Machine Learning.

Creating and Cataloging SQL pools in Azure SQL Server

June 22, 2021 by Gauri Mahajan

This article will walk you through creating a new SQL pool within an existing Azure SQL Server as well as catalog the same using the Azure Purview service.

Integrating Azure Purview with Azure Synapse Analytics

June 14, 2021 by Gauri Mahajan

In this article, we will learn how to integrate Azure Purview and Azure Synapse Analytics capabilities to access data catalog assets hosted in Purview from Azure Synapse.

Cataloging AWS S3 datasets with Azure Purview

June 2, 2021 by Gauri Mahajan

In this article, we will learn how to configure Azure Purview to catalog data hosted in AWS S3.

Accessing Azure Database for PostgreSQL using pgAdmin

May 26, 2021 by Gauri Mahajan

In this article, we will show how to connect to instances of Azure Database for PostgreSQL servers using the pgAdmin tool installed locally on a user’s workstation.

Querying JSON documents in Azure Cosmos DB using the SQL API

May 21, 2021 by Gauri Mahajan

In this article, we will look briefly at the Azure Cosmos DB service and how you can query JSON documents to store, retrieve and process data using the SQL Application Programming Interface (API).

Azure Database for PostgreSQL Cost Optimization

May 14, 2021 by Gauri Mahajan

This article will walk you through the process to optimize the cost of Azure Database for PostgreSQL.

Getting started with Azure Database for PostgreSQL

May 13, 2021 by Gauri Mahajan

This article will get you started with Azure Database for PostgreSQL and understand various options offered by this.

Generating Azure SQL Database Classification and Sensitivity reports

May 5, 2021 by Gauri Mahajan

This article will show how to use Azure SQL Database to classify and tag data with sensitivity labels to generate reports out of it.

Dynamic Data Masking in Azure Synapse Analytics

April 23, 2021 by Gauri Mahajan

This article will take you through the process to apply Dynamic Data Masking on the dedicated SQL pool of Azure Synapse Analytics.

Sourcing data from Azure SQL Database in Azure Machine Learning

April 19, 2021 by Gauri Mahajan

In this article, we will show how to source data from Azure SQL Database to use in a Machine Learning workflow.