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...
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...
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...
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...
How to use Stopwords and Stoplist to improve SQL Server Full-Text Search (FTS)
The current article is about Stopwords and Stoplist usage. The aim is to make Full-Text Search more efficient in terms of storage and...
Storing and Analyzing Documents on Windows File System with SQL Server Semantic Search – Part 2
This is the second part of the material dedicated to SQL Server Semantic Search. In the previous...
Understanding Text Mining with SQL Example
The current article focuses on the conceptual understanding of Text Mining. It gives clear examples and teaches us to use the T-SQL script...
Learn to Store and Analyze Documents on Windows File System with SQL Server Semantic Search – Part 1
The article examines storing unstructured data using native windows directory structure and managing it through the SQL Server database....
How to Use Semantic Search in SQL Server
This article deals with the basics of Semantic Search, including a complete walkthrough of Semantic...