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."

PgAdmin GUI client for PostgreSQL: Comprehensive Overview

Code Management, Languages & Coding, PostgreSQL, Tools & technologies

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

Upload Files to AWS S3 with the AWS CLI

AWS, Cloud

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

An Overview of the SQL Variables Usage

Languages & Coding, SQL Server

The SQL variable is a local variable that can store a single data value temporarily. Its lifecycle starts with declaration and ends with...
Read More

Exploring SQL Server LEN() Function

Database development, SQL Server, Statements

SQL Server supports different data types to store relevant data in SQL tables. These data types can...
Read More

Deploying Azure Synapse Analytics workspaces – How it works

Azure, Microsoft Azure

In the article, An Overview of the Azure Synapse Analytics, we explored the Azure Synapse workspace and its features as an analytics...
Read More

What is Azure Synapse Analytics? Complete Overview

Azure, Microsoft Azure

This post provides an overview of the Azure Synapse Analytics. It explains what it is and how it can be used....
Read More

Locking in SQL Server: Detailed Overview

Database administration, Security

In a multi-user environment, it is essential to maintain truncation concurrency. These locks are...
Read More

Guide for CTE in SQL Server

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

Database administration, Work with data

Relational databases represent an organization’s data in tables that use columns with different data types allowing them to store valid...
Read More

Introduction to Synonyms in SQL Server

Database administration, SQL Server, Work with data • One Comment

A synonyms in SQL Server are database objects that give an alternative name to the database objects...
Read More