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…
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…
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…
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…
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…
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…
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…
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…
SSIS – Synchronous and Asynchronous Transformations
All the dataflow components available in SSIS can be categorized as either Synchronous or Asynchronous components. Synchronous components (non-blocking) A simple explanation of Synchronous transformation is…