In this article, we will learn how to establish successful connectivity from Azure Data Factory to the Azure Databricks platform.
Read more »
Gauri Mahajan
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
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
Latest posts by Gauri Mahajan (see all)
- Oracle Substring function overview with examples - June 19, 2024
- Introduction to the SQL Standard Deviation function - April 21, 2023
- A quick overview of MySQL foreign key with examples - February 7, 2023
Monitoring Azure Synapse Analytics with alerts
October 5, 2021This article will drive you through the way to create alerts on an Azure Synapse instance to receive notifications based on various monitoring criteria that are met.
Read more »
Instrumenting queries in Azure Synapse Analytics
September 27, 2021This article will show how to instrument queries executed on a dedicated SQL pool of Azure Synapse Analytics.
Read more »
Distributed tables in Azure Synapse Analytics
September 20, 2021This article talks about the table distribution styles supported in Azure Synapse and how to use them for creating distributed tables.
Read more »
Executing stored procedures from data pipelines in Azure Data Factory
September 13, 2021This 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.
Read more »
Importing data from OData APIs using Azure Data Factory
September 6, 2021In this article, we will learn how to use Azure Data Factory to import data from OData APIs on Azure storage repositories.
Read more »
Creating Replicas in Azure Database for PostgreSQL
September 2, 2021In this article, we will learn how to create and manage read replicas in Azure Database for PostgreSQL.
Read more »
Data Flow Transformations in Azure Data Factory
August 30, 2021This article will help you get introduced to all the transformations offered in the Data Flow component of Azure Data Factory.
Read more »
Develop ETL templates for Data Warehousing using Azure Data Factory
August 26, 2021In this article, we will learn how to develop ETL templates for data warehousing using Azure Data Factory.
Read more »
Data Migration from Azure SQL Database to Azure Database for PostgreSQL
August 23, 2021In this article, we will learn how to migrate data from Azure SQL Database to Azure Database for PostgreSQL using the Azure Data Factory.
Read more »
Filtering data in Azure Database for PostgreSQL
August 18, 2021In this article, we will go over some of the most fundamental ways to filter data hosted in PostgreSQL.
Read more »
Validating data ingestion with Postgres check constraint
August 12, 2021In 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.
Read more »
Integrating APIs into data pipelines with Azure Data Factory
August 9, 2021In this article, we will learn how to invoke an API and process the data returned by the API using Azure Data Factory.
Read more »
Web scraping data with Azure Data Factory
August 3, 2021This article will show you how to web scrape data using Azure Data Factory and store the data on one of the Azure data repositories.
Read more »
Getting started with Azure Database for PostgreSQL – Citus server
July 30, 2021This article will show how to deploy the Hyperscale (Citus) server group of Azure Database for PostgreSQL and explore its configuration options.
Read more »
Getting started with Azure Database for PostgreSQL – Flexible server
July 14, 2021This 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.
Read more »
Data Wrangling with Power Query in Azure Data Factory
July 6, 2021This article will help you get started with Power Query in Azure Data Factory to perform Data Wrangling.
Read more »
Consuming datasets from Azure SQL Database in Azure Machine Learning
June 29, 2021This article will show how to source data from Azure SQL Database into Azure Machine Learning.
Read more »
Creating and Cataloging SQL pools in Azure SQL Server
June 22, 2021This 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.
Read more »
Integrating Azure Purview with Azure Synapse Analytics
June 14, 2021In 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.
Read more »
Cataloging AWS S3 datasets with Azure Purview
June 2, 2021In this article, we will learn how to configure Azure Purview to catalog data hosted in AWS S3.
Read more »
Accessing Azure Database for PostgreSQL using pgAdmin
May 26, 2021In 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.
Read more »
Querying JSON documents in Azure Cosmos DB using the SQL API
May 21, 2021In 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).
Read more »
Azure Database for PostgreSQL Cost Optimization
May 14, 2021This article will walk you through the process to optimize the cost of Azure Database for PostgreSQL.
Read more »
Getting started with Azure Database for PostgreSQL
May 13, 2021This article will get you started with Azure Database for PostgreSQL and understand various options offered by this.
Read more »