Author: Haroon Ashraf

Haroon's deep interest in logic and reasoning at an early age of his academic career paved his path to become a data professional. He began his professional life as a computer programmer more than 10 years ago working on his first data venture to migrate and rewrite a public sector database driven examination system from IBM AS400 (DB2) to SQL Server 2000 using VB 6.0 and Classic ASP along with developing reports and archiving many years of data. His work and interest revolves around Database-Centric Architectures and his expertise include database and reports design, development, testing, implementation and migration along with Database Life Cycle Management (DLM).

Learn Database Design with SQL Server Management Studio (SSMS) – Part 2

Database development, SSMS, Tools & technologies

It is the second part of the series focused on the SQL Server Management Studio usage. You will...
Read More

A Practical Use of the SQL COALESCE Function

Database development, Statements

This article talks about the practical use of the SQL COALESCE function regarding some professional life scenarios. It highlights the...
Read More

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

Database development, SSMS, Tools & technologies

This article is primarily written for beginners. Still, it covers some interesting and often forgotten database designing concepts that are...
Read More

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

Database development, Statements, Tables

This article aims to help beginners understand the basics of the T-SQL COALESCE function and its...
Read More

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

Database administration, Search

Creating and managing stoplists serves as one of the main components responsible for improving the Full-Text Search performance alongside...
Read More

How to use Stopwords and Stoplist to improve SQL Server Full-Text Search (FTS)

Database administration, Search

The current article is about Stopwords and Stoplist usage. The aim is to make Full-Text Search more efficient in terms of storage and...
Read More

Storing and Analyzing Documents on Windows File System with SQL Server Semantic Search – Part 2

Database administration, Search

This is the second part of the material dedicated to SQL Server Semantic Search. In the previous...
Read More

Understanding Text Mining with SQL Example

Languages & Coding, T-SQL

The current article focuses on the conceptual understanding of Text Mining. It gives clear examples and teaches us to use the T-SQL script...
Read More

Learn to Store and Analyze Documents on Windows File System with SQL Server Semantic Search – Part 1

Database administration, Search

The article examines storing unstructured data using native windows directory structure and managing it through the SQL Server database....
Read More

How to Use Semantic Search in SQL Server

Database administration, Search

This article deals with the basics of Semantic Search, including a complete walkthrough of Semantic...
Read More
Close