Hadi Fadlallah

Posted on February 12, 2020

In this article, we will give an overview of the first two tasks provided by Integration Services (SSIS) that allows manipulating OLAP cubes and executing commands over SSAS. These two tasks are Analysis Services Processing Task and Analysis Services Execute DDL Task.

Posted on February 6, 2020

In this article, we will explain how a string to date conversion can be achieved implicitly, or explicitly in SQL Server using built-in functions such as CAST(), TRY_CAST(), CONVERT(), TRY_CONVERT() and TRY_PARSE().

Posted on January 28, 2020

SQL join multiple tables is one of the most popular types of statements executed while handling relational databases. As known, there are five types of join operations: Inner, Left, Right, Full and Cross joins. In this article, we will explain the meaning of Joins in SQL, we will describe each... [Read More]

Posted on January 23, 2020

SQL cursor is one of the most popular database objects. It is used to retrieve data from the result set of an SQL query one row at a time. Even if the cursor is not recommended from a performance perspective, they are still widely used especially when handling a small... [Read More]

Posted on January 13, 2020

This article is a supplement to the previously published article, An overview of SQL String Functions . This time, we will describe another bunch of SQL string functions used in SQL Server.

Posted on January 10, 2020

One of the most asked questions is how to link an OLAP cube with a relational database, or in another way how to join the result of an MDX query with a table stored in a relational database. In this article, we will illustrate how to link a SQL Server... [Read More]

Posted on January 2, 2020

A step-by-step guide to extract hyperlinks from excel files and store them into SQL Server using SSIS

Posted on December 25, 2019

In this article, we will try to give a brief overview of the SQL string functions used in SQL Server and we will provide some examples. A string function is a function that takes a string value as an input regardless of the data type of the returned value. In... [Read More]

Posted on December 16, 2019

Radiation pollution has been always a critical concern, since it can cause a huge damage to humans and for nature. To minimize the damage, governments are collecting and monitoring radiation level using advanced systems. In the past years, Big data technologies such as distributed file systems, NoSQL databases and stream... [Read More]

Posted on December 9, 2019

In this article, we will describe SQL Server Profiler and how it can be used. In addition, we will mention the tools that are integrated with it- plans about its deprecation, and what are the alternatives?