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

Character Map Transformations in SSIS packages

September 11, 2019 by Rajendra Gupta

This article explores the Character Map Transformation in SSIS package with available configurations.

Overview of SQL LOWER and SQL UPPER functions

September 10, 2019 by Rajendra Gupta

This article gives an overview of SQL UPPER function and SQL LOWER function to convert the character case as uppercase and lowercase respectively.

Upgrading to a new SQL Server edition

September 9, 2019 by Rajendra Gupta

This article gives an overview of different editions in SQL Server and also explains the process to upgrade SQL Server editions.

Overview of the SQL DELETE Column from an existing table operation

September 6, 2019 by Rajendra Gupta

In this article, we will explore the process of SQL Delete column from an existing table. We will also understand the impact of removing a column with defined constraints and objects on it.

Using a CHECKPOINT in SSIS packages to restart package execution

September 5, 2019 by Rajendra Gupta

In the article, SQL Server CHECKPOINT, Lazy Writer, Eager Writer and Dirty Pages in SQL Server, we talked about the CHECKPOINT process for SQL Server databases. This article is about CHECKPOINT in SSIS package.

An overview of Error Handling in SSIS packages

September 5, 2019 by Rajendra Gupta

This article explains the process of configuring Error handling in SSIS package.

Term Extraction Transformation in SSIS

September 2, 2019 by Rajendra Gupta

This article explores the Term extraction transformation in SSIS and its usage scenario.

Different ways to SQL delete duplicate rows from a SQL Table

August 30, 2019 by Rajendra Gupta

This article explains the process of performing SQL delete activity for duplicate rows from a SQL table.

An Overview of the LOOKUP TRANSFORMATION in SSIS

August 29, 2019 by Rajendra Gupta

We will explore Lookup Transformation in SSIS in this article for incremental data loading in SQL Server.

SET NOCOUNT ON statement usage and performance benefits in SQL Server

August 26, 2019 by Rajendra Gupta

Have you ever noticed SET NOCOUNT ON statement in T-SQL statements or stored procedures in SQL Server? I have seen developers not using this set statement due to not knowing it.

Overview of SSIS Package Logging

August 23, 2019 by Rajendra Gupta

This article gives an overview of the different methods of SQL Server SSIS Package Logging.

SSIS Multicast Transformation overview

August 22, 2019 by Rajendra Gupta

This article explores the SSIS Multicast Transformation for creating different logical copies of source data.

SQL Server CHECKPOINT, Lazy Writer, Eager Writer and Dirty Pages in SQL Server

August 22, 2019 by Rajendra Gupta

Database administrators should be aware of the internal SQL Server processes such as the dirty pages, SQL Server CHECKPOINT, Lazy writer process. This is a very common question that you might come across in SQL DBA technical interviews as well on all levels such as beginner, intermediate and expert level.

KILL SPID command in SQL Server

August 21, 2019 by Rajendra Gupta

This article gives an overview of the KILL SPID command and how to monitor the rollback progress.

SSIS Conditional Split Transformation overview

August 16, 2019 by Rajendra Gupta

This article explores the SSIS Conditional Split Transform task to split data into multiple destinations based on the specified conditions.

Overview of the Shrink TempDB database in SQL Server

August 15, 2019 by Rajendra Gupta

This article explores the usage of TempDB and different ways to shrink the TempDB database in SQL Server

Calculate SQL Percentile using the PERCENT_RANK function in SQL Server

August 15, 2019 by Rajendra Gupta

This article explores the SQL Server PERCENT_RANK analytical function to calculate SQL Percentile and its usage with various examples.

SQL Server Statistics and how to perform Update Statistics in SQL

August 13, 2019 by Rajendra Gupta

This article gives a walk-through of SQL Server Statistics and different methods to perform SQL Server Update Statistics.

Monitoring SQL Server deadlocks using the system_health extended event

August 12, 2019 by Rajendra Gupta

Performance monitoring is a must to do the task for a DBA. You should ensure that the database performance is optimal all the time without any impact on the databases. Performance issues act like an open stage, and you need to look at every aspect such as CPU, RAM, server performance, database performance, indexes, blocking, waits, and SQL Server deadlocks. You might face frequent deadlocks issues, and they have a direct impact on the application performance.

Windows Failover Cluster Quorum Modes in SQL Server Always On Availability Groups

August 8, 2019 by Rajendra Gupta

This article gives an overview of Windows Failover Cluster Quorum modes that is necessary for SQL Server Always on Availability Groups.

SQL STUFF function overview

July 31, 2019 by Rajendra Gupta

This article gives an overview of the SQL STUFF function with various examples.

FOR XML PATH clause in SQL Server

July 30, 2019 by Rajendra Gupta

As SQL professionals, we often have to deal with XML data in our databases. This article will help you walk through several examples of using ‘FOR XML PATH’ clause in SQL Server.

Max Worker Threads for SQL Server Always on Availability Group databases

July 26, 2019 by Rajendra Gupta

This article gives an overview of the Max Worker Threads for the SQL Server Always On Availability Group databases.

Comparing VARCHAR(max) vs VARCHAR(n) data types in SQL Server

July 26, 2019 by Rajendra Gupta

I have seen that SQL developers use varchar(max) data while designing the tables or temporary tables. We might not be sure about the data length, or we want to eliminate the string or binary truncation error.

Overview of SQL Server Startup Parameters for the SQL Database Engine Service

July 24, 2019 by Rajendra Gupta

In the SQL world, it is an important activity to perform SQL Server installation for a database administrator. Have you ever noticed ‘SQL Server Startup Parameters’ for the SQL Service? You might not have noticed them, but these parameters are beneficial for DBAs.