I’m Eric Tummers, Technical Consultant at Valid, and this is how I work

hulk_behind_me
I’m hired as a Software Architect to build a solution with Microsoft products. Our team works by the scrum guide and is moving towards continuous deployment. We are learning and growing while delivering business value. This is hard work. Every sprint we complete means the retrospective is done in the pub.

I expect the best and I give the best. Here’s the beer. Here’s the entertainment. Now have fun. That’s an order!
Rasczak

Location: Sittard, NL
Current Gig: Technical Consultant, Valid
Word that best describes how you work: Teamwork
Current mobile device: iPhone se
Current computer: MacBook 15 inch

What apps/software/tools can’t you live without? Why?

Wunderlist: work tasks, chores, groceries, planning, every task is there.
Evernote: I’m a fan for years now. Not to happy about the recent update but time will improve this.
iSmoothrun: when I’m not working, I’m running, this app tracks just about every metric I can think of and shares it to all the platforms (runkeeper for one)
Parallels 11: Running Windows on my MacBook is a must. And of course visual studio, team foundation server, build, release manager, sql server management studio, remote desktop, powershell, and some other tools I need for work.

What’s your workspace setup like?

Work at the office is on a thin client with 21 inch screen and (wired) mouse and keyboard. The desk and chair comply with all regulations. We have a great coffee machine.

dekstop_2017

My home workspace has moved to the kitchen table with my Macbook 15 inch. No externals and enough battery for the whole day. Freedom!

What’s your best time-saving shortcut/life hack?

Timebox. Start on a task and spent the time you’ve got to get the best result. Get someone to look at it, get feedback. Then decide if the result is final or to spent some more time.

Besides your phone and computer, what gadget can’t you live without and why?

I’ve been running with my Magellan Echo for some time. It is a sports watch that hooks up to my phone by bluetooth to start / stop my runs, control the music and see the metrics right on my wrist. It is powered by a battery that lasts 6 months and is easy to replace.
My Apple TV2 (jailbroken) hooked up to my NAS for movies and series. Also hooked to my stereo for music streaming. Awesome device!

What everyday thing are you better at than everyone else? What’s your secret?

Learning new things. My current project lets me implement new things (joy) Also I try to learn the things I know to my team or anyone who listens.
I have a basic understanding of how things work and try to map new things on there. For the details I have a Pluralsight subscription and black belt google skills.

What do you listen to while you work?

My alarm clock plays classical music to wake me up in the morning. The car stereo plays about everything (grunge, rock, kids stories) driving to work. When I need some focus I play drum and bass on my headphones. My ringtone is still Run riot by Camo & Krooked.

What are you currently reading?

Tools of Titans by Tim Ferriss. A Christmas gift. Best described as a book of “How I Work” posts full with tips and tricks of the titans (experts)

tools-of-titans

How do you recharge? What do you do when you want to forget about work?

Spending quality time with my wife and daughters. Phone on silent, no screens, no work. Mostly piggyback riding and thee parties
Also sports like running, fitness, climbing and snowboarding to keep me fit and healthy.

Fill in the blank: I’d love to see _________ answer these same questions.

Iris Classon, because she had to start from zero with her career shift and is now a Microsoft MVP (Most Valuable Professional).

What’s the best advice you’ve ever received?

someecards.com - Make a shit first draft you cannot edit a blank page
I believe this is a variant on a Hemingway quote.

Is there anything else you’d like to add that might be interesting to readers?

Learn Powershell. There is so much possible with Powershell. If you can learn one thing this year pick Powershell. 

Original idea from Lifehacker.com.

Posted in Uncategorized | Tagged , , , , , | Leave a comment

Flow parasites on ifttt

My blog posts are automatically published to yammer. When yammer was independent this worked like a charm. Then Microsoft bought yammer and the ifttt channel stopped working.

With the Office365 channel and the e-mail to yammer it worked again. Only for Microsoft to introduce an approve step. This means:

  1. wait for approval request in outlook,
  2. open login page to office 365,
  3. fill e-mail and wait for redirect to company login page,
  4. fill e-mail (again) and password,
  5. See the yammer post.

Now with Flow this would be automatic again. Let’s try this with this post.


as expected Flow can publish to yammer with more options and less hurdles … embrace and extend, not really.

Posted in Tooling | Leave a comment

Scrum Master Skills

We’re working on our project for some months now. Time to freshen up on scrum. For this we use the Scrum Master Skills course on pluralsight.

Once each sprint we sit down as a team for an hour. We play and pause the video and discuss how this applies to us. Some tips can be applied right away and others go on the backlog.

rawpixel-com-250087

Image courtesy of rawpixel / unsplash.com

Every project is different and every team is different. Even after 15 sprints we are finetuning. Using the experience of others helps us to be a better scrum team.

Posted in Development | Tagged , , | Leave a comment

Update statistics from stored procedure (needs alter table permission)

Today instead of the beautiful information our reports displayed this ugly error

  • An error has occurred during report processing. (rsProcessingAborted)
    • Query execution failed for dataset ‘StoredProcedure’. (rsErrorExecutingCommand)
      • For more information about this error navigate to the report server on the local server machine, or enable remote errors

If we had access to the report server machine this was easy to troubleshoot. But we don’t have access to the report server. We needed another approach.

Image courtesy of jesadaphorn / FreeDigitalPhotos.net
Image courtesy of jesadaphorn / FreeDigitalPhotos.net

Looking through the changes from last night we noticed a small performance enhancement. In a stored procedure that prepares the data for the reports we added the following line:

UPDATE STATISTICS [dbo].[Fact]

In the Microsoft documentation it says you’ll need alter table permission to use update statistics. So we added another grant for the reporting service account.

GRANT EXECUTE ON [dbo].[proc_prepare4reporting] TO [SSRS]
GRANT ALTER ON [dbo].[Fact] TO [SSRS]

After the deployment the reports showed the beautiful information again.

Posted in Development | Tagged , , , , , | Leave a comment

TypeLoadException

Introducing a new member to the team is always a good thing. This brings up problems that would stay under the radar otherwise. Our new tester experienced an application crash that we’ve never seen before.

Using the remote debugger we discovered the actual exception:

[TypeLoadException: Could not load type ‘System.Security.Claims.ClaimsIdentity’ from assembly ‘mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089’.]

Turned out the newly installed machine was still on .NET Framework 4.0 and we target the 4.5 Framework in our build. Other testers have Visual Studio 2015 installed to use the Test Manager feature. That installs the 4.5 Framework on their machines. The new tester hadn’t yet installed anything.

Image courtesy of toonsteb / FreeDigitalPhotos.net
Image courtesy of toonsteb / FreeDigitalPhotos.net

Our users will be on the .NET 4.0 Framework. So we changed the framework target to 4.0 in the project and the new bug was resolved and fixed. 😉

Posted in Development | Tagged , , | Leave a comment

My alternative to Pebble

About a year ago I backed the latest kickstarter project from Pebble. The battery life, the timeline and the support for my running app justified the purchase. But as we all know the device never made it to my wrist.

With some money to spare and my birthday coming up I decided to go for the Garmin Forerunner 235. It was favoured over the Apple Watch (yes I’m an Apple fan) because of the battery life and the fact that it is a running watch first and smart watch second. Both have build-in GPS but only the Garmin shows the status.

Garmin FR235

The smart features of the watch are limited to displaying the weather and your appointments, music control including volume and showing notifications. Everything is synced from the (i)Phone to the watch. No reply to messages or snooze of alerts. Pretty limited for a smart watch, but it works for me.

Looking at a message on my watch made me think of the pebble notifications I saw on youtube review, minus the animations. The screen looks like the same e-paper technology is used.

** But wait there is more **

Garmin has it’s own app platform called Connect IQ. There are over 1000 apps in the store you can download and install. The SDK is free and everybody is encouraged to develop something great.

In the end I’m very happy with my watch. Still sad Pebble is no more.

In-dept FR235 review by Dc Rainmaker

Posted in Uncategorized | Leave a comment

Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server

We use SSIS packages to import files. These SSIS packages are run with sqljobs. During deployment the sqljobs are created with a script. That is the plan.

While running the script to create the sqljobs we got an error:

Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server

Image courtesy of jesadaphorn / FreeDigitalPhotos.net
Image courtesy of jesadaphorn / FreeDigitalPhotos.net

Most solutions found on the internet talk about the name of the server. When you’ve renamed your Sql Server (yeah right) then you need to update the originating_server column in the sysjobs. This was not the case for us.

Over at msdn someone suggested to look at the variables. The first create sqljob would set the @jobid variable and the second create statement would use that value as input, where it is intended as output. The suggested SET @jobid = NULL before each call to sp_add_job did the trick.

Posted in Development | Tagged , , , | Leave a comment

SDN event March 2017

The SDN – Software Development Network – is a special interest group for dutch developers. Four times a year they organise an event where people present and talk about their passion.

As a member of the SDN you are aware of the latest developments. You are part of a network of professional developers who assist each other in word and deed. This means there is a technical helpdesk at your fingertips so you can book considerable time savings in solving problems.
sdn.nl with Google translate

Here are the talks I attended.

Customer identities in an Enterprise scenario

With slides and demo’s Jurgen showed us the Azure Active Directory Business 2 Consumer (AD B2C) solution from Microsoft. It differs from AD that you don’t know how many users you need in advanced and thus the costs are mainly based on the number of authentications, where AD charges for the amount of users.

The features include self-service (password reset, signup, …), usage of (social) identity providers and extensive login page customisation.

B2C-LoginPage
* Image from blogs.msdn.microsoft.com

Zero-downtime applications with containers

Docker is used for highly available solutions. In the demo a docker swarm was used to host a .net core application. With a visualizer container the setup (1 master and 2 slaves) was visualised on a website.

Using blue-green / rollout scenario’s the upgrade can be performed. Tips for database scheme: support version n-1 and do an upgrade after the last n-1 version of your application is replaced.

Fun fact: presentation had to be done with webcam from laptop #1 pointed to screen of laptop #2 because the projector couldn’t handle the resolution of laptop #2. 😎
docker_picture_in_picture
slides

Progressive web apps and the future of the web

Progressive web apps (PWA) are defined as Reliable (offline), Fast (install/usage) and Engaging (capabilities). It uses a Service worker, which is installed from the website. The Service Worker reacts to events, retrieves data from the internet when online or from the cache when offline.
Interesting links for PWA:

The presentation was recorded and is available on youtube:

Conclusion

A lot is happening and a single developer can’t keep up with all new things. This SDN event is (again) a great way to see what’s happening and get first hand information from experts.

Posted in Conference | Tagged , , , , , , , , | Leave a comment