Recent Posts
Azure – How to create and use an Azure Storage account
Azure Storage is the managed cloud storage service offered in Microsoft Azure. Azure Storage provides a highly available, durable, scalable, and redundant storage service. Azure…
Azure – Understanding Azure Storage
Azure Storage is the managed cloud storage service offered in Microsoft Azure. Azure Storage provides a highly available, durable, scalable, and redundant storage service. Azure…
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…
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…
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…