I often ask prospects if they've done any estimates of the value that the envisioned BI solution would bring to them. The Microsoft Solution Framework actually recommends partners do this during the planning phase. Alas, the answer is almost always negative. Then I ask what criteria would be used to evaluate if my price (I give fixed value-based prices as I don't sell time) would…
Read article
Scenario: Consider a SQL Server configured for AlwaysOn Availability Groups where a set of databases can fail over to another node. You have SSIS jobs and you created them on both nodes. However, you need to check if the current node on which the job is running is the primary node. If you don't do this, the job fails because the database isn't accessible. Solution:…
Read article
After Tableau and SiSense, Keeping 'em Honest continues with Qlik. Now, after they sold the company and took a hit in the latest Gartner's quadrant, I didn't expect much of a completion from Qlik but every now and then I run into a customer considering Qlik and willing to share Qlik's feedback on how Qlik outshines Power BI in every possible way (can't share these…
Read article
What Does Power BI Premium Mean for You? As I mentioned in my Spring newsletter "15 Reasons Why Microsoft is Leading the BI Space", Microsoft BI is enjoying resurgent interest from customers and industry observers, and Power BI gets lots of attention. I'm sure that you've also heard the announcements about Power BI Premium – a new dedicated licensing model for Power BI. In fact,…
Read article
SQL Server 2017 introduces the ability to scale out SSIS. The primary scenario is to enable customers to scale out their SSIS execution at the package level. Imagine a retail business that has about 300 packages to run at the end of the day to push transactional data/finance data from multiple stores to the centralized data warehouse for reporting. All the 300 packages need to…
Read article
Issue: You want to use the Power BI Excel Publisher but it doesn't load. You look at the Excel add-ins and you see that it's deactivated. You try to activate it and then you get an error. Solution: Copy the following Office PIA files to the add-in folder (C:\Program Files\Microsoft Power BI Publisher for Excel\bin). Microsoft.Office.Interop.SQLIS.12.0.nupkg OFFICE.dll Unfortunately, I don't know where these files are…
Read article
