How to Write Simple SQL Queries from a Blank Database

Total: 1 Average: 5

This article explains writing simple SQL queries from the most basic ones and gradually improving the script to solve some mathematical and date-related problems. Additionally, we are going to clarify the concepts surrounding SQL queries.

Although this article is primarily for beginners, it contains hints that will be helpful for any experience level.

Read More

SQL Server DELETE – Removing One or More Rows from a Table

Total: 0 Average: 0

The right application of the DELETE statement for data removal is crucial, and it involves lots of issues. Still, there are standard practices of the DELETE statement usage that simplify all such tasks.

This article will explore some of the professional life scenarios to equip you with the most helpful tips to use the DELETE statement correctly.

Read More

Basics of SQL Server Management Studio (SSMS) – Part 1

Total: 1 Average: 5

This article aims to share the basics of SQL Server Management Studio, commonly known as SSMS, and some useful tips on working with it. Also, it highlights the importance of SSMS as database development and administration tool.

About SQL Server Management Studio

It is always good to clarify the SSMS definition(s) first. Let’s review some of the definitions from the database perspective.

Read More

Database Design Concepts with SQL Server Management Studio (SSMS) Part 1

Total: 0 Average: 0

This article is primarily written for beginners. Still, it covers some interesting and often forgotten database designing concepts that are equally attractive for SQL database professionals.

The current part focuses on the database designing concepts and their mapping to SQL Database tables, columns, and relationships. If you understand the backgrounds of databases and tools we are about to use, you will design your first SQL database with confidence.

Read More

Handling the NULL Values Effectively with the SQL COALESCE Function for Beginners

Total: 1 Average: 5

This article aims to help beginners understand the basics of the T-SQL COALESCE function and its application for handling NULL values. Additionally, the readers will get hands-on experience by implementing some simple examples of this function.

We’ll also highlight the importance of T-SQL functions in resolving database analytical problems.

Read More

Mastering the Use of Stoplists With SQL Server Full-Text Search (FTS)

Total: 1 Average: 5

Creating and managing stoplists serves as one of the main components responsible for improving the Full-Text Search performance alongside reducing the size of the index. This article aims to help you master the job in-depth and implement multiple strategies to create stoplists on simple but interesting examples.

We’ll also highlight the importance of different methods to generate stoplists and clarify how to choose the most suitable method.

Read More