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)

Database level roles in Azure SQL Database - April 12, 2022
Fixed Server Roles in Azure SQL Database Server - April 6, 2022
SQL Server Dedicated Administrator Connections for Azure SQL Database - March 29, 2022

How to set custom colors in the SSMS status bar

February 19, 2020 by Rajendra Gupta

This article explains the process of defining custom color codes for SQL Server connections in SSMS.

Methods to script SQL Server database objects

February 14, 2020 by Rajendra Gupta

In this article, we will explore various ways for scripting SQL Server database objects.

Importing a BACPAC file for a SQL database using SSMS

February 6, 2020 by Rajendra Gupta

This article gives you an overview of BACPAC package and its usage in SQL Database data refresh (data import and export) using SQL Server management studio.

Web URL configuration in a Power BI Desktop report

February 6, 2020 by Rajendra Gupta

Power BI Introduction

Power BI Desktop provides many useful visualizations with simple configurations. You can represent data visually in different forms that help users and management in data interpretation. You can explore a broad category of Power BI articles here on SQLShack.

Drop unwanted (secondary) SQL Server transaction log files

January 31, 2020 by Rajendra Gupta

This article explores the use of multiple SQL Server Transaction Log Files and the process of removing the secondary transaction log file.

Move a SQL database using the detach and attach method

January 29, 2020 by Rajendra Gupta

This article explores the process of moving a SQL database using the detach and attach method.

The Decomposition Tree in Power BI Desktop

January 24, 2020 by Rajendra Gupta

Introduction

Power BI is enriched with many useful visualizations and helps to represent data in various forms. We have explored many use cases of PowerBI in SQLShack articles.

Estimating AWS RDS SQL Server costs

January 23, 2020 by Rajendra Gupta

This article explores estimating the AWS RDS SQL Server cost so that you can plan resources accordingly.

Auditing in AWS RDS SQL Server

January 20, 2020 by Rajendra Gupta

This article explores the server and database audit in AWS RDS SQL Server.

Import JSON data into SQL Server

January 17, 2020 by Rajendra Gupta

This article explores the process of JSON data import in the SQL Server table using T-SQL and SSIS.

Access PostgreSQL databases using the Azure Data Studio extension

January 16, 2020 by Rajendra Gupta

This article installs PostgreSQL on Ubuntu 16.4 operating system and connects the database using Azure Data Studio.

Overview of Non-Clustered indexes in SQL Server

January 16, 2020 by Rajendra Gupta

This article gives an introduction of the non-clustered index in SQL Server using examples.

An overview of the column level SQL Server encryption

January 14, 2020 by Rajendra Gupta

This article gives an overview of column level SQL Server encryption using examples.

Generate data scripts using SSMS and Azure Data Studio

January 13, 2020 by Rajendra Gupta

This article explores different ways to generate data scripts using Azure Data Studio and SQL Server Management Studio.

SQL Server Linux installation for Amazon EC2 instance with Red Hat OS

January 9, 2020 by Rajendra Gupta

This article installs SQL Server on Linux on the Amazon EC2 instance with Red Hat OS prepared in the earlier article.

Encrypting passwords with Python Scripts in SQL Notebooks of Azure Data Studio

January 6, 2020 by Rajendra Gupta

This article explores the Python scripts for encrypting and decrypting passwords in SQL Server using Azure Data Studio SQL Notebooks.

Use Python SQL scripts in SQL Notebooks of Azure Data Studio

December 25, 2019 by Rajendra Gupta

This article explores the Python SQL scripts in SQL Notebook of Azure Data Studio.

Overview of SQL Server Clustered indexes

December 23, 2019 by Rajendra Gupta

This article targets the beginners and gives an introduction of the clustered index in SQL Server.

Database Administration Tool Extension for Windows in Azure Data Studio

December 17, 2019 by Rajendra Gupta

Azure Data Studio provides a modern and productive experience for managing on-premise and cloud-based SQL Server instances. Previously, we discussed many useful features of it, and you can explore these articles in Azure Data Studio category.