Nested Display Folders in SSAS

Recently it was announced that Power BI would now support the SSAS display folders in “exploration mode”. Exploration mode is...

Reblog: MDS – A Database Error Has Occurred

I recently came across the following error message when I tried to look at the batches in the Integration Management...

Webinar – SQL Server BI Best Practices

I’ll be giving a webinar for MSSQLTips.com on Thursday March 10, 2016.

The title is SQL Server BI Best Practices and its...

Speaking at the first Belgian SQLSaturday!

I’m delighted to announce that I’ll be giving a session at the very first SQLSaturday (aka SQLSaturday 505) in Belgium....

Reblog: SSIS Performance Testing

I had to do some performance testing for an MSSQLTips article and I thought I’d share the framework I used in...

The Future of SSMS

One of the smaller announcements amidst the gazillion new features of SQL Server 2016, is that SSMS is now a...

Book Review – Expert Performance Indexing

A few weeks back, the folks at Apress Publishing sent me a copy of the book Expert Performance Indexing in...

Reblog: Building the Script Component

SQLKover update: For some reason, this was my most popular blog post on the old LTD site. Over 110,000 views. People...

Overview of Published Articles – 2015Q4

Here is an overview of the articles I published in the final quarter of 2015:
Integrated Logging with the Integration Services Package...

Book review – Extending SSIS with .NET Scripting

Recently I got my hands on a copy of Extending SSIS with .NET Scripting, written by SQL Server MVP Joost...