Recent Posts
How to Optimize Unity Catalog Delta Tables
How to Optimize Unity Catalog Delta Tables If you work with Delta tables in Unity Catalog, you probably want them to stay fast without turning…
JSON support in SQL Server 2016
JSON (JavaScript Object Notation) is an open-standard, lightweight file format for storing and transporting data. It is easy for humans to read and write. It…
Power BI – Replace values in a comma separated string by looking up in another Table
Recently I faced an interesting scenario where I need to replace values in a comma-separated string using values from a lookup table. It looked like…
Azure – Using Azure Storage Accounts
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 – 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…