Hadi Fadlallah

Posted on January 13, 2022

Since many students and developers cannot pay for the certifications exams fees, I created a #GitHub repository to list all free professional exams provided by tech companies even if it was offered on a specific occasion (ex: Microsoft Ignite Cloud Skills Challenge). I will be grateful for any contribution. And... [Read More]

Posted on January 10, 2022

This article will explain how to create a SQL Server CLR function stored in a C# class library without creating a SQL Server database project. We will first briefly explain the concept of .NET common language runtime (CLR) and then build a C# class library using the .NET framework. Then,... [Read More]

Posted on December 30, 2021

This answer explains why the milliseconds part is removed when passing a DateTime value as a parameter in a OLE DB source SQL Command. Besides, it explains the different data types systems used in SSIS.

Posted on December 29, 2021

How to split a comma seperated value passed as a parameter to an SQL Command used in the SSIS OLE DB Source when the database does not support STRING_SPLIT() system function?

Posted on November 25, 2021

This article explains both the SSIS term extraction and term lookup components. Besides, it illustrates the use cases of each one of them.

Posted on November 19, 2021

This article explains the SSIS Script task and Script component, the scripting tools available in the SQL Server Integration Services (SSIS).

Posted on November 11, 2021

Is it Possible to Load data to MongoDB Using SSIS? If yes tools required to achieve? Does MongoDB Support all the SQL Operations?

Posted on November 3, 2021

This article explains the SSIS XML Source and the SSIS XML task, which are the XML-related components in the SQL Server Integration Services.

Posted on October 5, 2021

This article compares the SSIS OLE DB Destination SQL command with the “Table or View” data access mode

Posted on September 29, 2021

SSIS Merge Join and Merge transformations are two similar components used to combine two input data sources into one output. This article explains both transformations and illustrates when and how to use each one of them.

Posted on September 8, 2021

This article explains the SSIS pivot transformation and how it differs from the unpivot transformation.

Posted on August 31, 2021

How to filter data in Oracle based on a SQL Server query result?

Posted on August 9, 2021

This article will mention some of the most popular free SQL online compilers that help developers debug and test their SQL code without installing an SQL instance locally or buying one on the cloud.

Posted on August 3, 2021

This article briefly explains how to write a subquery in SQL by providing examples.

Posted on July 28, 2021

This article will explain how to use the SSIS lookup transformation and how it differs from the fuzzy lookup. This is a continuation of the SSIS features face-to-face series that we published previously on this website.

Posted on July 2, 2021

This article gives an overview of the SQL Server ISNUMERIC built-in system function. It explains how to use this function, illustrates its limitations, and provides some alternatives.

Posted on June 10, 2021

This article will explain ArangoDB, how to install it on Windows, and how to migrate a SQL Server graph database to this NoSQL database management system.

Posted on May 13, 2021

In this article, we will briefly explain the VS_NEEDSNEWMETADATA SSIS exception, one of the most popular exceptions that an ETL developer may face while using SSIS. Then, we will run an experiment that reproduces this error. Then, we will show how we can fix it.

Posted on May 10, 2021

This article briefly explains how to execute scripts written in Python in SQL Server and how Machine Learning services facilitate this process.

Posted on April 28, 2021

This article mentions some of the top free T-SQL training videos available on the internet.

Posted on April 16, 2021

This article explains how to use the sp_executesql system stored procedure to run static and dynamic SQL queries and how to pass input and output parameters while using it.

Posted on April 6, 2021

This article is an extension of the previsouly published article “Migrating SQL Server graph databases to Neo4j”, where we will explain how to export the supported indexes and constraints from SQL Server to the Neo4j graph database.

Posted on April 6, 2021

Professional certification recognizes your knowledge and experience and enhances your professional credibility. Many students and developers cannot get certified since they cannot pay the certifications exams fees. After a little research on the internet, I found several database certification exams available for free by leading database providers in the market.... [Read More]

Posted on March 30, 2021

This article will explain how to use the Business Intelligence Markup Language to create an SSAS tabular model.

Posted on March 16, 2021

This post mentions some SQL Server experts you need to know during your SQL Server journey. Those experts are Microsoft Most Valuable Professionals that highly contributed to SQL Server the community.