Keep code clean

Take a look at this follow if else conditional statement.

-- conditional statement

if (a==0)

    ans = 1

else

    ans = 2;

-- ternary operator

ans = a == 0 ? 1 : 2 ;

Ternary Operator is a compact way of writing conditional expression and also achieve the same result.

It is used for shortening the if else statement and makes the code cleaner.

Live Caption + Translate available now for Windows 11

Can you recall a Teams meeting where you were in a group with people of different nationalities and had difficulty understanding them—either because of their accents or because they spoke too fast? Thanks to Windows' new Live Captions feature, I can now keep up with what they're saying.

This is truly a godsend. Windows now supports live captions and even real-time translation*.

*Note: The live translation feature is currently available only on Copilot+ PCs. That means it requires a Snapdragon X processor with an NPU capable of more than 40 TOPS. AMD and Intel are expected to roll out compatible chips soon.

For more details you can refer to the official page

The Impact of Copilot+ PC Live Captions | Microsoft Windows

Rebooting My Blog: A 4-Year Journey and What's New?

Ah, the sweet relief of hitting the refresh button on a dusty blog that's been collecting virtual cobwebs since 2021. It’s been a whirlwind four years ("last blog post was in 2021" now reads like ancient history!).

After clocking in countless hours at work, I finally took a minute to breath (and reminded myself that my keyboard isn’t the only thing that needs a break). During this time, the world didn't just keep spinning, it did so on the axis of technological innovation. AI, the prodigal child of tech, returned with a bang, seemingly having a sleepover with every product under the sun. They forgot to invite us, but we follow keenly! It's hip to hop on the AI bandwagon if you want to play in today’s market.

Here I am, back at the keyboard, not necessarily excited but more relieved to share the tech treasures I’ve been amassing. It might've been work and life throwing curveballs, but never the desire to share thoughts on everything tech and AI from this little nook on the internet.

In the coming weeks, expect some musings about my beloved home server (or shall I say, my new-age digital tree house?). Home labs are the rage now, and frankly, who could resist the allure of DIY server adventures in your very own homestead?

Stay tuned, and here's hoping my next hiatus isn't quite as extended as the last!

My very first home server mobo back in 2012

My 2021 PC Setup!

Finally my new desktop  PC setup for 2021. No more bulky PC casing lying around. My main intention for this build is for my future laptop which only require 1 USB C cable. Yes one wire to rule them all! This usb cable will connect to my docking station which actually served 2 purpose, display output and charging my laptop. This dock which I bought has 2 hdmi and 1 dvi connection and many usb 3 connections. Pretty cool huh?

As I am going minimalist setup, few years ago I have already ditched my dual monitor setup for this wide screen monitor. This has helped me reduce 1 power and 1 display cable. I have replaced my desktop for my future laptop, in order to make it neat, I bought a compatible mount for my laptop. I hope the stand is able to support the total weight as this is my custom setup. You cannot get all of this as a package.

Geek VS Non-Geek

My motto and beliefs what I put in linkedin is always about efficiency and making better lives for people.

So I came across this illustration that I think I must share with you guys.

Don't ever think that developers are always lazy :D. Its about making things automation, structural and organised so that we can make complicated process remain simpler in the longer run. Sometimes, people do not understand why we need more time to refactor our codes. We do spend a bit more time on initial stage so that we can makes things easier and scalable and reusable in the later implementation and less prone to human errors.

Finally I am Qlik Certified!

Yes! Finally I am Qlik Certified! After so many weeks of postponing my exam because of my busy schedule, I am now officially Qlik Sense Business Analyst Certified. The exam was indeed very tricky, as some of the answers are quite similar.

As the website recommended, all the questions given from the exam are making sure that you have quite an experience on using their product. Some of the questions are not just comes from the foundation knowledge, it also require some knowledge how you use the tools and what should be the right way to implement the chart with business requirement given.

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!

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.

Quick phishing demo. Would you fall for something like this? pic.twitter.com/phONMKHBle

— Mustafa Al-Bassam (@musalbas) September 9, 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!

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)