Hadi Fadlallah

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.

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.

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.

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.

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

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

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.

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.

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]

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