#LL @ME

QBE CEO Purpose Award

Another one from QBE - what a great company to work with.

Passed AZ-204

Closing year 2022 with AZ-204!

One of the hardest test that I have ever done. I am now officially an Azure Developer !

I was having problem with Ubuntu installed on my Dell Lattitude laptop. It was freezing randomly and unusable. Found a way to make it stable. Edit GRUB Kernel parameter and add this line: intel_idle.max_cstate=1 i915.enable_dc=0

Passed MS-100

Today, I passed MS-100 exam. Next is MS-101.

Certified Secure Software Lifecycle Professional (CSSLP)

I have passed the exam and endorsement process and officially CSSLP certified now!

Passed SC-300

Last exam of the year, SC-300!

Execute PowerShell in Windows Scheduled Task

There are many ways to execute PowerShell in Windows scheduled tasks:

Option #1

Program/Script: PowerShell.exe

Add arguments (optional): -command "& {& 'C:\path\to\script.ps1'}"

Start in (optional): C:\path\to\

Option #2

Program/Script: PowerShell.exe

Add arguments (optional): -NonInteractive -Noprofile -File "C:\path\to\script.ps1"

Start in (optional): C:\path\to\

Option #1 allows me to have the script to connect to the Internet (server is located behind corporate proxy).

Passed AZ-303

It is official! after passing AZ-303 today, I am now a Microsoft Certified Azure Solutions Architect Expert.

Passed AZ-304

Today, I passed AZ-304 exam !

One more to go to get Azure Solution Architect Expert

http://aka.ms/AzureCerts_SolutionsArchitect

Microsoft Azure Administrator Associate

Passed AZ-104 exam today!!

I am now officially Microsoft Azure Administrator Associate certified!!

Microsoft Certified: Azure Security Engineer Associate

Passed AZ-500 today!!

Hyper-V Nested VM

To allow your VM to run Hyper-V role, you need to expose the virtualization extension to the Hyper-V host by running the following PowerShell command:

> Set-VMProcessor -VMname MyVM -ExposeVirtualizationExtensions $true

My QNAP TS-412 had a major issue, 2 of the RAID5 disks decided to fail at the same time. Luckily QNAP was still up and running and allow READ-ONLY access to my data. However, all the iSCSI LUNs are not accessible anymore from my iSCSI clients.

Found the attached document which basically helped me recover my iSCSI LUNs. I copied by iSCSI LUN files to the backup locations and rebuild by NAS volumes. I then follow the procedure #3 in the document to get my iSCSI LUNs back.

Ubuntu DNS Stub Listener #Disable

During setting up PiHole, it requires to listen on DNS (53/TCP, 53/UDP) on the host. Ubuntu version that I am running on (20.04) by default listens on port 53 because it runs as DNS Stub Listener.

PiHole will give errors about Binding error

To disable Ubuntu running as DNS Stub Listener, do the followings:

> sudo vi /etc/systemd/resolved.conf

un-comment #DNSStubListener=yes
change it to DNSStubListener=no

> sudo service systemd-resolved restart
> sudo systemctl disable systemd-resolved.service
> sudo systemctl stop systemd-resolved
> sudo mv /etc/resolv.conf /etc/resolv.conf.old
> sudo shutdown -h now -r

Officially Microsoft Certified Azure Fundamentals !!

PowerShell and Excel

I wrote a PowerShell script to start MS Excel process and manipulate an Excel file. This PS works perfectly fine when it is executed interactively by a user account. However when using Windows task scheduler, it throws the following errors:

Microsoft Excel cannot access the file
There are several possible reasons:
The file name or path does not exist.
The file is being used by another program.
The workbook you are trying to save has the same name as a currently open workbook.

In turns out, I need to create a directory named: Desktop
In the following locations:

64-Bit OS
C:\Windows\SysWOW64\config\systemprofile\Desktop

32-Bit OS
C:\Windows\System32\config\systemprofile\Desktop

All the hard work is paid for ... QBE Cyber Security team has been recognized for exceptional performance!!