Languages & Coding

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

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 working with the Spark platform. But what...
Read More

PgAdmin GUI client for PostgreSQL: Comprehensive Overview

Code Management, Languages & Coding, Tools & technologies

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

LINQ to Entities – Tutorial with Examples

Basics of C#, Languages & Coding

When we think about querying databases, the first thing that pops to mind is usually some SQL...
Read More

An Overview of the SQL Variables Usage

Languages & Coding, SQL Server, Uncategorized

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

Getting Started with the SQL Server T-SQL CASE Expression Statement

T-SQL

SQL Server CASE expression is very useful in returning an output based on some conditional matching criteria. We can state multiple...
Read More

SQL Server JSON – Part 2

JSON, Languages & Coding

Introduction In the previous article, we covered the basics of JSON and showed how to use JSON in...
Read More

JSON for SQL Server. Part 1

JSON, Languages & Coding

In the last few years, JSON has positioned itself as a standard data exchange format between services, although XML is still widely used....
Read More

XML Made Easy – LINQ to XML

ASP .NET CORE, Languages & Coding, Uncategorized

LINQ to XML is an in-memory XML programming interface that enables XML manipulation. Similar to the more traditional Document Object Model...
Read More

Query JSON Data with SQL/JSON Functions & Autonomous Database

JSON, Languages & Coding

In the previous article, we worked on the Twitter Activity dataset in JSON format with the SQL...
Read More
Close