The Cartesian Product in SQL
Cartesian product in SQL is a term from the set theory of mathematics. However, we can also find...
Clustered and Non Clustered Index: 7 Top Points Explained
Indexes are speed-boosters in SQL databases. They can be clustered or non-clustered. But what does it mean and where should you apply...
Simple SQL Server Functions to Solve Real-World Problems
Introduction Today’s article comes from a scenario we experienced in practice some time ago. We managed a card transaction system...
MySQL UPDATE: Top 5 Tips for T-SQL Developers
Are you adding MySQL to your list of database skillsets? Then MySQL UPDATE statement is one of the...
SQL DEFAULT Constraint to Insert Column with a Default Value to SQL Server Table
To insert data into a table having columns with default constraints, we can use the DEFAULT constraint to a default value in a table. This...
Install SQL Server 2019 Ubuntu Linux Server Step by step
After exploring the processes of building a virtual machine to install Ubuntu Linux 18.04 (refer to the step-by-step guideline about...
Installing Ubuntu 18.04 for SQL Server 2019 on Virtual Machine Using VMware Workstation
Microsoft has been supporting SQL Server for Linux-based operating systems since the SQL Server...
Understanding of SQL Server UPPER Function
There are many cases of SQL lowercase that we need to change for our purposes. For instance, we have keywords or strings of characters in...
Understanding SQL DELETE Column from Table
Adding and removing columns are among the most common tasks when you manage tables in databases. And it might seem strange, but many users...
Understanding DROP TABLE IF EXISTS SQL Statement
The T SQL DROP TABLE IF EXISTS statement is used to drop existing database objects. In this...
