Tuesday, May 31, 2016

Saying Goodbye to ADA and Hello to Pulse!

As you may have noticed, I'm starting tomorrow, June 1st, at Pulse (t | web) in Venlo, that's near the border with Germany. I had a couple of days off so my last day at ADA was last week. I already said goodbye to my colleagues, had some time to clear my head and spend some extra time with the kids, which is always great!

I have to say I enjoyed my time at ADA (t | web). I really liked my colleagues and the laughs I had with them. That doesn't mean I was always doing what I really wanted or liked most. I understand that the best jobs and the nicest customers aren't always available (for me). But in the long run you have to have fun and find a challenge in what you do!

So I decided to take a leap of faith and that's how I found Pulse, or actually they found me (ok, actually a recruiter found me). I'll be fulfilling an MS BI Consultant role there.
Pulse is an MS Gold Partner with Dynamics AX (ERP) on which they also built a BI framework. And now with the content packs of PowerBI the availability and quality of the solutions will only get better I believe.

Hopefully I will get (yes I know, I have to make time) a bit more time to blog and I'll let you know how my  choice turns out!


Friday, April 29, 2016

How To Insert a TAB Character in OneNote

As you might know, clicking the TAB button on your keyboard results in a table in OneNote. What if you really want to insert a TAB character? Well, you need a trick for this.

  • Create an Auto-correct rule that turns your chosen character sequence (e.g. "\t") into a regular TAB.
  • Open Notepad++ (or the text editor of your choice) and type one TAB. Select it and copy it.
  • Go to OneNote and click File | Options | Proofing | AutoCorrect Options.
  • In the dialog, put your desired sequence of characters (e.g. \t into the "Replace:" field.
  • Paste the TAB that you copied from Notepad++ into the "With:" field and click Add.
  • Click OK 2 times to close the dialogs and you're done!

Now, any \t followed by a SPACE will be replaced by a regular TAB.


I found this answer on the MSFT community site.

Friday, March 18, 2016

The Best of PASS Summit 2015

If you haven’t been to the PASS Summit in Seattle last year (like me :(), you might want to check out the recordings of Summit 2015, as they are now available on PASStv.

Furthermore, PASS has selected the top 10 recordings (I believe based on reviews of the sessions) for you to look at over at Youtube. The links to the video’s can be found at the PASS website, go check them out!

My personal favourite is from Itzik Ben-Gan:

Have fun!

Monday, February 22, 2016

SSRS: Go Back Button in an Expression

ProblemLast week I was making a drillthrough report in SSRS for one of my clients and I had the need to make a (browser-like) Back button, to go back to the parent report for example. I know I did this before and it had something to do with history and (-1) but I couldn’t recall the syntax. So I thought I’d finally capture the solution in a blog post!

The key to the solution is the <Action> property of the <Text Box Properties>, which you’ll have to set to <Go to URL> and edit the expression with the following code:

=”javascript: history.go(-1)”

Do mind the casing here, because it’s case sensitive!


Thursday, January 21, 2016

SSIS: An Item With The Same Key Has Already Been Added

Recently I was working on a new project and was trying to deploy my SSIS project with several packages to the catalog for the first time. I received the error when trying to build the project:

This occurs when e.g. you copied a (package) connection manager to another package and later promoted one of the 2 to a project connection.
Let’s say you have package A and B, both with the same package connection manager ConMgr. When you promote ConMgrof package A it will become (project)ConMgr, but in package B it will still be ConMgr, the package connection, and the new project connection will not be shown.

(I found my solution @ SO.) By deleting the package connection ConMgr (in package B) the project connection will become visible in the package and (in my project) succesfully replaced the connections in all data flows. It could be that you have to go through all components that referenced the old package connection to redirect them to the (project)ConMgr instead.

Hope that helps!