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 out the MDS stored procedure […]
Author: Koen Verbeeck
Koen Verbeeck is a Microsoft Business Intelligence consultant at AE, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.
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 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 experience working with the SQL Server Business […]
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. 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 in talking before an audience. […]
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 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 took to finish. This can probably […]
The Future of SSMS
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 SSDT, you can now just […]
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 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 I won’t do an honest […]
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 must be building them script components. The problem From time to time I have to script out some logic using a Script Component in a SSIS package. Business as usual for most developers, but since […]
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 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 SQL Server Integration Services 2016 Control […]
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 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 review. About the author I’ve known Joost van Rossum for […]
T-SQL Tuesday #74: Be the Change
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 to write about a common topic. This month’s T-SQL […]