I was toying around with the new SQL Server 2016 CTP release and I wanted to run a few SSIS packages to test out the new logging levels. However, everytime I ran a package in the SSIS catalog, it ended with the dreaded “unexpected termination” message. In such a case,… Read more
I have the great pleasure to announce that I have been nominated for the “Author of the Year 2015” award at the MSSQLTips website. This means however I have to persuade people to vote for me, hence this blog post I received the award last year, so I have a… Read more
A new monthly release of the SQL Server 2016 preview has been released: CTP 2.3.
You can find the download here (the official SQL Server 2016 page currently still links to CTP 2.2).
There isn’t any official documentation out yet describing which features have been added or improved, but thanks… Read more
Anyone working with SSIS and Excel probably had the following issue: you are creating an SSIS package using an Excel file in BIDS/SSDT – which is a 32-bit application – and when you try to run the package, it crashes. This is easily fixed by setting the project property Run64BitRuntime Read more
SQLKover update: this was one of the most popular posts on my old blog. It’s quite old now and SQL 2014 content has been added to some of the exams. Nonetheless, a lot of it is still valid today.
Last week (this is a repost, so not actually last… Read more
Recenty I was writing an article for MSSQLTips where I had to create a treemap (it will be published soon). As sample data, I used the different folders containing the drafts for all the tips I ever wrote. As measures, I have the number of kilobytes and the number of… Read more
Whoa whoah. Aren’t you supposed to increase your data flow buffer size in order to speed up your packages? If you have enough memory and you can process more rows at the same time because your buffer is larger, that’s what we want, right? Yes, this is confirmed by the… Read more
Recently I tried to open a script component in SSDT-BI 2013. I was developing for SSIS 2014, so this means using Visual Studio 2013 (I explain in this blog post how I set this up using Visual Studio online). However, I got a message saying there was a compatibility issue… Read more
I was creating an SSIS catalog at a new project, but I was greeted with the following error message when I hit OK:
The path to the catalog backup file could not be determined. Integration Services might not be installed on this server, or the user may not have the…
Recently I had to create a new business intelligence project at a client. However, there was no source control present. Because I like my code checked in somewhere – you never know if your laptop crashes or even get stolen – I decided to try out Visual Studio Online. It’s… Read more
SQLKover update: when of the stranger Oracle issues I encountered over the years. Some time after I published the original blog post, there was a forum question about the same issue. I googled and found my own blog post as the answer.
Recently I was developing an SSIS package in… Read more
As I mentioned in the blog post Speaking at SQL Server Days 2015, I’ll be giving a session at the Belgian SQL Server Days. There is a Speaker in the Spotlight section on the site, where a speaker can introduce him/her self by answering a simple survey. One… Read more
SQLKover update: I’m reblogging this a bit earlier (it’s a quite recent blog post) because I still see people with this issue. Also, it seems that sometimes the fix doesn’t work.
You may or may not have noticed it after installing SQL Server 2012/2014: the designer interface in Visual Studio… Read more
SQLKover update: 1.5 year later, I still stand by my position: Star Schema The Complete Reference is the best book on dimensional modelling around. Recommended/obligatory reading!
I finished my first book of this year and here’s the review! After I finished the newest edition of Ralph Kimball’s Data Warehouse Toolkit,… Read more
Originally this blog post would be titled “Disabling aggregations over a parent-child hierarchy”, but I thought it could create confusion with the Aggregation Design concept in Analysis Services (SSAS), which is something completely different.
What I want to describe in this blog post is a method forcing a parent-child… Read more
I have the great pleasure to announce I’m speaking for the 5th time at the Belgian SQL Server Days! The SQL Server Days is the largest SQL Server conference in the Benelux (and maybe beyond :)) and is hosted by sqlug.be. It will be great to see the #sqlfamily… Read more
Just a quick post on some Power BI material that I believe should reach as many people as possible. I get the notion there is a lot of confusion about what is possible in Power BI v2 and which features are supported in the free and in the paying version.… 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
@jmarx definitely yes
— Koen Verbeeck (@Ko_Ver) July 10, 2015
SQLKover update: When I read this old blog post of mine, all I can think about is: Power Query to the rescue!
When it comes to importing data from an Excel sheet with SSIS, Excel has quite a reputation. And not a terribly good one. Well deserved, to be honest,… Read more