SQL Server DBA Interview Questions and Answers – Part 2
This article is in sequence with my last article where I have covered SQL Server interview...
SQL Server DBA Interview Questions and Answers – Part 1
This article will help you to prepare for SQL Server interviews. I have explained various popular SQL Server interview questions and...
The Difference Between UNION and UNION ALL
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...
Syntax of LINQ GroupBy Method in C#
We are continuing our series dedicated to LINQ technologies with a more detailed look at some...
How to Change Default MySQL Port in Windows 10
A network port is a communication endpoint used by applications, incoming connections, and external devices to the computer/server or...
An Overview of the SQL Variables Usage
The SQL variable is a local variable that can store a single data value temporarily. Its lifecycle starts with declaration and ends with...
Exploring SQL Server LEN() Function
SQL Server supports different data types to store relevant data in SQL tables. These data types can...
User-Defined Data Types In 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...
Varchar To Date Conversions In 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...
A Cartesian Product in SQL – Work Scenario Application
A Cartesian Product is a product of two sets of elements where each element in one set is...
