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)

Understanding PostgreSQL SUBSTRING function - September 21, 2024
How to install PostgreSQL on Ubuntu - July 13, 2023
How to use the CROSSTAB function in PostgreSQL - February 17, 2023

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.

Custom policies for AG dashboards of SQL Server Always On Availability Groups

November 10, 2020 by Rajendra Gupta

In this 35^th article in SQL Server Always On Availability Groups, we will implement a custom policy for monitoring AG groups.

The Hub and Spoke model of policy-based management for SQL Server Always On Availability Groups

November 9, 2020 by Rajendra Gupta

In this 34^th article on SQL Server Always On Availability Groups, we will explore policy-based management features for the AG’s.

An Overview of User-defined SQL Server Types

November 3, 2020 by Rajendra Gupta

In this article, we will explore User-defined SQL Server Types and their usage.

Useful Considerations for SQL Server Disaster Recovery

October 27, 2020 by Rajendra Gupta

This article discusses useful considerations for SQL Server Disaster Recovery.

Install SQL Server Linux (2017 version) on SUSE Linux in Amazon EC2 instance

October 26, 2020 by Rajendra Gupta

In this article, we will install and configure SQL Server Linux (2017 version) on SUSE Linux in the Amazon EC2 Instance.

Monitor SQL Server Always On Availability groups using extended events

October 20, 2020 by Rajendra Gupta

In this 33^rd article of SQL Server Always On Availability Group series, we will use extended events to monitor the availability group.

Develop your extensions for Azure Data Studio

October 20, 2020 by Rajendra Gupta

Azure Data Studio (ADS) is a popular cross-platform (Windows, Linux) tool for database professionals. It provides various useful features such as T-SQL editor, Visualizations, insights, Peek definitions, Notebooks, Git integration, extensions and more. Extensions add new functionality in the ADS. Microsoft provides several useful extensions. We have already covered few useful extensions in the Azure Data Studio category on SQLShack.

Apply SQL Server patches or cumulative updates in SQL Server Always On Availability Groups

October 14, 2020 by Rajendra Gupta

In this 32^nd article on SQL Server Always On Availability Group series, we will discuss the process to apply a service pack or Cumulative packs for AG replica instances.

Make the most of secondary replicas in SQL Server Always On Availability Groups

October 13, 2020 by Rajendra Gupta

In this 31^st article of the SQL Server Always On Availability Group series, we will explore how you can use the secondary replica SQL database for your workloads.

Column-level SQL Server encryption with SQL Server Always On Availability Groups

October 12, 2020 by Rajendra Gupta

It is the 30^th article in the SQL Server Always On Availability Groups series and explores column-level SQL Server encryption with AG groups.

Install SQL Server Express on Windows Server 2016 using docker containers

October 9, 2020 by Rajendra Gupta

In this article, we will install the SQL Server Express edition on Windows Server 2016 using a SQL Server Docker container.

SQL Server Always On Availability Groups for SQL Server Linux instances

October 6, 2020 by Rajendra Gupta

In this 29^th article of the SQL Server Always On Availability Groups series, we configure the AG between SQL Server Linux instances.

Restore a SQL database from Windows SQL Server to SQL Server Linux instance

October 5, 2020 by Rajendra Gupta

Database professionals get the standard requirement for SQL database restores from production to non-production instances. As you know, SQL Server runs on the Linux and Windows operating systems starting from SQL Server 2016. Suppose you are exploring the SQL Server Linux instance features and configurations.

Explore SQL Server PolyBase External Tables in SQL Server Always On Availability Groups

September 29, 2020 by Rajendra Gupta

In this 28^th article for SQL Server Always On Availability Group series, we explore the high-availability for the SQL Server PolyBase(SSB) external tables using AG groups.

Explore failover types in SQL Server Always On Availability Groups

September 29, 2020 by Rajendra Gupta

In this 27^th article of the SQL Server Always On Availability Group series, we will discuss various failover modes for AG databases.

Suppress successful login and backups messages from the error log for SQL databases

September 28, 2020 by Rajendra Gupta

In this article, we will explore the method to suppress successful login and backups messages in the error log for SQL databases.