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)

How to install PostgreSQL on Ubuntu - July 13, 2023
How to use the CROSSTAB function in PostgreSQL - February 17, 2023
Learn the PostgreSQL COALESCE command - January 19, 2023

Visual Studio Code (VS Code) integration with Git Source Control

July 22, 2020 by Rajendra Gupta

This article explores Visual Studio Code integration with Git Source Control.

Visual Studio Code (VS Code) for SQL Server development

July 16, 2020 by Rajendra Gupta

In the previous article, Getting started with Visual Studio Code (VS Code), we took a detailed overview of the popular code editor. It supports various programming languages t-SQL, Python, PHP, AWS CLI, PowerShell, etc. We need to use extensions in the VS code to work with these languages. For example, if we open the T-SQL script, it recommends you for the below extension.

Install SQL Server 2019 on Windows Server 2016 with SQL Server Always On Availability Groups

July 15, 2020 by Rajendra Gupta

In this article, we will proceed with configuring a SQL Server Always On Availability Groups and perform failover validations.

Launch a static website using AWS S3 buckets

July 15, 2020 by Rajendra Gupta

This article explores the AWS S3 bucket to configure a static website.

Configure failover clusters, storage controllers and quorum configurations for SQL Server Always On Availability Groups

July 14, 2020 by Rajendra Gupta

This article explores the configuration of Windows failover clusters, storage controllers, and quorum configurations for SQL Server Always On Availability Groups.

Configure Domain Controller and Active Directory for SQL Server Always On Availability Groups

July 13, 2020 by Rajendra Gupta

In this series for SQL Server Always On Availability Groups, we are covering end to end configurations for SQL Server 2019 on Windows Server 2016. In the article, A comprehensive guide to SQL Server Always On Availability Groups on Windows Server 2016, we configured three virtual machines with their networking configurations.

A comprehensive guide to SQL Server Always On Availability Groups on Windows Server 2016

July 13, 2020 by Rajendra Gupta

In this article, we will configure a SQL Server Always On Availability Group on the Windows Server 2016. We use SQL Server 2019 for configuration.

Working with Git components in Azure Data Studio

July 9, 2020 by Rajendra Gupta

This article gives an insight into the terms in the Git repository of Azure Data Studio. In the previous articles, we learned the following things:

Getting started with Visual Studio Code (VS Code)

July 8, 2020 by Rajendra Gupta

Visual Studio Code is a popular text editor or code editor to write queries and codes for developers. It is popularly known as VS code. It can highlight and format the code for quick development and understanding purposes.

Integrating Azure Data Studio with Git and GitHub

July 3, 2020 by Rajendra Gupta

In the last article, Source Control using Git in Azure Data Studio (ADS), we explored the following topics:

The requirement of Source control for SQL scripts
Git installation on Windows
Integrate Git in Azure Data Studio
Create Git repository, add SQL scripts, modify files, commit into source control
View different versions using the Git timelines

In this article, we will take a step forward and integrate Git installed locally on the GitHub.

Explore the SQL query Hint OPTION (FAST N)

July 2, 2020 by Rajendra Gupta

In this article, we will introduce SQL queries hint and will analyze the OPTION(Fast ‘N’) hint in detail.

Explore SQL Server Index Properties in SSMS

July 2, 2020 by Rajendra Gupta

This article gives you an insight into SQL Server Index properties in SSMS.

Source Control using Git in Azure Data Studio (ADS)

July 2, 2020 by Rajendra Gupta

Azure Data Studio is a tool for both developers and database administrators with exciting features. You can install ADS on both Windows and Linux platforms. You can go through various Azure Data Studio articles on SQLShack to be comfortable with the tool and its features.

The SQL Server Assessment Extension for Azure Data Studio

June 30, 2020 by Rajendra Gupta

Azure Data Studio extensions enable adding new functionality for development and administrative tasks. It is an open-source functionality and allows Microsoft as well as third party extensions using Marketplace. We explored a few useful extensions in the Azure Data Studio category of articles.

Different ways to search for objects in SQL databases

June 29, 2020 by Rajendra Gupta

This article explores various ways to search for database objects in SQL database such as tables, stored procedures, functions, and views.

AWS Launch Wizard for quick SQL Server Always On deployments

June 29, 2020 by Rajendra Gupta

SQL Server Always On is a high-availability and disaster recovery solution. We can use multiple secondary replicas for configuring database backups, redirect read requests to offload primary instance load.

An overview of Logon triggers in SQL Server

June 19, 2020 by Rajendra Gupta

This article gives you an overview of Logon triggers in SQL Server and its usage to control SQL Server authentication.

Deploying an AWS RDS SQL Server using the AWS CLI

June 19, 2020 by Rajendra Gupta

This article deploys a new AWS RDS SQL Server using the AWS CLI command: create-db-instance.

How to rollback using explicit SQL Server transactions

June 17, 2020 by Rajendra Gupta

In this article, we will explore the process of rollback an explicit SQL Server transaction. We will also explore the difference between explicit and implicit transactions.

Automatically Start/Stop an AWS RDS SQL Server using AWS Lambda functions

June 12, 2020 by Rajendra Gupta

This article gives you an overview of the AWS Lambda function to automatically start and stop AWS RDS SQL Server.

How to stop an AWS RDS SQL Server using a web console and AWS CLI

June 11, 2020 by Rajendra Gupta

This article explores the process to stop an AWS RDS SQL Server using web console and AWS CLI.

Difference between Unique Indexes and Unique Constraints in SQL Server

June 10, 2020 by Rajendra Gupta

This article gives you an overview of Unique Constraints in SQL and also the Unique SQL Server index. Along the way, we will look at the differences between them.

An overview of computed columns in SQL Server

June 9, 2020 by Rajendra Gupta

In this article, we will explore computed columns in SQL Server and their configurations.

SQL Server Choose() function introduction and examples

June 5, 2020 by Rajendra Gupta

In the article, a CASE statement in SQL, we explored one of the important logical expressions – the Case statement in SQL Server to return the values based on the specified condition. Today, we will talk about another useful logical Choose() function in SQL Server 2012 onwards and its comparison with the Case statement.

Using SSIS packages to add row headers and data into flat files

June 4, 2020 by Rajendra Gupta

In this article, we will configure an SSIS package to generate a composite output in the flat-file destination.