Setting Up a PHP Development Environment on Windows Machine/ Bitnami Wamp

Setting up a PHP development environment can be daunting and frustrating for beginners. Some Developers prefer to begin by installing PHP to the root folder of their C:\ drive, in case the Server is not self-contained. I prefer self-contained local server with its own PHP files rather than on my shared C:\ Drive. In reference to this blog post, I would like to select to…

10 scenarios where Azure SQL DW is not a good fit

OLTP workload – Azure SQL DW is an MPP database, data is distributed in many servers to improve reads thus it would hurt your OLTP writes. High volume of small reads and writes – Same as above Multi-Tenancy Database –  would be a nightmare to restore a single schema in case your environment is compromised, Azure SQL DW does not offer RLS, Always Encrypted and…

Getting Started with Azure Data Factory v2

Azure Data Factory (ADF) v2 is the second generation of Microsoft’s cloud data integration services which allows customers to work with data wherever it lives. ADF v2 comes in handy if you are working with SAAS data and would like to incorporate it into your data lake, or data warehouse for now or future consumption. In this article, we’ll review how to get started with…

Power BI Extract table using Examples missing

In May 2018 release Power BI team added a new powerful feature that allows users to get data from website with the ability to extract tables from the site. I wanted to test and see how this feature would be applicable to my existing datasets, so went out hunting. To get new features in Power BI you have to download the newest version and if…

Getting Started with Microsoft PowerApps

As the name deduces, a combination of “Power” and “Apps” meaning it allows you to create powerful business application but that’s relative depending on what you want to accomplish. Though PowerApps is not a replacement for InfoPath, I have seen in many-a-times forms built on PowerApps and they are very functional but it’s not comparable to InfoPath. InfoPath forms were easy to build even when…

Rolling Power BI Date Filters Automatically

When working with Power BI filters, there is a need for you to set them to roll over automagically especially when working with date filters. One of the common requirement is to have a month/year filter that rolls itself over when time comes. At the face of it, it seems like an uphill task but it actually isn’t. Here is a simple walk through on…