SQL Server

SQL Server DBA Interview Questions and Answers – Part 2

SQL Server

This article is in sequence with my last article where I have covered SQL Server interview...
Read More

SQL Server DBA Interview Questions and Answers – Part 1

SQL Server

This article will help you to prepare for SQL Server interviews. I have explained various popular SQL Server interview questions and...
Read More

The Difference Between UNION and UNION ALL

SQL Server, Uncategorized

Twice in the last six months, I have had to get involved in the resolution of an incident associated with active database tables growing 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...
Read More

How to Change Default MySQL Port in Windows 10

SQL Server

A network port is a communication endpoint used by applications, incoming connections, and external devices to the computer/server or...
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

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

User-Defined Data Types In SQL Server

SQL Server

SQL Server platform comes with many data types, but there are cases when they are not sufficient. Or, custom data types could help make...
Read More

Varchar To Date Conversions In SQL Server

SQL Server

Introduction In many scenarios, date and time information is loaded and stored in the text format. Converting these values to the date/time...
Read More

A Cartesian Product in SQL – Work Scenario Application

SQL Server

A Cartesian Product is a product of two sets of elements where each element in one set is...
Read More
Close