Rajendra Gupta

Author
Recent Posts

Hi! I am Rajendra Gupta, Database Specialist and Architect, helping organizations implement Microsoft SQL Server, Azure, Couchbase, AWS solutions fast and efficiently, fix related issues, and Performance Tuning with over 14 years of experience.

I am the author of the book "DP-300 Administering Relational Database on Microsoft Azure". I published more than 650 technical articles on MSSQLTips, SQLShack, Quest, CodingSight, and SeveralNines.

I am the creator of one of the biggest free online collections of articles on a single topic, with his 50-part series on SQL Server Always On Availability Groups.

Based on my contribution to the SQL Server community, I have been recognized as the prestigious Best Author of the Year continuously in 2019, 2020, and 2021 (2nd Rank) at SQLShack and the MSSQLTIPS champions award in 2020.

Personal Blog: https://www.dbblogger.com
I am always interested in new challenges so if you need consulting help, reach me at rajendra.gupta16@gmail.com

View all posts by Rajendra Gupta

Latest posts by Rajendra Gupta (see all)

Database level roles in Azure SQL Database - April 12, 2022
Fixed Server Roles in Azure SQL Database Server - April 6, 2022
SQL Server Dedicated Administrator Connections for Azure SQL Database - March 29, 2022

Capturing deadlocks on AWS RDS SQL Server databases

April 7, 2021 by Rajendra Gupta

This article will explore the process to capture deadlock XML and deadlock graphs for AWS RDS SQL Server databases.

Automatic Pause and Resume of an Azure SQL database

April 2, 2021 by Rajendra Gupta

Azure SQL Database is an Infrastructure-as-a-Service component for migrating your on-premises SQL Server to cloud infrastructure. We always look for performance, cost, and scaling resources while we plan resources in the cloud. Many times, we do not want our databases running 24*7*365. Suppose you have a development or training database. Your developers work during the daytime on the weekdays. If you deploy an Azure SQL Database, you don’t get an option to stop it. You get charged for it whether you use it actively or not.

Moving the SSISDB Catalog on a new SQL Server instance

March 30, 2021 by Rajendra Gupta

This article will explore the right way of moving integration services (SSIS) catalog SQL Database to a new instance.

Configure long-term backup retention for Azure SQL database

March 25, 2021 by Rajendra Gupta

This article configures a long-term backup retention policy for Azure SQL Database.

Create a transactionally consistent copy of Azure SQL database

March 22, 2021 by Rajendra Gupta

In this article, we implement a copy of the Azure SQL database using both Azure Web Portal and Azure CLI.

An overview of Azure Cloud Shell

March 18, 2021 by Rajendra Gupta

This articles gives an overview of the Azure Cloud Shell.

Fuzzy joins in SQL Server Machine Learning using R scripts

March 16, 2021 by Rajendra Gupta

In this article, we will discuss the Fuzzy joins in the SQL Server Machine Learning using R scripts.

Provisioning Azure SQL database using Azure PowerShell

March 10, 2021 by Rajendra Gupta

This article will show how to create an Azure SQL database using Azure PowerShell.

Lease Timeouts and Health Checks in SQL Server Always On Availability Groups

March 8, 2021 by Rajendra Gupta

In the 42^nd article for SQL Server Always On Availability Groups, we are going to explore lease timeouts and health checks.

SUBSTRING, PATINDEX and CHARINDEX string functions in SQL queries

March 1, 2021 by Rajendra Gupta

In this article, we will explore SUBSTRING, PATINDEX and CHARINDEX string functions for SQL queries.

Deploy Azure Data Lake Analytics database using the U-SQL scripts

February 23, 2021 by Rajendra Gupta

In this 3^rd article of the Azure Data Lake Analytics series, we will explore deploying a database, tables using U-SQL scripts.

Join database tables using U-SQL scripts for Azure Data Lake Analytics

February 17, 2021 by Rajendra Gupta

In this article, we will explore joining database tables using U-SQL scripts for Azure Data Lake Analytics.

Writing U-SQL scripts using Visual Studio for Azure Data Lake Analytics

February 11, 2021 by Rajendra Gupta

In the 2^nd article of the series for Azure Data Lake Analytics, we will use Visual Studio for writing U-SQL scripts.

An overview of Azure Data Lake Analytics and U-SQL

February 10, 2021 by Rajendra Gupta

In this article, we explore the Azure Data Lake Analytics and query data using the U-SQL.

Session timeouts in SQL Server Always On Availability Groups

February 8, 2021 by Rajendra Gupta

In this 41st article for SQL Server Always On Availability Groups, we will explore the session timeout configurations for AG replicas.

Performing minor and major version upgrades for AWS RDS SQL Server

January 29, 2021 by Rajendra Gupta

Usually, database administrators upgrade the SQL Server versions for on-premise infrastructure. The AWS cloud infrastructure for SQL Server supports two flavors for database deployments.

SQL Server deployed on the AWS EC2 instance
An AWS managed instance relational database service

Deploying AWS RDS PostgreSQL instances

January 27, 2021 by Rajendra Gupta

In this article, we will look at the configuration of the AWS RDS PostgreSQL instances.

Migrating your on-premises SQL databases to AWS RDS SQL Server using AWS DMS

January 25, 2021 by Rajendra Gupta

There are multiple ways to deploy the databases in the AWS RDS SQL Server. Suppose you want to migrate your on-premises SQL Server database to AWS managed relational database service and you have a critical application and require minimal (almost zero) downtime. For this purpose, you can use the AWS Database Migration Service (AWS DMS) in a combination of SQL Server native backups.

Synchronize logins between Availability replicas in SQL Server Always On Availability Groups

January 21, 2021 by Rajendra Gupta

In this 40^th article on SQL Server Always On Availability Group series, we will discuss logins synchronization between replicas.

Export Amazon Aurora MySQL or Amazon RDS snapshots to AWS S3 buckets

January 19, 2021 by Rajendra Gupta

In this article, we will explore the following topics:

Amazon Aurora or Amazon RDS database snapshot export to S3 bucket
Use AWS Glue to crawl the Snapshot and generate a data catalog
Use Amazon Athena to query the data catalog
Export Amazon Athena query results into S3 bucket

SQL Server PolyBase external tables with Azure Blob Storage

January 15, 2021 by Rajendra Gupta

In this article, we will explore SQL Server PolyBase external tables with Azure Blob Storage.

Database Cloning in Amazon Aurora

January 11, 2021 by Rajendra Gupta

Amazon Aurora provides a MySQL and PostgreSQL compatible relation database with performance and feature enhancements over the existing databases. In the previous articles, we discussed the following features. You can refer to ToC at the bottom.

Backtrack
Global Database
Amazon Aurora Serverless

In this article, we will cover fast database cloning and its usage for aurora databases.

Implement an Amazon Aurora Serverless cluster

January 4, 2021 by Rajendra Gupta

In this 4^th article for the Amazon Aurora series, we will discuss and implement an Amazon Aurora Serverless cluster.

Rewind or Forward the Amazon Aurora Cluster with MySQL compatibility using backtrack feature

December 24, 2020 by Rajendra Gupta

In this article, we will explore the useful backtrack feature for Amazon Aurora clusters.

Explore Amazon Aurora global databases with MySQL compatibility

December 21, 2020 by Rajendra Gupta

In the article, Deploy your AWS RDS Aurora database clusters for MySQL, we explored the Amazon Aurora concept and deployment. In this article, we will understand about the global database feature and its implementations.