Basics of SQL Server Management Studio (SSMS) – Part 1
This article aims to share the basics of SQL Server Management Studio, commonly known as SSMS, and...
Manage MDF Files in SQL Server 2019
An SQL Server database contains primary data files, secondary data files (optional), and transaction log files. The primary and secondary...
Make Awesome Lists Yourself, or GitHub as Notebook
This material was originally posted on Habr.com in Russian. The author permitted it to be translated and published on Codingsight. Perhaps,...
Learn Database Design with SQL Server Management Studio (SSMS) – Part 2
It is the second part of the series focused on the SQL Server Management Studio usage. You will...
Deploy SQL Server AlwaysOn Availability Groups on Linux
In the previous article, I explained how we could install Ubuntu 18.04 and SQL Server 2019 on the virtual machines. Now, before we proceed...
A Practical Use of the SQL COALESCE Function
This article talks about the practical use of the SQL COALESCE function regarding some professional life scenarios. It highlights the...
Database Design Concepts with SQL Server Management Studio (SSMS) Part 1
This article is primarily written for beginners. Still, it covers some interesting and often...
SQL Server Express Edition: Installation, Benefits, and Limitations
The SQL Server Express edition is a free version of SQL Server 2019. You can use it to deploy small applications and websites and monitor...
Your Ultimate Guide to SQL Join: CROSS JOIN – Part 3
CROSS JOIN is in the spotlight. This article finishes our small series of SQL JOIN-related publications. If you missed the previous two...
Top 3 Tips You Need to Know to Write Faster SQL Views
Friend or foe? SQL Server views have been a subject of heated debates when I was in my first year...
