SQLBlog Nederland Business Intelligence & Datawarehousing

Power BI Update September 2017 The new Microsoft Power BI Desktop version has been released. This month brings another collection of new and useful updates, from reporting to data connectivity. The following updates are new to Power BI Desktop this month: Report View: Drillthrough to another report page Ribbon chart …

How much does Microsoft Power BI cost? Microsoft Power BI offers three enterprise pricing plans to choose from, one of which can be acquired for free (1 GB data capacity limit). Power BI – Free The Free service is for personal use, according to Microsoft. It has capabilities similar to …

SQL Server Optimize Insert Performance In 5 Steps. What are the possible reasons of the slow table insert? What are ways to identify this bottleneck without the execution plan? DROP ALL triggers and constraints on the table DROP ALL indexes (except the ones that are needed by the insert) Prevent page …