SQLBlog Nederland Business Intelligence & Datawarehousing

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 …

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 …

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 …

Using Microsoft SQL Server, you cannot truncate or drop a table with a foreign key constraint. For example, when you have a client table and a country table. When the client table has a foreign key constraint to the country table, you cannot truncate the country table in this situation …

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.

Get started quickly with Microsoft Power BI! Experts Alberto Ferrari and Marco Russo will help you bring your data to life, transforming your company’s data into rich visuals for you to collect and organize, allowing you to focus on what matters most to you. Stay in the know, spot trends …

I was struggling with my SQL Server 2016 database mail after installing the Free Developer edition of Sql Server 2016. My server contains Microsoft Windows Server 2012 and I enabled the SMTP server. The SMTP server (local) was working fine but database mail refuses to work!

Inleiding De Nederlandse Postcodetabel bevat informatie over alle postcodes die in Nederland bekend zijn. Dit is erg handig als je meer informatie wilt over een bepaalde postcode zoals een geografische locatie of de plaats die bij een postcode hoort. We laten in dit artikel zien wat je met deze postcodes …

See how easy it is to add your reports to your public websites and blogs with Power BI Publish to web. Now you can craft your data story and tell it online in minutes. Here’s how!

I need to setup a weekly report for one of my customers. The report can be manually run by executing a T-SQL statement and copy the result to Excel. After copying, it’s emailed to the client. By using sp_send_dbmail attachment options, you can automate this process.

De tweede preview van Microsoft SQL Server 2016 “Mission-Critical Applications, Deeper Insights, Hyperscale Cloud” is te downloaden.

Het woord “Data Warehouse” klinkt behoorlijk spannend! Het doet vermoeden dat het een ingewikkeld gebeuren is, een soort pakhuis of verzameling met data. Eigenlijk is een data warehouse een database net als alle andere “gewone databases”. Men noemt het een “warehouse” omdat je er meer in bewaart dan in een …

A linked server is used to connect to another (remote) database or file (Xls, CVX) using SQL Server Management Studio (SSMS) and discover the data or objects. You can write SQL queries from your SSMS directly on a database on another machine. In Oracle they call it DBLinks (Database Links).

I found this cool ascii text generator website today. You can use it to generate cool banners to use in your documentation or code comments.

In my daily work, I need to calculate and report the age of people very often. There are a couple of ways to calculate the age and will give you the right result. I do not recommend a SQL Function to to this. SQL Functions are performing very slow, especially …

This article will offer you a way to calculate a 4 week moving total in SQL using SQL Server. There are more ways to Rome but this is a way you can use to calculate it using a date dimension.

A common wish in SQL Server Reporting is to create an image with a text inside the image. When you are a common user of SSRS, you know this is not so easy. You cannot simply insert an image and a text on top of it. Your layout will be …

I had some subscriptions staying in the “Pending” LastStatus. It took me a lot of time to fix this problem. This blog will give you the solution for the  problem.

Like the title says; my SSAS OLAP cube (SQL 2008R2) was giving me wrong results when selecting a combination of a measure and a fact. I was struggling for days with this issue. I called old colleagues, reading a lot of articles online but no solution yet.

I know it was not difficult to implement dimension security in Analysis Services.  While it’s not difficult, why did it cost me a lot of days to get this to work? Well, its because you have to do a lot of little settings and it’s easy to make a small mistake …

In a previous post, I wrote about how to prevent the divide by zero issues in Reporting Services. The problem with the custom code I used was that the code returned the value 0 when one of the numbers is 0 or unknown.

A common question in the Business Intelligence world from customers is “how many customers did we lose this year” ? Businesses wants to know this so they can act faster to keep customers doing business with them. In this article, I will help you to create SQL to calculate this …