Latest Articles

ping command is one of the most used commands in Linux. It is mostly used to check the connectivity between local and remote server. In most cases ICMP traffic is not impacted by firewall so this is very much reliable. …

25 ps command examples used in Linux to monitor the running processes. Complete cheat sheet of ps command with practical examples.

lvcreate command is used to create different types of Logical Volumes in Linux. You can create linear, striped, mirrored logicla volumes. You can also create snapshot volumes used for backup and restore purpose.

lvchange command allows you to change attributes of a logical volume in the volume group. You can perform different operations such as activate/deactivate, change access permission and set/reset contiguous allocation …

lvremove command is used to remove a logical volume from a volume group in Linux

lvscan command scans for all logical volumes in the Linux system and lists them. It displays the status, path, size, and allocation policy in one line per

Step by Step instructions to understand golang testing and write unit tests in go code.

We have covered an overview of combine string rows, list out all three methods of combining rows into one string which are using COALESCE, USING XML PATH, and using string_AGG methods

Use crunch as wordlist generator or generating password strings for brute force attacks

Step by Step instructions to install ARPACK on RedHat, Arch and Debian based Linux distribution.

We can use max smbd processes parameter in smb.conf to modify smbd process limit in Linux

In this article of select duplicate records in SQL, we have covered an overview of SQL duplicate records, steps to select duplicate records in SQL , why to

The SQL INNER JOIN clause allows you to query data from multiple tables. It returns all rows from Table1, Table2, and Table 3 so on with exact matching rows from all tables.

Different types of SQL Date Functions explained with examples. Some SQL Date Functions are similar in most database management systems. Few SQL Date Functions like CURDATE() and GETDATE() does the same functionality but …

Data stored in the database is logically stored in data tables, using SQL Create Table statement we can create data tables in the database management system

The GROUP BY clause is part of SQL SELECT statement. Optionally it is used in conjunction with aggregate functions to produce resulting group of rows from the database. SQL GROUP BY clause is placed after the WHERE …

SQL like comparison operator is used to compare or to manipulate text with regular expression. There is a condition where we need to fetch records which do not match with pattern, in such situation we need to use SQL NOT …

SQL mainly provides three truncate functions which are working with string. SQL Substring Function, SQL Left Function, SQL Right Function

The SQL Server Coalesce() function is a basic SQL function which is used to evaluate the list of values and return the first occurrence of non-NULL value. The SQL Server Coalesce and IsNull functions both are used to …

SQL COUNT, AVERAGE and SUM are most commonly used aggregate functions of SQL.

SQL Union Operator or clause is a one of the SQL Set operators which is used to merge or combine two or more SQL Select Query results into single result set.

Examples to use SQL LEFT JOIN Multiple tables. In SQL Left join, if a specific row is present in the left table but not in the right, the result will include this row but with a NULL value in each column from the right. …

The SQL NOT NULL constraint on an attribute or column specifies that the NULL value is not allowed for that attribute, in other word, the constraint in SQL excludes the null value from the domain of that column values.

Concat SQL function is used to concatenate strings. difference between SQL concat and SQL concat_ws.

The SQL WITH clause allows you to give the name to the output of referenced in subsequent queries, this process is interchangeably called as common table expression (CTE) or sub-query refactoring,

SQL Distinct with SQL select statement, on one column and on multiple columns, difference between SQL Distinct and Group By clause and SQL Distinct with SQL Unique constrain and SQL distinct with Order By has explained …

SQL between syntax and examples. Using with update and delete statement. SQL NOT between examples and syntax, SQL Between Range with Numeric values

SQL REPLACE performs comparisons based on the collation of the input. To perform a comparison in a specified collation, you can use COLLATE to apply an explicit collation to the input

Practical examples of SQL RANK function with a single table, multiple tables, with partition argument and ORDER BY ASC and DESC, also mention an example of SQL RANK Function with Where a condition

practical examples to use sql if statement explained. Use multiple if conditions, sql if else condition, sql nested if else condition with examples