The Difference Between UNION and UNION ALL

SQL Server

Twice in the last six months, I have had to get involved in the resolution of an incident...
Read More

SQL Server PIVOT Operator

SQL Server

In SQL Server, PIVOT is a powerful operator to transpose table values in the rows format to table values in column format. In this article,...
Read More

How to Connect MySQL Workbench to MariaDB

MySQL, Tools & technologies

To use MySQL Workbench as a GUI for MariaDB? If you’re filled with disbelief right now, you’re not alone. Though Michael...
Read More

An Overview of SQL LIKE Statement and Its Use Cases

SQL Server

SQL LIKE statement is used to search a similar phrase or pattern in a column. It supports ASCII and...
Read More

SQL IN operator

SQL Server

The SQL IN statement matches a specified value from a list or subquery. It reduces our efforts to write various OR statements with equal to...
Read More

Syntax of LINQ GroupBy Method in C#

SQL Server

We are continuing our series dedicated to LINQ technologies with a more detailed look at some methods available under the LINQ umbrella....
Read More

Different types of LINQ queries: Query Syntax and Method Syntax

Languages & Coding

The current article continues the series about LINQ. The previous part introduced the LINQ...
Read More

SQL Aggregate Functions: Easy Tips for Newbies

Database development, Statements

SQL Aggregate Functions are functions that perform calculations and return a summarized result. With these, it’s easy to do these...
Read More

How to Build a Simple Data Warehouse in Azure – Part 2

Azure, Cloud, Microsoft Azure

This is the second part of the three-part article which aims to help both beginners and professionals in designing a simple but fully...
Read More

Tutorial Guide to Spark SQL: Great Tool for a Big Data Engineer

Frameworks, Languages & Coding

Understanding Spark SQL is extremely helpful for analyzing big data, especially when you’re...
Read More
Close