Recent Posts

Power BI
Posted in Power BI

Power BI – Issue in using Query List Parameter (Query references other queries or steps)

I had a business requirement where I need to get the list of Products Ids in scope from an Excel file provided by the business…

Continue Reading...
Power BI
Posted in Power BI

Power BI – Parent-child Hierarchies in DAX

As part of my project activities, I sometimes have to deal with parent-child hierarchies and need to flatten them in Power BI. A common parent-child…

Continue Reading...
Power BI
Posted in Power BI

Power BI – PATH function for Parent-child Hierarchies in DAX

We sometimes have to deal with parent-child hierarchies and need to flatten them in Power BI. A common parent-child scenario is Geography where we have…

Continue Reading...
SSIS Concepts
Posted in SSIS

SSIS – Merge Join vs Lookup Transformation

What is the difference between Lookup and Merge Join transformation in SSIS? Lookup and Merge Join component in SSIS are primarily used for joining two…

Continue Reading...
Power BI
Posted in Power BI

Power BI – TOTALYTD DAX Time Intelligence Function

What is TOTALYTD function? Let us consider a scenario where you are working on a report in Power BI where you need to calculate the…

Continue Reading...
SQL Server Concepts
Posted in SQL Server

SQL Server – TABLESAMPLE, retrieving random data from SQL Server

TABLESAMPLE allows you to limit the number of rows from a table in the FROM clause. The rows retrieved are random and they are are…

Continue Reading...
SSIS Concepts
Posted in SSIS

SSIS – Difference between Merge and Merge Join

We can use Merge or Merge Join transformation to combine data in SSIS. Lets look at what is the difference between these two transformations and…

Continue Reading...
SQL Server Concepts
Posted in SQL Server

STRING_SPLIT – New function in SQL Server 2016

As part of SQL Server 2016 enhancements, a new built-in table-valued function STRING_SPLIT() is introduced.  This is one of the many enhancements introduced in SQL…

Continue Reading...
SQL Server Concepts
Posted in SQL Server

CREATE OR ALTER – New enhancement in SQL Server 2016 SP1

An interesting new enhancement was introduced in SQL Server 2016 SP1. As part of this release, a new T-SQL statement, CREATE OR ALTER was introduced…

Continue Reading...
SQL Server Concepts
Posted in SQL Server

SQL Server – Logical Query Processing phases

Have you ever wondered about the order in which SQL Server query engine executes a SQL query? Most programming languages follow the fundamental of processing…

Continue Reading...