Hadi Fadlallah

Posted on January 7, 2026

This paper introduces a knowledge-based approach to automate data quality assessment, addressing the limitations of traditional methods that overlook contextual data characteristics. By using knowledge graph embeddings, it predicts missing connections between a dataset’s context and relevant quality rules within a knowledge graph. This integration of diverse representations enables a... [Read More]

Posted on November 11, 2025

When working with SQL Server, sooner or later you’ll need to deal with JSON. APIs, log files, and even some third-party integrations send data in JSON format. The challenge is that JSON doesn’t map directly to tables. Especially when the data includes nested objects or arrays. [Read More]

Posted on October 24, 2025

Writing effective and precise SQL queries is a basic competency for database administrators and developers. The shift from general SQL concepts to T-SQL mastery is difficult for many students and even seasoned professionals. This article is a part of the “X in one hour” series that I am writing for... [Read More]

Posted on September 11, 2025

Data is usually the most important asset in organizations, but only SQL developers can frequently access that data. Technical teams often write queries for non-technical users. This restricts agility, slows decision-making, and creates a bottleneck in data accessibility. One possible remedy is natural language processing (NLP), which enables users to... [Read More]

Posted on September 4, 2025

A lot of online T-SQL interview questions are overly abstract and unrelated to practical applications. They frequently ignore how SQL is actually used in daily work in favor of concentrating on theoretical distinctions or basic syntax. This makes it challenging to assess a candidate’s ability to write effective, maintainable queries... [Read More]

Posted on July 7, 2025

In many conversations with my colleagues and other developers who work with different database engines, they often underestimate SQL Server. In my opinion, one of the key causes is that they didn’t work with the SQL Server Management Studio GUI to see how much easier it is to manage SQL... [Read More]

Posted on February 22, 2025

The widespread adoption of IoT devices and wireless sensor networks (WSNs) has revolutionized various domains leading to unprecedented data generation and connectivity. Thus, ensuring the quality of this data is crucial, as inaccuracies can pose major risks in mission-critical applications. Context awareness is also crucial in this regard since it... [Read More]

Posted on January 8, 2025

Many SQL developers encounter challenges when efficiently searching for data within a specific date range. This is especially difficult when dealing with large, partitioned or sharded tables. In this SQL tutorial, we look at different ways to write SQL to return data between date ranges. We will also see how... [Read More]

Posted on November 6, 2024

In a previous tip, we provided a data profiling script for SQL Server to collect information. The script was intended to collect information about the structure and data in a specific database. Still, the large number of columns in the result table made it harder to investigate and analyze the... [Read More]

Posted on October 17, 2024

In a bid to make decisions, obtain knowledge, or build applications, major institutions and individuals often have to retrieve and analyze large amounts of data from various websites, a gut-wrenching and siloed task that equally wastes time. Collecting and treating that data is tedious, prone to inaccuracies, and inefficient, especially... [Read More]

Posted on September 26, 2024

One of the best business intelligence tools is Microsoft’s Power BI, which makes it possible for organizations to interact with, understand, and make decisions using its data. It connects different sources of data (SQL Server on-premises, cloud databases, Salesforce, etc.), changes raw information into reports, apps and dashboards, and enables... [Read More]

Posted on July 18, 2024

The goal of this tutorial is to enable ETL developers to obtain practical knowledge to exploit SSIS in transforming and combining data through hands-on exploration to be ready for real-world challenges in managing information. We’ll examine and discuss some of the most essential components and functionalities. We will begin by... [Read More]

Posted on May 8, 2024

In this tutorial, we delve into several critical aspects of data quality management within the context of time-series data. We will use Python in this article to demonstrate working with time-series data.

Posted on April 23, 2024

In this article, we look at how to visualize time-series data using Excel with a walkthrough of how this is done with a sample dataset.

Posted on February 20, 2024

In this article, I’ll show you how to check out an app’s log using the Python Matplotlib library and see when warnings and errors happen.

Posted on January 10, 2024

In this article, I will briefly discuss how context awareness can be applied in different life sectors such as education, religion, and others.

Posted on December 14, 2023

Real-time data quality assessment is crucial in processing big data across various applications. Our previous work introduced BIGQA, a declarative solution based on ISO/IEC 15939, ISO/IEC 25000, and ISO/IEC 20547 standards. BIGQA offers a comprehensive and systematic approach to assessing big data quality, addressing the challenges of volume and variety.... [Read More]

Posted on December 14, 2023

Accurate data quality assessment is crucial for ensuring the reliability of data-driven applications. The manual inspection of data quality is a challenging process due to the large volume of data and the complexity of identifying data quality issues manually. To address these challenges and enable continuous monitoring and updating of... [Read More]

Posted on December 12, 2023

This article explains some of the popular SQL Server monitoring tools and techniques.

Posted on September 29, 2023

This step-by-step technical article will explore how to perform data profiling on a database using SQL code. We will use a combination of SQL queries to gather various metrics and statistics about the data, such as column data types, null values, data length, and more. Ultimately, all SQL code portions... [Read More]

Posted on August 3, 2023

I will briefly remind you about the data wrangling concept in this article. Then, I will dive into the SQL Server functions used to create a custom data wrangling tool.

Posted on July 19, 2023

This article explains how implicit conversions affect SQL query performance and cause the query optimizer to perform an index scan instead of index seek while searching for a specific value.

Posted on June 30, 2023

Inadequate data quality can lead to significant financial or business opportunity losses. Still, many SQL Server data practitioners are unaware of the available data quality solutions. This article briefly explains SQL Server’s solutions to assess and improve data quality.

Posted on June 27, 2023

This article emphasizes the significance of data quality in data-driven strategies and highlights the consequences of implementing data warehousing scenarios that need more attention to data quality. It introduces the concept of data quality management and discusses the ISO/IEC 25012 standard’s fifteen data quality characteristics. The article explains the different... [Read More]

Posted on June 14, 2023

This article explains what database monitoring is and why it is essential. Then, it illustrates the different methods for monitoring MongoDB NoSQL databases.