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 use the CROSSTAB function in PostgreSQL - February 17, 2023
Learn the PostgreSQL COALESCE command - January 19, 2023
Use of the RESTORE FILELISTONLY command in SQL Server - December 21, 2022

How to use the CROSSTAB function in PostgreSQL

February 17, 2023 by Rajendra Gupta

This article will explore the use of the CROSSTAB function in PostgreSQL.

Learn the PostgreSQL COALESCE command

January 19, 2023 by Rajendra Gupta

This article will make you learn the Postgres Coalesce command with examples.

Use of the RESTORE FILELISTONLY command in SQL Server

December 21, 2022 by Rajendra Gupta

This article explores the RESTORE FILELISTONLY command in SQL Server with examples.

Introduction

Performing a database backup is an integral part of a DBA’s job. Backups are taken to ensure that data can be recovered in an emergency. There are different restore mechanisms, and the SQL Server DBA needs to understand them to make the right decision in each situation.

How to add or subtract dates in SQL Server

December 15, 2022 by Rajendra Gupta

This article explores SQL Server functions to add or subtract dates in SQL Server.

Different SQL TimeStamp functions in SQL Server

November 25, 2022 by Rajendra Gupta

This article will show different SQL timestamp functions available with examples.

How to identify suitable SKUs for Azure SQL Database, Managed Instance (MI), or SQL Server on Azure VM

October 28, 2022 by Rajendra Gupta

The database migration from on-premises to Azure cloud can be complicated in choosing the best SKU for Azure SQL Database, Managed Instance (MI), or SQL Server on Azure VM. Every database might have different resource requirements, and we need to choose the correct DB sizing based on the current workloads.

Copy data from AWS RDS SQL Server to Azure SQL Database

October 21, 2022 by Rajendra Gupta

This blog will share with you a way to copy data from an AWS RDS SQL Server database to an Azure SQL database.

Rename on-premises SQL Server database and Azure SQL database

October 18, 2022 by Rajendra Gupta

This article explores how to rename Azure SQL Database and on-premises SQL instance database.

SQL Commands to check current Date and Time (Timestamp) in SQL Server

October 7, 2022 by Rajendra Gupta

This article explores different SQL Commands (functions) to return the current Date and Time (Timestamp) in SQL Server.

Exploring Azure SQL Database Geo-Restore

September 2, 2022 by Rajendra Gupta

This article explains Azure SQL Database Geo Restore using geo-replicated backups for disaster recovery.

Deploy a SQL Server container using Azure Kubernetes Services (AKS)

August 31, 2022 by Rajendra Gupta

This article deploys a SQL Server container using Azure Kubernetes Services (AKS).

Deploy Azure SQL Elastic Pools for Azure SQL Database

August 23, 2022 by Rajendra Gupta

This article gives an overview and deployment steps for SQL Elastic Pool for Azure SQL database.

Rebuild system databases for SQL Server on Linux and Windows

August 15, 2022 by Rajendra Gupta

This article explores the process for rebuilding system databases – Master, MSDB, and Model for SQL Server on Linux and Windows.

Configure cross-platform SQL Server Always On Availability Groups

August 10, 2022 by Rajendra Gupta

This article for the Always On Availability Groups series will show how to configure SQL Server Always On Availability Groups between Windows and Linux SQL instances.

SQLPackage utility to export Azure SQL Databases

August 1, 2022 by Rajendra Gupta

Azure SQL Database does not support native database backups. Therefore, you cannot use it to move from the Azure cloud to on-premises SQL Server. You can use the data-tier application BACPAC file format for exporting database schema and data from the Azure database. This BACPAC file is helpful to deploy on an Azure SQL Database, Managed Instance, and on-premises SQL Server.

Azure SQL Interview Questions and Answers

July 13, 2022 by Rajendra Gupta

Interested in becoming an Azure SQL DBA but don’t know how to start? This article prepares you for the Azure SQL DBA interview by providing reference material links.

Notebook Views for SQL Notebooks in Azure Data Studio

June 15, 2022 by Rajendra Gupta

We are excited to share that Notebook Views are available for SQL Notebooks in the Azure Data Studio (Currently Insiders release). This article will cover the following topics:

What are Notebook Views?
Where can you find Notebook Views?
How do you create a new view?
How do you modify an existing view?
Where can you see database objects in the view?
Where can you see table data in the view?
Where can you see query results in the view?

Exploring the SQL WHERE statement

June 9, 2022 by Rajendra Gupta

This article will talk about the SQL WHERE statement.

Database level roles in Azure SQL Database

April 12, 2022 by Rajendra Gupta

This article explores the database-level roles in the Azure SQL Database.

Fixed Server Roles in Azure SQL Database Server

April 6, 2022 by Rajendra Gupta

This article is for discussing fixed server roles in Azure SQL Database Server.

SQL Server Dedicated Administrator Connections for Azure SQL Database

March 29, 2022 by Rajendra Gupta

This article explains SQL Server Dedicated Administrator Connections and how you can use it for Azure SQL Database.

Azure SQL Database Connectivity architecture

March 24, 2022 by Rajendra Gupta

The article Configure IP firewall rules for Azure SQL Databases, discuss the configuring server and database IP firewall rules for Azure databases. In this article, we will explore setting applicable to Azure databases that control connectivity to the database.

Configure IP firewall rules for Azure SQL Databases

March 18, 2022 by Rajendra Gupta

The Azure SQL Database provides high performance, secure and reliable managed relational database service. Security is the prime focus area in both on-premises and cloud infrastructure while designing the database infrastructure.

Azure Functions for Azure SQL Database

March 10, 2022 by Rajendra Gupta

As a Platform as a Service (PaaS) service, Azure SQL Database enables developers to deploy SQL Database in Azure Cloud without managing the infrastructure. We use SQL Server Agent to schedule jobs to run at a specific schedule in an on-prem SQL instance. However, Azure DB does not have agent functionality.

Connect Azure SQL Database using Python from Ubuntu

March 4, 2022 by Rajendra Gupta

Azure SQL Database or Managed instance is a Microsoft cloud offering for SQL Server in the managed cloud environment. Usually, we connect databases from SQL Server Management Studio, Azure Data Studio, or applications for query data.