How to Install Ubuntu 18.04 and SQL Server 2019 on Linux
The previous article explained the creation of a virtual machine using Oracle VM Virtual machine....
Using SQL Server Configuration Manager
Introduction SQL Server Configuration Manager is a part of SQL Server Suite, allowing us to configure the options external to the database...
Handling the NULL Values Effectively with the SQL COALESCE Function for Beginners
This article aims to help beginners understand the basics of the T-SQL COALESCE function and its application for handling NULL values....
Сreating a Virtual Machine With Oracle VM Virtual Box
Microsoft announced cross-platform support of SQL Server – the SQL Server 2017 and SQL Server...
Your Ultimate Guide to SQL Joins: OUTER JOIN – Part 2
Outer join is at the center stage today. And this is part 2 of your ultimate guide to SQL joins. If you missed part 1, here’s the...
Views in SQL Server
Introduction A view in SQL Server is a virtual table-like structure based on the result-set of an SQL statement. On the surface, a view is...
How CTE Can Aid In Writing Complex, Powerful Queries: A Performance Perspective
We often see poorly written complex SQL queries running against a table or tables in databases....
Synthetic Data Generation
Introduction Sooner or later, any information system gets a database, often – more than one. With time, that database gathers very much...
Using CASE Expressions in SQL Server
Introduction CASE Expressions in SQL Server are used for the column values substitution to present the result sets in a particular fashion...
Mastering the Use of Stoplists With SQL Server Full-Text Search (FTS)
Creating and managing stoplists serves as one of the main components responsible for improving the...
