Rajendra Gupta

Author
Recent Posts

As an MCSA certified and Microsoft Certified Trainer in Gurgaon, India, with 13 years of experience, Rajendra works for a variety of large companies focusing on performance optimization, monitoring, high availability, and disaster recovery strategies and implementation. He is the author of hundreds of authoritative articles on SQL Server, Azure, MySQL, Linux, Power BI, Performance tuning, AWS/Amazon RDS, Git, and related technologies that have been viewed by over 10m readers to date.

He is 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 his contribution to the SQL Server community, he has been recognized with various awards including the prestigious “Best author of the year" continuously in 2020 and 2021 at SQLShack.

Raj is always interested in new challenges so if you need consulting help on any subject covered in his writings, he can be reached at rajendra.gupta16@gmail.com

View all posts by Rajendra Gupta

Latest posts by Rajendra Gupta (see all)

Migrating your on-premises SQL databases to AWS RDS SQL Server using AWS DMS - January 25, 2021
Synchronize logins between Availability replicas in SQL Server Always On Availability Groups - January 21, 2021
Export Amazon Aurora MySQL or Amazon RDS snapshots to AWS S3 buckets - January 19, 2021

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.

Deploy your Amazon Aurora database clusters for MySQL

December 18, 2020 by Rajendra Gupta

Introduction

Amazon offers managed database service for various database products such as Microsoft SQL Server, MySQL, PostgreSQL, Oracle. In these relational database services (RDS), AWS manages the operating system, networking components, backups, monitoring solutions. In the previous articles, we explored many useful RDS features under the AWS RDS category on SQLShack.

Web Scraping for SQL Machine learning using R scripts

December 14, 2020 by Rajendra Gupta

In this article, we will explore Web Scraping using R Scripts for SQL Machine Learning.

Configure Integration Services Catalog Database SSISDB in SQL Server Always On Availability Groups

December 14, 2020 by Rajendra Gupta

In this 39^th article for SQL Server Always On Availability Group series, we will learn to configure SSISDB in the highly available AG groups.

Configure SQL Server Always On Availability Groups using Windows PowerShell scripts

December 10, 2020 by Rajendra Gupta

In this 38^th article for SQL Server Always On Availability Groups, we will explore Windows PowerShell scripts to configure it.

How to install SQL Server 2019 on RedHat Linux 18

December 9, 2020 by Rajendra Gupta

In this article, we will learn to install SQL Server 2019 on the RedHat Linux 18 on a virtual machine.

Import data from PDF files using R Scripts SQL Server

December 8, 2020 by Rajendra Gupta

In this article, we will read and import data from a PDF file using the R scripts SQL Server.

Import and Export data using R and SQL Server

December 3, 2020 by Rajendra Gupta

Data professionals get requests to import, export data into various formats. These formats can be such as Comma-separated data(.CSV), Excel, HTML, JSON, YAML, Tab-separated data(.TSV). Usually, we use SQL Server integration service ETL packages for data transformations, import or export data.

Working with images in SQL Machine Learning using R scripts

November 27, 2020 by Rajendra Gupta

In the article, An overview of SQL Machine Learning with R scripts, we learned the R services integration with SQL Server 2019. We also explored a few useful external packages.

An overview of SQL Machine Learning with R scripts

November 25, 2020 by Rajendra Gupta

In this article, we will focus on SQL Machine Learning using R scripts and the use of external packages.

Split native databases backup and restore for AWS RDS SQL Server from AWS S3 buckets

November 24, 2020 by Rajendra Gupta

In this article, we will explore how to split native backup and restore for AWS RDS SQL Server from the AWS S3 bucket.

Configure SQL Server Replication between AWS RDS SQL Server and On-premises SQL Server

November 20, 2020 by Rajendra Gupta

In this article, we will implement a SQL Server Replication between AWS RDS SQL Server and On-premises SQL Server instance.

Dynamic management views for monitoring availability replicas and databases for SQL Server Always On Availability Groups

November 19, 2020 by Rajendra Gupta

In this 37^th article for SQL Server Always On Availability Groups, we will explore useful dynamic management views for monitoring availability replicas and databases.

Explore dynamic management views for monitoring SQL Server Always On Availability Groups

November 16, 2020 by Rajendra Gupta

In this 36^th article for SQL Server Always On series, we will explore various dynamic management views (DMV’s) for monitoring the AG replicas.

Explore the SQL query table hint READPAST

November 14, 2020 by Rajendra Gupta

SQL Server creates an optimized execution plan based on the available inputs such as statistics, indexes. By default, it chooses a cost-optimized execution plan and executes the query. Sometimes, we use SQL queries table hints to override the default mechanism. Developers popularly use WITH (NOLOCK) query hint in a Select statement to avoid blocking issues.