Using SQL Server Configuration Manager
Introduction SQL Server Configuration Manager is a part of SQL Server Suite, allowing us to...
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 2019 work on Microsoft Windows and Linux....
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...
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. Those queries make the time of execution...
Synthetic Data Generation
Introduction Sooner or later, any information system gets a database, often – more than one. With...
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 Full-Text Search performance alongside...
Your Ultimate Guide to SQL Join: INNER JOIN – Part 1
Inner join, outer join, cross join? What gives? It’s a valid question. I once saw a Visual Basic...