Rajendra Gupta

About
Latest Posts

Rajendra Gupta

Rajendra has 8+ years of experience in database administration having a passion for database performance optimization, monitoring, and high availability and disaster recovery technologies, learning new things, new features.

While working as a Senior consultant DBA for big customers and having certified with MCSA SQL 2012, he likes to share knowledge on various blogs.
He can be reached at rajendra.gupta16@gmail.com

View all posts by Rajendra Gupta

Latest posts by Rajendra Gupta (see all)

Overview of DBCC INPUTBUFFER and sys.dm_exec_input_buffer DMF - November 7, 2019
Exploring the SandDance Visualizations extension in Azure Data Studio - November 6, 2019
A handy SQL Notebook for the purposes of troubleshooting in Azure Data Studio - November 5, 2019

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.

SQL TRIM function

April 24, 2019 by Rajendra Gupta

In this article, we will review the new SQL TRIM function in SQL Server 2017 onwards as well as providing some information on strings functions that pre-date it like LTRIM AND RTRIM.

DATEPART SQL function

April 23, 2019 by Rajendra Gupta

This article explores the DATEPART SQL function and its use in writing t-SQL queries. In the previous article, SQL Convert Date Functions and Formats, we explored various data formats and convert them using SQL Convert function.

SQL Add Column operations

April 22, 2019 by Rajendra Gupta

This article explains the SQL add column operation into an existing SQL table. We will also explore different examples of SQL add column operations.

SQL Union vs Union All in SQL Server

April 18, 2019 by Rajendra Gupta

This article explains to the SQL Union and vs Union All operators in SQL Server. We will also explore the difference between these two operators along with various use cases.

SQL OUTER JOIN overview and examples

April 16, 2019 by Rajendra Gupta

This article will provide a full overview, with examples of the SQL Outer join, including the full, right and left outer join as well as cover the union between SQL left and right outer joins.

SQL Code Snippets in Azure Data Studio

April 16, 2019 by Rajendra Gupta

This article will fully cover the code snippet SQL developer productivity feature in Azure Data Studio including a list of available snippets and examples of how to create custom code snippets

INSERT INTO SELECT statement overview and examples

April 12, 2019 by Rajendra Gupta

This article covers the SQL INSERT INTO SELECT statement along with its syntax, examples and use cases.

SQL PARTITION BY Clause overview

April 9, 2019 by Rajendra Gupta

This article will cover the SQL PARTITION BY clause and, in particular, the difference with GROUP BY in a select statement. We will also explore various use case of SQL PARTITION BY.

SQL Order by Clause overview and examples

April 9, 2019 by Rajendra Gupta

This article will cover the SQL ORDER BY clause including syntax, usage scenarios to sort out results in a Select statement.

Validate backups with SQL restore database operations using DBATools

April 8, 2019 by Rajendra Gupta

In this article, we will explore database backup validation by with SQL restore database operations using DBATools.

SQL SELECT INTO statement

April 5, 2019 by Rajendra Gupta

This article will cover the SQL SELECT INTO statement including syntax, parameters and use with multiple tables, filegroups and a WHERE condition

SQL Convert Date functions and formats

April 3, 2019 by Rajendra Gupta

In this article, we will explore various SQL Convert Date formats to use in writing SQL queries.

SQL Restore Database using DBATools

April 3, 2019 by Rajendra Gupta

This article will cover SQL restore database operations using the open-source PowerShell module, DBAtools, and will cover commands for backup restoration using the command Restore-DBABackup with many various permutations like restoring from file, separate directory, renaming databases, norecovery options and more

CASE statement in SQL

April 1, 2019 by Rajendra Gupta

The case statement in SQL returns a value on a specified condition. We can use a Case statement in select queries along with Where, Order By and Group By clause. It can be used in Insert statement as well. In this article, we would explore CASE statement and its various use cases.