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 appropriate access permissions. My initial […]
Tag: syndicated
SSDT-BI and Visual Studio Online
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 […]
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 […]