This article explains the SSIS pivot transformation and how it differs from the unpivot transformation.
Read more »
Hadi Fadlallah
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
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)
- SSIS Pivot transformation vs. Unpivot transformation - September 8, 2021
- Popular free SQL online compilers - August 9, 2021
- How to write subqueries in SQL - August 3, 2021
Popular free SQL online compilers
August 9, 2021This 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.
Read more »
How to write subqueries in SQL
August 3, 2021This article briefly explains how to write a subquery in SQL by providing examples.
Read more »
SSIS Lookup transformation vs. Fuzzy Lookup transformation
July 28, 2021This 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.
Read more »
An overview of the SQL Server ISNUMERIC function
July 2, 2021This 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.
Read more »
Migrating SQL Server graph databases to ArangoDB
June 10, 2021This 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.
Read more »
An overview of the VS_NEEDSNEWMETADATA SSIS exception
May 13, 2021In 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.
Read more »
Different approaches to execute Python in SQL Server
May 10, 2021This article briefly explains how to execute scripts written in Python in SQL Server and how Machine Learning services facilitate this process.
Read more »
Top free T-SQL training videos
April 28, 2021This article mentions some of the top free T-SQL training videos available on the internet.
Read more »
Working with parameters in the sp_executesql stored procedure
April 16, 2021This 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.
Read more »
Export indexes and constraints from SQL Server graph databases to Neo4j
April 6, 2021In 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.
Read more »
Building SSAS tabular models using Biml
March 30, 2021This article will explain how to use the Business Intelligence Markup Language to create an SSAS tabular model.
Read more »
Building SSAS OLAP cubes using Biml
March 16, 2021In 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.
Read more »
Migrating SQL Server graph databases to Neo4j
March 9, 2021This article provides a step-by-step guide for migrating SQL Server graph databases to Neo4j using C#.
Read more »
Getting started with the Neo4j graph database
February 5, 2021In 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.
Read more »
Import data from MongoDB to SQL Server using SSIS
December 25, 2020In 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.
Read more »
Building databases using Biml
October 14, 2020In 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.
Read more »
Manticore search: a continuation of the Sphinx search engine
September 14, 2020In 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.
Read more »
Building full-text indexes using the Sphinx search engine
August 4, 2020In 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:
Read more »
Getting started with Sphinx search engine
July 10, 2020In this article, we will be talking about the Sphinx search engine and how to use it to install it on the Windows operating system.
Read more »
Melissa Data Quality free components for SSIS
May 19, 2020In 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.
Read more »
Connecting to Apache Hive and Apache Pig using SSIS Hadoop components
May 14, 2020In 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.
Read more »
Importing and Exporting data using SSIS Hadoop components
May 11, 2020In 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.
Read more »
SSIS Hadoop Connection Manager and related tasks
May 11, 2020In 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.
Read more »
SQL Server JSON functions: a bridge between NoSQL and relational worlds
April 22, 2020In 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.
Read more »