Hadi Fadlallah

Author
Recent Posts

Hadi is an SQL Server professional with more than 10 years of experience. His main expertise is in data integration. He's one of the top ETL and SQL Server Integration Services contributors at Stackoverflow.com . Also, he published several article series about Biml, SSIS features, Search engines, Hadoop, and many other technologies.

Besides working with SQL Server, he worked with different data technologies such as NoSQL databases, Hadoop, Apache Spark. He is a Neo4j and ArangoDB certified professional.

On the academic level, Hadi holds two master's degrees in computer science and business computing. Currently, he is a Ph.D. candidate in data science focusing on Big Data quality assessment techniques.

Hadi really enjoys learning new things everyday and sharing his knowledge. You can reach him on his personal website.

View all posts by Hadi Fadlallah

Latest posts by Hadi Fadlallah (see all)

Working with parameters in the sp_executesql stored procedure - April 16, 2021
Export indexes and constraints from SQL Server graph databases to Neo4j - April 6, 2021
Building SSAS tabular models using Biml - March 30, 2021

Working with parameters in the sp_executesql stored procedure

April 16, 2021 by Hadi Fadlallah

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.

Export indexes and constraints from SQL Server graph databases to Neo4j

April 6, 2021 by Hadi Fadlallah

In our previously published article in this series, we explained how to migrate SQL Server graph tables into Neo4j and why migration could be beneficial. We only mentioned how to migrate node and edge tables, and we did not mention indexes and constraints. This article is an extension of the previous one, where we will explain how to export the supported indexes and constraints from SQL Server to the Neo4j graph database. In addition, all codes are added to the project we already published on GitHub.

Building SSAS tabular models using Biml

March 30, 2021 by Hadi Fadlallah

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

Building SSAS OLAP cubes using Biml

March 16, 2021 by Hadi Fadlallah

In this article, we will explain how to use the Business Intelligence Markup Language (Biml) to build SSAS OLAP cubes, noting that this article is the ninth article in the Learn Biml series.

Migrating SQL Server graph databases to Neo4j

March 9, 2021 by Hadi Fadlallah

This article provides a step-by-step guide for migrating SQL Server graph databases to Neo4j using C#.

Getting started with the Neo4j graph database

February 5, 2021 by Hadi Fadlallah

In this article, we will talk briefly about graph databases and what Neo4j is. Then we will give a step-by-step guide on how to install and get started with Neo4j on Windows operating system.

Import data from MongoDB to SQL Server using SSIS

December 25, 2020 by Hadi Fadlallah

In this article, we will explain how to install MongoDB on the Windows operating system, how to install and configure the ODBC driver and connector that allows us to import data from MongoDB to SQL Server using SSIS.

Building databases using Biml

October 14, 2020 by Hadi Fadlallah

In the previously published articles in this series, we talked about the Business Intelligence Markup Language (BIML) and how to use the technology to build and manage SQL Server Integration Services (SSIS) packages. Besides managing SSIS packages, we can also manage SSAS models and build databases using BIML.

Manticore search: a continuation of the Sphinx search engine

September 14, 2020 by Hadi Fadlallah

In this article, we will be talking about Manticore Search, which is an open-source search engine first released in 2017 as a fork of the Sphinx search engine. We will try to describe this search engine briefly, mention some of its differences from the Sphinx search engine, and we will provide a step-by-step guide on how to build full-text indexes from SQL Server databases. Finally, we will show how to connect to the Manticore engine from the SQL Server management studio using a linked server object. In our previously published articles in this series, we talked briefly about the Sphinx search engine and how to create full-text indexes from SQL Server databases.

Building full-text indexes using the Sphinx search engine

August 4, 2020 by Hadi Fadlallah

In the previously published article, Getting started with Sphinx search engine, we talked about the Sphinx search engine and how to install it on the Windows operating system. In this article, we will talk about building full-text indexes using Sphinx. We will be covering seven topics:

Getting started with Sphinx search engine

July 10, 2020 by Hadi Fadlallah

In this article, we will be talking about the Sphinx search engine and how to use it to install it on the Windows operating system.

Melissa Data Quality free components for SSIS

May 19, 2020 by Hadi Fadlallah

In this article, we will talk briefly about data quality in SQL Server. Then, we will give a brief overview of the Melissa Data Quality for SQL Server Integration Services (SSIS), and we will demonstrate the components available in the community edition.

Connecting to Apache Hive and Apache Pig using SSIS Hadoop components

May 14, 2020 by Hadi Fadlallah

In our previously published articles in this series, we talked about many SSIS Hadoop components added in SQL Server 2016, such as the Hadoop connection manager, Hadoop file system task, HDFS file source, and HDFS file destination.

Importing and Exporting data using SSIS Hadoop components

May 11, 2020 by Hadi Fadlallah

In the previously published article, we talked briefly about Hadoop, and we gave an overview of the SSIS Hadoop components added in the SQL Server 2016 release, and we focused on the Hadoop connection manager and the Hadoop file system task.

SSIS Hadoop Connection Manager and related tasks

May 11, 2020 by Hadi Fadlallah

In this article, we will give a brief introduction of Hadoop and how it is integrated with SQL Server. Then, we will illustrate how to connect to the Hadoop cluster on-premises using the SSIS Hadoop connection manager and the related tasks.

SQL Server JSON functions: a bridge between NoSQL and relational worlds

April 22, 2020 by Hadi Fadlallah

In this article, we will explain what JSON is, what are the SQL Server JSON functions introduced in 2016, how to index JSON values, and how to import JSON data into SQL tables.

An overview of the DTExec utility in SSIS

April 2, 2020 by Hadi Fadlallah

DTExec is a tool used to configure and execute SQL Server Integration Services (SSIS) packages. Many developers and database administrators use this tool, especially when automating the package execution using third-party applications or non-supported programming languages.

Biml alternatives: Building SSIS packages programmatically using EzAPI

March 26, 2020 by Hadi Fadlallah

In the previously published article, Biml alternatives: Building SSIS packages programmatically using ManagedDTS, we talked about building SSIS packages using the managed object model of the SSIS engine (ManagedDTS). In this article, we will illustrate another Biml alternative, which is the EzApi class library, and we will make a comparison between both technologies.

Biml alternatives: Building SSIS packages programmatically using ManagedDTS

March 25, 2020 by Hadi Fadlallah

In the previously published articles in this series, we have explained how to use Biml to create and manage SQL Server Integration Services (SSIS) packages. In this article, we will talk about the first alternative of this markup language which is the Integration Services managed object model (ManagedDTS and related assemblies) provided by Microsoft.

In this article, we will first illustrate how to create, save and execute SSIS packages using ManagedDTS in C#, then we will do a small comparison with Biml.

An overview of the SSIS FTP Task

March 18, 2020 by Hadi Fadlallah

In this article, we will explain the File Transfer Protocol (FTP), and we will give an overview of the FTP task in SQL Server Integration Services (SSIS) and FTP connection manager.

Using external C# script files within Biml

March 17, 2020 by Hadi Fadlallah

In the previously published article, Extending Biml with C# scripts, we have explained how to use VB or C# scripts within the Biml code to prevent doing repetitive development work. But in this solution, the C# scripts and classes are only available within a single file while we may need to use them in many.

Monitoring activities using sp_WhoIsActive in SQL Server

March 16, 2020 by Hadi Fadlallah

In this article, we will talk about sp_WhoIsActive stored procedure and how we can use it to monitor currently running activities in SQL Server.

Extending Biml with C# scripts

March 16, 2020 by Hadi Fadlallah

In our previously published articles in the Biml series, we have explained what Biml is, and how to use this language to generate SQL Server Integration Services (SSIS) packages. In this article, we will explain BimlScript, which is an extension of this markup language with VB or C# scripts.

Using Biml scripts to generate SSIS packages

March 13, 2020 by Hadi Fadlallah

In the previous article, Converting SSIS packages to Biml scripts, we explained how to convert existing SSIS packages into Biml scripts using Import Packages tool and we mentioned that this could be an efficient way to learn this markup language since it lets the user compare between the well-known SSIS objects found in the package and the correspondent elements in the generated scripts.

Converting SSIS packages to Biml scripts

March 13, 2020 by Hadi Fadlallah

In our previous article, Getting started with Biml, we have explained what Biml is, what are the related tools and resources and how to get started with this technology. In this article, we will explain how to generate scripts from existing SSIS packages by showing all related options. Then, we will analyze the generated script and identify how each object is mentioned in the script.