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)

Identify and remediate non-compliant Azure SQL Databases for auditing on SQL Server - September 16, 2021
Azure Alerts for creating, modifying and deleting Azure SQL Databases - September 13, 2021
Azure Automation: Automatic scaling Azure SQL databases based on CPU usage threshold - September 10, 2021

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.

Explore branches in Git Source Control

September 28, 2020 by Rajendra Gupta

In this 5^th article of the Source Control series, we will explore the concept of branches in a Git source control and GitHub repositories.

Explore Manual Snapshots in AWS RDS SQL Server

September 23, 2020 by Rajendra Gupta

In this article, we explore the use of manual snapshots in AWS RDS SQL Server.

Suspend and Resume Data Movement in SQL Server Always On Availability Groups

September 23, 2020 by Rajendra Gupta

In this 26^th article for SQL Server Always On Availability Groups series, we will discuss the process to suspend and resume data movements between AG replicas.

Configure SQL Server Reporting Services databases in SQL Server Always On Availability Groups

September 22, 2020 by Rajendra Gupta

This is the 25^th article in SQL Server Always On Availability Groups series. In this article, we will explore the high availability configuration for reporting services databases.

Refresh SQL Server Always On Availability Group databases using DBATools PowerShell

September 21, 2020 by Rajendra Gupta

In the 20^th article of the SQL Server Always On Availability Group series, we will explore the process to refresh an availability group database using SQL scripts. In this article, we will use the DBATools commands for this purpose.

Impact of dropping a login in the active directory tied to SQL Server Always On Availability Groups

September 17, 2020 by Rajendra Gupta

This article explores the impact of dropping a login in the active directory if that owns a HADR endpoint and SQL Server Always On Availability Groups. It is the 23^rd article in the SQL Server Always On Availability Group.

Backup SQL databases on the AWS S3 bucket using Windows PowerShell

September 16, 2020 by Rajendra Gupta

In this article, we will explore taking backups of native SQL databases into the AWS S3 bucket.