Wednesday, July 10, 2019

Qlik Qualified!

These days I have been very busy working on improving myself as life has changed for me since last year. I am not been able to blog as freely as before due to commitment. I always wanted to improve myself and I have been watching alot of videos and tutorials from Udemy. There are so many videos to learn from depending on which topics you are interested in. You should go check it out!

Luckily for me, my company is the partner for Qlik and I am provided with Qlik Continuous Classroom for free. They have also the academic program where you can enroll as a student.

The videos and tutorials are easy to follow and qualification should be easy. I wouldn't say its super easy or extremely hard, you can take the practise question to find out yourself. Some questions can be quite tricky.

These are my badges which I obtained currently.



Looking forward to obtain data architect qualification and certifications!

Friday, October 5, 2018

Phishing has gone another level.

Oh wow. If I am not careful, I will also fall for this. Look carefully how the how sneaky they hide the domain name in the URL.

Wednesday, July 11, 2018

Its time to continue...

Life has been really busy for me and I continued to work hard but then I have been getting a bit lazy. Ever since I have settled down my job, I tried to nudge but with all my busy schedule on my usual sports regime. I started moving away from my blog. I got to know someone as well in April and my time for the personal projects has shortened.

Ever since I went on neglecting my personal work until one fine day I bumped into this video by TechLead. Watching his videos gave me so much inspiration and motivation to continue where I have stopped. I would strongly recommend to anyone who needs inspiration and lives your life to the fullest!


Wednesday, February 28, 2018

Datetime conversion from Oracle to MSSQL problem in SSIS

One day I had a problem encountering some problem within SSIS using Datetime conversion especially when passing parameters from one flow to another.

One of the problem which intrigues me that this date time issue when I tries to input


It ran fine on my Evaluate Expression but when I ran my SSIS it came out this problem.

Error: The data types "DT_WSTR" and "DT_DATE" are incompatible for binary operator "+". The operand types could not be implicitly cast into compatible types for the operation. To perform this operation, one or both operands need to be explicitly cast with a cast operator.

What I did is to change my length to 50 and my variable to pass in as DateTime and everything ran successful.

The DateTime issue will encounter quite common on dealing with databases especially when you are handling different data sources. My advice will be always pass as DateTime rather than convert into string unless you absolutely have to. (eg. showing on UI)


Thursday, February 15, 2018

My Dream Desk Setup for 2018!

Today is Chinese New Year Eve, I decided to tidy up my desk which I usually work most of my personal projects.

My dream desk setup is pretty simple. I want to keep it simple ergonomic and fun to stay long enough for me to enjoy my stuff.

So I bought my ultimate ergonomic desk the moment I move into my new place.

Everything looks great but... I was having some problem with the cable management problem.

Cables are so messy and my vacuum robot has some issue entering this area.

I was afraid that my vacuum robot might tangle the wire one day, I decided to do something about it.
So there are 2 problems here.
- Messy cables lying around.
- The Belkin surge protectors Power Strip that I bought took up that much space.

So I went online bought cable management, cable box, and cables ties to organize the cables.



Here you can see that I use my cable ties to tie up the power strip against the desk so that it won't take up space on the floor which makes it perfect for my vacuum robot to pass through the area.

The cable organizer helps me to make the cable looks less messy

For those remaining long cables will be stored in the cable management box.

Here is the end result.

One of the main reason I got this desk is that I can use it as a standing desk most of the time. It has 4 memory storage so that you do not have to figure out what was your configuration for sitting and standing height.


Beautiful isn't it?

Watch it in action!

Saturday, January 6, 2018

Free private Git Repository from Microsoft

You can't get better than this.
Microsoft is now providing unlimited free git hosting.
First 5 users are free with every additional users are $6 per month!

https://www.visualstudio.com/team-services/git/free-private-git-repo/

Thursday, November 16, 2017

Dragon Ball Z: Light of Hope

Months of waiting and finally released. Dragon Ball Z : Light of Hope is a non-profit, live action web series produced by indie filmmaker, Robot Underdogs. It was a project which has been working off for months with such amazing low budget. Hollywood must be ashamed.


Tuesday, October 17, 2017

First Giant Robot show for the first time in History

First ever Giant Robot fight in history! It seems that the Japanese robot looks nicer than the Americans ones. As a robot fan, I would definitely watch it tonight! Reminds me of Pacific Rims and part 2 which will be showing in cinema soon. I am not sure if I would still be alive to see robots which will have super fast actuator like Gundam in future.

Tuesday, October 10, 2017

Star Wars: The Last Jedi Trailer finally out!

The trailer is finally out but it seems that there is a major spoiler that is quite obvious in it. Don't watch if you can, it's only less than 2 months away. btw, Luke finally talks.


Thursday, September 21, 2017

Mysterious Life of Developers

That pretty sums up most of the 3 different types of developers. :/ I used to be the one drinking coke. lol.