An Overview of the SQL Variables Usage
The SQL variable is a local variable that can store a single data value temporarily. Its lifecycle...
Exploring SQL Server LEN() Function
SQL Server supports different data types to store relevant data in SQL tables. These data types can be integer, float, Varchar, NVARCHAR,...
Deploying Azure Synapse Analytics Workspaces
In the article, An Overview of the Azure Synapse Analytics, we explored the Azure Synapse workspace and its features as an analytics...
An Overview of the Azure Synapse Analytics
The Azure Synapse Analytics is an analytics service that brings together Big data analytics and...
An Overview of PgAdmin Tool for Postgres
The PgAdmin is a popular tool for the open-source database – Postgres or PostgreSQL. It provides various graphical user interfaces for...
Manage Transaction Concurrency Using Locks in SQL Server
In a multi-user environment, it is essential to maintain truncation concurrency. These locks are in-memory structures of 96 bytes in size....
Guide for CTE in SQL Server
The Common Table Expression aka CTE in SQL Server provides a temporary result set in T-SQL. You can...
VARCHAR and NVARCHAR Data Types in SQL Server
Relational databases represent an organization’s data in tables that use columns with different data types allowing them to store valid...
Upload Files to AWS S3 with the AWS CLI
Introduction Amazon Web Service, aka AWS, is a leading cloud infrastructure provider for storing your servers, applications, databases,...
Introduction to Synonyms in SQL Server
A synonyms in SQL Server are database objects that give an alternative name to the database objects...