In Belgium, a national campaign is launched to raise money for cancer research: #TourneeMinerale. In this campaign, people can be sponsored for not drinking alcohol for the whole month of February 2017. This sponsor money is donated to the national cancer research center. The name of the campaign – Tournée… Read more
Brent wants us to blog about our favorite Connect items because Microsoft is currently listening to its customers and actually closing items.… Read more
First a little background. I’m working on a large fact table that behaves itself as a slowly changing type 2 dimension. Weird right? But I have a good reason for this: it’s a snapshot table and if I would create the snapshots like you’re supposed to (by exploding the fact… Read more
I recently had to install SQL Server 2016 again on my Windows 10 machine. This also meant that I had to install and configure MDS as well. Last time it didn’t went so smoothly: Master Data Services error – Cannot read configuration file due to insufficient permissions. However, this… Read more
People who have been working for a while with Integration Services probably know the legendary blog post by SQL Server MVP Jamie Thomson: Suggested Best Practises and naming conventions. The blog post served as a guidance point for many SSIS projects regarding naming conventions of the various tasks and… Read more
Note: not a SQL/BI related post like usual, but since it’s a common issue I want to share my solution here
Quite recently I had a bizarre issue on my laptop: suddenly I could only browse Google websites (Google search, YouTube, Gmail …). All the other websites would time out… Read more
A semi-additive average? What exactly are you trying to calculate? Let me explain first. A semi-additive measure is a measure that can be summed across some dimensions, but not all. Typically it’s the time dimension that isn’t additive. For example, the stock level at various warehouses. You can add all… Read more
SQL Server 2016 service pack 1 has been released and it is a mayor one! You can download it here.
Why, you ask, is it so important? Because a lot of Enterprise Edition database engine features are now available in the other editions as well. In other words, you… Read more
Since Power BI is all the rage right now, I was in need of some material to spice up my knowledge of DAX (read: finally understand how CALCULATE works). I’ve been following the website powerpivotpro.com for quite some time now and they always have very insightful articles about DAX and… Read more
I was preparing a demo for a session about the new features of Master Data Services in SQL Server 2016. In that demo, I created a business rule to test out the extension with custom scripts. When the business rule was finished, I tried to publish it. But, I was… Read more
The wait is over, the Reporting Services team finally released a preview for Power BI Desktop reports hosted on premises using Reporting Services! The preview itself is a VM hosted in Azure. You can read all about setting it up in the SSRS team blog post.
I toyed around… Read more
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…
UPDATE 2016-10-27: the preview is available as a VM in the Azure Marketplace. More information can be found on the SSRS Team blog. You can also find my first impressions of the preview in the blog post First thoughts on Power BI on premises.
At Microsoft Ignite, it’s… 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…