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)

Export Amazon Aurora MySQL or Amazon RDS snapshots to AWS S3 buckets - January 19, 2021
SQL Server PolyBase external tables with Azure Blob Storage - January 15, 2021
Database Cloning in Amazon Aurora - January 11, 2021

Script SQL Server objects using DBATools

June 20, 2019 by Rajendra Gupta

This article gives an overview to generate scripts for SQL Server objects with Windows PowerShell tool DBATools.

Database administrators or developers require generating scripts for SQL Server objects. We might need scripts to store a copy of object script before object change, create specific objects into other database environments such as development, UAT or non-prod environment. It is an excellent practice to keep a copy of the object before making a change to it. We can easily refer to the old script and roll back if required. Usually, we use SSMS Generate Scripts wizard to get these scripts.

Isolation levels behavior in SQL Server Always On Availability Groups

June 18, 2019 by Rajendra Gupta

In my previous article, Data synchronization in SQL Server Always On Availability Groups, we explored the internal data synchronization for both Asynchronous and Synchronous data commit mode. In the following image, on the secondary replica, we can see two important processes.

Automatic Seeding in Always On Availability Groups

June 18, 2019 by Rajendra Gupta

Introduction

In SQL Server Always On Availability Groups, we can add a database into an existing availability group using different methods. We get the following option in the Initial Data Synchronization wizard in SSMS.

Overview of SQL Server Ports

June 17, 2019 by Rajendra Gupta

This article is useful for a beginner in SQL Server administration and gives insights about the SQL Server Ports, the methods to identify currently configured ports.

Overview of SQL IIF Statement

June 12, 2019 by Rajendra Gupta

SQL Server 2012 introduced a new built-in logical function SQL IIF. It is a shorthand form of writing CASE statement logic or IF-ELSE logic.

SQL Between Operator overview and examples

June 11, 2019 by Rajendra Gupta

We extract data from SQL Server tables along with various conditions. Usually, we have data in large amounts and SQL Between operator helps to extract a specific range of data from this huge data. For example, suppose we want to know the product sales between Jan 2019 to May 2019. In this case, we can use this operator in a SQL query.

SQL Not Equal Operator introduction and examples

June 6, 2019 by Rajendra Gupta

This article explores the SQL Not Equal comparison operator (<>) along with its usage scenarios.

Get-DbaHelpIndex command in DBATools

June 5, 2019 by Rajendra Gupta

DBATools is an open-source PowerShell that contains a collection of useful commands. In this series of articles on DBATools (see TOC at the bottom) we performed installation of it. We also explored commands to do database backups, database restoration, Identity column maximum range threshold and create a SQL database.

Identity function tutorial in SQL Server

June 3, 2019 by Rajendra Gupta

This article explores the Identity function in SQL Server with examples and differences between these functions.

Get SQL Database details using DBATools

June 3, 2019 by Rajendra Gupta

In the series of articles on DBATools, (see TOC at the bottom) we are exploring useful DBATools command to perform administrative SQL tasks. In this article, we will explore useful commands to interact with SQL Server.

Read Scale Availability Group in a clusterless availability group

May 27, 2019 by Rajendra Gupta

In this article, we will explore configuring Read Scale Availability Group that does not require a failover clustering configuration. It helps to scale read-only connections to the secondary replica in a cluster less configuration.

SQL Server Statistics in Always On Availability Groups

May 27, 2019 by Rajendra Gupta

Introduction to SQL Server Statistics

SQL Server Statistics are an essential part of query performance in SQL Server. They help the query optimizer to prepare a query plan using the distribution of values in participating rows. If we do not have updated statistics, it might lead to resource intensive query execution plan. For example, for a large table having a billion records, SQL may choose to have an index scan instead of an index seek.

Creating a SQL Server Database using DBATools

May 23, 2019 by Rajendra Gupta

DBATools is an open source PowerShell module with useful commands to do the administrative task in SQL Server. In my earlier articles on DBATools (see TOC at the bottom) we explored installation and performing database backups, restoration, and validation with DBATools.

SQL IF Statement introduction and overview

May 20, 2019 by Rajendra Gupta

This article explores the useful function SQL IF statement in SQL Server.

SQL Notebooks introduction and overview

May 20, 2019 by Rajendra Gupta

This article explains the SQL Notebook feature in Azure Data Studio along with the Markdown language to customize it.

SQL Server CONCATENATE Operations with SQL Plus (+) and SQL CONCAT functions

May 13, 2019 by Rajendra Gupta

This article explores SQL Server Concatenate operations using the SQL Plus (+) operator and SQL CONCAT function.

SQL Server Always On Listeners

May 13, 2019 by Rajendra Gupta

This article on SQL Server Always On Listeners includes an overview and various connection configurations for specifying MultiSubnetFailover including SSMS, ODBC, ADO.NET, as well as MultiSubnetFailover limitations and how to connect to all IP addresses via RegisterAllProvidersIP.

SQL Server Always ON Availability Group Log Backup on Secondary Replicas

May 10, 2019 by Rajendra Gupta

In a high OLTP environment, we may observe strain on CPU and IO due to frequent backups. It might include further complexity due to backup compressions. SQL Server Always On Availability groups provides the capability to perform database backups from the secondary replicas. This article explores Log backups in SQL Server Always On Availability Group.

SQL ISNULL function

May 10, 2019 by Rajendra Gupta

This article explores the SQL ISNULL function to replace NULL values in expressions or table records with examples.

SQL Server Always On Availability Group Data Resynchronization

May 9, 2019 by Rajendra Gupta

In my previous article Data Synchronization in SQL Server Always On Availability Group, we described a scenario where if a secondary replica goes down in synchronous data commit mode, SQL Server Always on Availability group changes to asynchronous data commit mode. It ensures that users can get their transaction commit irrespective of waiting for a secondary replica to come online.

SQL CHARINDEX

May 9, 2019 by Rajendra Gupta

We use the SQL CHARINDEX function to find the position of a substring or expression in a given string. We might have a character in different positions of a string. SQL CHARINDEX returns the first position and ignores the rest of matching character positions in a string.

Data Sampling with Python SQL Scripts

May 9, 2019 by Rajendra Gupta

Introduction

The Python programming language is object oriented, easy to use and, widely used programming language. We can write simple Python SQL Scripts and it performs the task that is not easy to do with t-SQL.

DATEADD SQL function introduction and overview

May 6, 2019 by Rajendra Gupta

This article explores the DATEADD SQL function and its usage scenarios with various examples.

Data synchronization in SQL Server Always On Availability Groups

May 3, 2019 by Rajendra Gupta

This article describes the data synchronization process on SQL Server Always On Availability Groups in both Synchronous, and Asynchronous data commit mode.

Fix Orphan users in SQL Server using DBATools PowerShell

April 30, 2019 by Rajendra Gupta

This article gives an overview of Orphan users and fixing them using DBATools PowerShell.