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.
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)
- Migrating SQL Server graph databases to ArangoDB - June 10, 2021
- An overview of the VS_NEEDSNEWMETADATA SSIS exception - May 13, 2021
- Different approaches to execute Python in SQL Server - May 10, 2021
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 »
An overview of the DTExec utility in SSIS
April 2, 2020DTExec 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.
Read more »
Biml alternatives: Building SSIS packages programmatically using EzAPI
March 26, 2020In 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.
Read more »
Biml alternatives: Building SSIS packages programmatically using ManagedDTS
March 25, 2020In 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.
Read more »
An overview of the SSIS FTP Task
March 18, 2020In 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.
Read more »
Using external C# script files within Biml
March 17, 2020In 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.
Read more »