Manage MDF Files in SQL Server 2019
An SQL Server database contains primary data files, secondary data files (optional), and...
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 learn the database design core concepts and...
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...
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 forgotten database designing concepts that are...
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...
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 using SQL Server. They said it was bad...
Add Columns to an Existing Table in SQL Server Database
Introduction A table is a two-dimensional logical structure and the fundamental means of storing...
