Author: Rajendra Gupta

Rajendra Gupta is a Database Administrator with over 13 years of experience working with SQL Server, Azure, AWS, Power BI and related technologies. He loves writing and an author of 500+ technical articles. He is also a writer of the book " DP-300 Administering Relational Databases on Microsoft Azure."

An Overview of PgAdmin Tool for Postgres

09:57 Code Management, Languages & Coding, Tools & technologies

The PgAdmin is a popular tool for the open-source database – Postgres or PostgreSQL. It provides...
Read More

Manage Transaction Concurrency Using Locks in SQL Server

11:07 Database administation, Security

In a multi-user environment, it is essential to maintain truncation concurrency. These locks are in-memory structures of 96 bytes in size....
Read More

Guide for CTE in SQL Server

11:31 Database development, Tables

The Common Table Expression aka CTE in SQL Server provides a temporary result set in T-SQL. You can refer to it within a SQL Select, SQL...
Read More

VARCHAR and NVARCHAR Data Types in SQL Server

11:40 Database administation, Work with data

Relational databases represent an organization’s data in tables that use columns with different...
Read More

Upload Files to AWS S3 with the AWS CLI

09:39 AWS, Cloud

Introduction Amazon Web Service, aka AWS, is a leading cloud infrastructure provider for storing your servers, applications, databases,...
Read More

Introduction to Synonyms in SQL Server

12:19 Database administation, SQL Server, Work with data • One Comment

A synonyms in SQL Server are database objects that give an alternative name to the database objects existing locally or on the remote...
Read More

What is SQL Server Express? Definition, Benefits and Capabilities

09:55 Code Management, Tools & technologies

SQL Server Express is a free lightweight edition of SQL Server with limited functionality,...
Read More

SQL Server BIT Datatype – Ultimate Guide

17:47 Database administation, Work with data

Introduction to Bit Data Type The data type represents an attribute that stores integer, character, data time, binary data. Suppose you...
Read More