Recent Posts

Top 5 Ways to Optimize Your SQL Server CPU Usage

Introduction SQL Server is a powerful relational database management system developed by Microsoft. It is widely used in various industries for data storage, processing, and retrieval. However, like any other system, SQL Server can sometimes consume more CPU resources than necessary, leading to slower performance and reduced efficiency. This article …

Read More »

SQL Server Disk Performance Metrics: An In-depth Guide

SQL Server Disk Performance Metrics: An In-depth Guide Understanding your SQL Server’s disk performance metrics is crucial for maintaining an efficient, high-performing database. These metrics provide insights into how well your storage system is performing and where there might be bottlenecks or problems that need to be addressed. In this …

Read More »

From Excel to Power BI: Transitioning to Advanced Analytics

From Excel to Power BI: Transitioning to Advanced Analytics Over the past few decades, Excel has firmly established itself as a cornerstone of data management, manipulation, and visualization. However, in the evolving world of data analytics, tools like Microsoft Power BI have emerged as powerful alternatives, offering advanced functionalities that …

Read More »

Actieve bold buttons maken in Power BI

Wanneer je met buttons werkt in Power BI om bijvoorbeeld met bookmarks te werken is het handig om te zien welke “view” actief is in je rapport. Het lijkt een beetje op het principe van een web navigatie. Door de actieve bookmark op de button zichtbaar te maken wordt het …

Read More »

The 5 best examples Of Big Data in real life

One thing that is definitely taking the world by storm is Big Data. It is considered highly imperative for big to small industries and businesses. Companies have started to embrace the fact that big data is of utmost significance to them. WHAT IS BIG DATA AND WHAT ARE ITS BENEFITS? …

Read More »

Top 3 of the Best ETL tools in the Market in 2017

It’s pretty hard to say “best etl tools” or “single best etl tools”  to recommend. ETL-tools are very often closely related to the ERP or database product in use at an organization. As an IT professional, you just use what is provided at the company you are working for. This …

Read More »

Power BI Update September 2017

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 …

Read More »

How much does Microsoft Power BI cost?

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 …

Read More »

SQL Server Optimize Insert Performance In 5 Steps

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 …

Read More »

SSIS Maximum insert commit size

The default value of the Maximum insert commit size is 2147483647, the largest value a 4 byte INT will hold.  This value is default set in SQL 2012+ but you need to set it manually in versions lower then 2012. In most cases you will leave this setting alone. The value of 0 indicates that all …

Read More »

Power BI Premium Embedded vs PRO vs FREE

At the moment, Microsoft has three versions of Power BI you can use. The Power BI Free,  Power BI Pro and Power BI Premium. The Power BI Premium is a replacement of the Power BI Embedded version. This article will highlight the differences between the three versions of Power BI.

Read More »