In preparation of my upcoming webinar on the new features of Master Data Services 2016, I installed MDS on my system. Otherwise it would be quite hard to give demos, of course. The installation itself went quite smooth, no remarks there. I also enabled Internet Information Services (IIS) on my… Read more
The 2016 edition of the Belgian SQL Server Days is over. It was a blast – as usual – and it was very nice meeting up with the #sqlfamily again. I had a session about the new features in SSRS 2016. I was so excited that I could do a… Read more
A couple of years back I achieved the Microsoft certification MCSE – Business Intelligence. You can read all about that process in my blog post How I prepared myself for the MCSE certification. As you might know, this certification is only valid for 3 years. My certification should… Read more
Here is an overview of the articles I published in the third quarter of 2016.
- What’s New in SQL Server Integration Services 2016 – Part 1
- What’s New in Integration Services 2016 – Part 2
- Installing new SQL Server sample databases: WideWorldImporters
- Install SQL Server 2016 Sample Database: Wide World…
I’ll be delivering two webinars for MSSQLTips.com in the coming months. The first one is about the – amazing – new features in Reporting Services 2016.
SQL Server Reporting Services is Microsoft’s corporate reporting tool. The SQL Server 2016 release marks one of the biggest evolutions of the product since…
At Microsoft Ignite, it’s announced that very soon, we will be able to host Power BI Desktop files on premises using Reporting Services.
Watch the following Ignite session at the 40:52 time mark:
I’d like to see some demos soon. Anyway, happy dance!
You can see a demo by… Read more
Just a quick blog post about an error I recently encountered when trying to create a mobile report for SSRS 2016, using the Mobile Report Publisher. I created the following query on top of the Wide World Importers data warehouse:
SELECT c.[City] ,c.[State Province] ,c.[Country] ,c.[Sales Territory] ,c.[Region] ,c.[Subregion] ,c.[Location]…
Microsoft released a new sample database a couple of months back: Wide World Importers. It’s quite great: not every (unnecessary feature) is included but only features you’d actually use, lots of sample scripts are provided and – most importantly – you can generate data until the current date. One… Read more
I’ll be giving a webinar on the new features of Integration Services 2016.
SQL Server Integration Services is Microsoft’s leading data integration and transformation tool. In this webcast, we will take a look at which…
This week SQL Server 2016 Cumulative Update 1 was released and it contains a lot of updates/fixes for SSIS, SSAS, SSRS and MDS. If you are already working on SQL Server 2016, I’d urge to install this update as soon as possible.
Anyway, one of the particular updates that caught… Read more
Here is an overview of the articles I published in the second quarter of 2016, which were all focused on the new changes for Master Data Services in SQL Server 2016:
- Approval Workflow in SQL Server Master Data Services 2016 using Change Sets – Part 1
- Approval Workflow in Master…
Very, very recently I did my first Proof Of Concept (POC) with SQL Server 2016. At an actual client of course
One of the first things I noticed, is that installing SQL Server 2016 is quite fast. Installing the database engine, SSIS, SSAS and SSRS is just a matter of… Read more
There’s a new update out of Power BI Desktop (May 2016), but at the time of writing there’s no official announcement yet.
However, two great new features have been spotted by Chris Webb:
@marcorus a few things – quick calculations (only seen % shares) and conditional formatting in tables for…
SQLKover update: nowadays you would probably use package parameters to pass the directory value. However, they still have a default value, so this still applies.
Recently I ran across a forum thread where someone encountered an unexpected result when creating a directory using the File System Task in Integration Services.… Read more
I’m delighted to announce that I’ll be giving a session at this year’s ITPROceed. For those who don’t know this event, it’s an IT Pro focused event in Belgium about Microsoft Technologies. And what’s even better, it’s totally free.
My session will be a general overview of what you… Read more
I stumbled across a small MDX performance tuning trick when using SSRS reports (or any other client tool where you can edit the MDX). When you create the MDX query using the designer, it will append some cell properties at the end of the query. Basically it’s just metadata about… Read more
UPDATE: the feature has changed since its introduction. For more information, see the update at the bottom of the post.
Recently I stumbled across a quite annoying error in the Power BI service. I uploaded two working reports from Power BI Desktop to the cloud service. Each report connects to its own cube and both cubes are in the same SSAS MD database. On the server, I have a gateway… Read more
I’m using a clustered columnstore index (CCI) on one of my fact tables at a client. The row size is between 8 and 9 million rows and I was wondering how I could load data efficiently in this CCI using SSIS.