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
In case you haven’t noticed, Power BI added a new feature in preview mode: row level security (RLS). This blog post describes how you can use this feature to implement dynamic security. In other words, the data being displayed depends on the user that’s viewing it. I will not talk… Read more
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.
Here is an overview of the articles I published in the first quarter of 2016.
R Services series:
- SQL Server 2016 R Services: Executing R code in SQL Server
- SQL Server 2016 R Services: Display R plots in Reporting Services
SSIS & AlwaysEncrypted:
A little SSIS trick today. Sometimes you start a new Integration Services project and you want to add some existing packages to this project. So you can right-click the SSIS Packages node and choose Add Existing Package.
In the dialog, you choose the File System.
All you now… Read more
The very first SQLSaturday in Belgium is over and it was a great event. I saw some interesting sessions, especially the one on refreshing data in Power BI was very interesting. There was a nice turnout and the event was well organized. I look forward to the second edition!
You… Read more
Recently it was announced that Power BI would now support the SSAS display folders in “exploration mode”. Exploration mode is a fancy term for a live connection to an SSAS cube or model. Anyway, great news, as it drastically improved usability of Power BI Desktop when browsing cubes.
On the… Read more
I recently came across the following error message when I tried to look at the batches in the Integration Management section of MDS:
515: A database error has occurred. Please contact your system administrator
Too bad I am the system administrator on that machine…
Anyway, after some searching it came… Read more
I’ll be giving a webinar for MSSQLTips.com on Thursday March 10, 2016.
The title is SQL Server BI Best Practices and its abstract goes like this:
Join us for this webcast to learn about best practices for SSIS, SSRS and SSAS.
Our presenter, Koen Verbeeck has several years of…
I’m delighted to announce that I’ll be giving a session at the very first SQLSaturday (aka SQLSaturday 505) in Belgium. SQLSaturday are free events focusing on SQL Server and related technologies. They are organised around the world. SQLSaturdays are a great opportunity for local speakers to get some real-life experience… Read more
I had to do some performance testing for an MSSQLTips article and I thought I’d share the framework I used in a blog post.
First of all we have to log start and end dates of the package to a table so we can easily calculate the duration a package… Read more
One of the smaller announcements amidst the gazillion new features of SQL Server 2016, is that SSMS is now a separate installation. You heard that right (read, probably), no more dragging along those bulky .ISO files with the entire SQL Server set-up just to install some client tools. Just like… Read more
A few weeks back, the folks at Apress Publishing sent me a copy of the book Expert Performance Indexing in SQL Server for me to review. Since I know both the authors and since I’m familiar with the spectacular work they do, I was happy to do so. Doesn’t mean… Read more
SQLKover update: For some reason, this was my most popular blog post on the old LTD site. Over 110,000 views. People must be building them script components.
From time to time I have to script out some logic using a Script Component in a SSIS package. Business as… Read more
Here is an overview of the articles I published in the final quarter of 2015:
- Integrated Logging with the Integration Services Package Log Providers
- SQL Server Integration Services Best Practices and Tuning Tips Webcast Q&A
- Retrieve Error Column in SSIS 2016
- Customize the SQL Server Reporting Services 2016 Parameter Pane
Recently I got my hands on a copy of Extending SSIS with .NET Scripting, written by SQL Server MVP Joost van Rossum (blog | twitter). My .NET scripting knowledge could use an update, so I decided to read the whole book and provide you with a full… Read more
It’s the second Tuesday of the month and you know what that means! T-SQL Tuesday time! If you don’t know what it means, T-SQL Tuesday is a monthly blog party of the SQL Server community – started by Adam Machanic (blog|twitter) – where everyone is invited… Read more