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 free for basic use. All […]
Tag: syndicated
Reblog: The OLE DB Source and the Oracle Date Literal
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 BIDS 2008R2 which was part […]
My favourite books
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 of the questions is “Which SQL Server […]
Reblog: The shaky bug in SSIS
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 2010/2012 has had a make-over. Nothing […]
Reblog: Star Schema The Complete Reference – Review
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, a senior colleague of mine recommended […]
Reblog: Creating a Semi-additive Measure over a Parent-child Hierarchy
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 hierarchy in SSAS to show the parent’s own […]
Power BI Confusion
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. (I gave a session on Power BI […]
T-SQL Tuesday #68: Just say No to Defaults
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. If you count […]
Thoughts on Power Query and SSIS
Recently I received a very interesting question on Twitter from Jeremy (blog | twitter): @jmarx definitely yes — Koen Verbeeck (@Ko_Ver) July 10, 2015 His question was a response on my earlier blog post What’s the deal with Excel and SSIS?, where I remarked that Power Query will rescue the day since SSIS has a lot of […]
Reblog: What’s the deal with Excel and SSIS?
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, because numerous issues can rise […]