SQL Server

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...
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 be integer, float, Varchar, NVARCHAR,...
Read More

User-Defined Data Types In SQL Server

SQL Server

Introduction SQL Server platform comes with many data types, but there are cases when they are not sufficient. Or, custom data types could...
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....
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

The LINQ GroupBy Method

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

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

SUBSTRING Command in SQL: A Primer

SQL Server

Similar to my article regarding the SQL Server STUFF command, today we will be examining the SUBSTRING SQL server command. It is similar to...
Read More

Primary Keys in SQL Server

SQL Server

Across all major RDBMS products, Primary Key in SQL constraints has a vital role. They identify the records present in a table uniquely....
Read More

SQL Server System Databases – MSDB Maintenance

Database administation, Database Optimization & Structure, SQL Server

In the previous articles of the SQL Server System Databases series, we have gone through the System...
Read More
Close