I'm using a clustered columnstore index (CCI) on one of my fact tables at a client. The row size is…
Here is an overview of the articles I published in the first quarter of 2016. R Services series: SQL Server 2016…
A little SSIS trick today. Sometimes you start a new Integration Services project and you want to add some existing…
The very first SQLSaturday in Belgium is over and it was a great event. I saw some interesting sessions, especially…
Recently it was announced that Power BI would now support the SSAS display folders in "exploration mode". Exploration mode is…
I recently came across the following error message when I tried to look at the batches in the Integration Management…
I’ll be giving a webinar for MSSQLTips.com on Thursday March 10, 2016. The title is SQL Server BI Best Practices and…
I'm delighted to announce that I'll be giving a session at the very first SQLSaturday (aka SQLSaturday 505) in Belgium.…
I had to do some performance testing for an MSSQLTips article and I thought I’d share the framework I used in…
One of the smaller announcements amidst the gazillion new features of SQL Server 2016, is that SSMS is now a…