Sunday, June 8, 2025

Creation of LocalDB instance "mssqllocaldb" failed because of the following error: Error occurred during LocalDB instance startup: SQL Server process failed to start.

If you have the error above during SQL Server LocalDB creation or starting, it might due to strange behavior on several versions of SQL Server, including SQL Server 2022. 
First, try to recreate the LocalDB instance first if you are using LocalDB.
sqllocaldb stop MSSQLLocalDB
sqllocaldb delete MSSQLLocalDB
sqllocaldb create MSSQLLocalDB
sqllocaldb start MSSQLLocalDB
If still getting the same error, check the error log for the SQL Server which located at below.
%LocalAppData%\Microsoft\Microsoft SQL Server Local DB\Instances\mssqllocaldb
Inspect the last few lines of the error, you might get the error below.
2025-06-08 21:37:49.09 spid10s     There have been 256 misaligned log IOs which required falling back to synchronous IO.  The current IO is on file C:\Users\xxxx\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\mssqllocaldb\master.mdf.
If that is the error you have, you might need to add ForcedPhysicalSectorSizeInBytes to your Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device registry. Please head to Troubleshoot errors related to system disk sector size greater than 4 KB for Microsoft official resolution. 

Reference: 
https://learn.microsoft.com/en-us/answers/questions/1573054/creation-and-start-of-localdb-failure

Saturday, June 7, 2025

How to display markdown text as HTML in Blogger.com?

1. Add marked.js to your blogger.com Theme header and add the script to the bottom of the body. * Note: Please go to https://marked.js.org/ to confirm the latest CDN link.
<script src='https://cdn.jsdelivr.net/npm/marked/marked.min.js'></script>
<script>
  document.querySelectorAll('md').forEach(el => {
    const markdownText = el.textContent;
    const html = marked.parse(markdownText);
    el.innerHTML = html;
  });
</script>
2. Then, in your Blogger.com editor, you can start to write markdown text like below.
<md>## This is a testing.</md>
3. The markdown result will be like below. ## This is a testing.

Thursday, June 5, 2025

Ivona Voice Lexicon Configuration Directory

Below is the Ivona Voice Lexicon File Configuration Directory,

%AppData%\IVONA 2 Voice
The configuration files are separate by type of languages, e.g. british-english-ivona.lex

Wednesday, June 4, 2025

Intel 11th Generation CPU Instruction Sets available on Hyper-V Ubuntu guest

In the past post Intel 11th Generation CPU Instructions Available on Hyper-V, it has shown the information about CPU instruction sets available on Windows 11 Pro host and Windows Guest VM. But how about Linux guest? It will be shown on below, but please note due to being unable to use CoreInfo on Ubuntu guest, we just use the <em>lscpu</em> command to display the instruction sets.

Architecture:             x86_64
  CPU op-mode(s):         32-bit, 64-bit
  Address sizes:          39 bits physical, 48 bits virtual
  Byte Order:             Little Endian
CPU(s):                   4
  On-line CPU(s) list:    0-3
Vendor ID:                GenuineIntel
  Model name:             11th Gen Intel(R) Core(TM) i5-1135G7 @ 2.40GHz
    CPU family:           6
    Model:                140
    Thread(s) per core:   2
    Core(s) per socket:   2
    Socket(s):            1
    Stepping:             1
    BogoMIPS:             4838.39
    Flags:                fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse s
                          se2 ss ht syscall nx pdpe1gb rdtscp lm constant_tsc rep_good nopl xtopology tsc_reliable nonst
                          op_tsc cpuid aperfmperf tsc_known_freq pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic
                          movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm 3dnowprefetch
                           ssbd ibrs ibpb stibp ibrs_enhanced fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid avx51
                          2f avx512dq rdseed adx smap avx512ifma clflushopt clwb avx512cd sha_ni avx512bw avx512vl xsave
                          opt xsavec xgetbv1 xsaves user_shstk avx512vbmi umip avx512_vbmi2 gfni vaes vpclmulqdq avx512_
                          vnni avx512_bitalg avx512_vpopcntdq rdpid movdiri movdir64b fsrm avx512_vp2intersect md_clear
                          ibt flush_l1d arch_capabilities
Virtualization features:
  Hypervisor vendor:      Microsoft
  Virtualization type:    full

And due to being unable to do direct comparison, we will use AI to help do the comparison. Please note AI can make mistakes, the comparison below only for learning purposes. For the AI comparison also, we can see the CPU Instructions available in Ubuntu guest are almost similar with Windows guest as per last post.

AI Comparison

Here's a comparison of the CPU instructions from List 1 (Windows CoreInfo) and List 2 (Ubuntu lscpu).

List 1 CPU Instructions Not Directly Present in List 2

Based on the provided lists and common lscpu flag conventions, the following List 1 instructions do not have a direct corresponding flag in List 2. Some of these may refer to broader technologies, specific MSRs, or hardware features not typically detailed as individual flags by lscpu:

  1. MONITOR: Refers to MONITOR/MWAIT instructions. While often present on modern CPUs, lscpu may not always list a specific flag for it.
  2. DTES64: "Can write history of 64-bit branch addresses" (Debug Trace ETM Subsystem 64-bit). Specific debug capabilities like this are often not itemized in lscpu flags.
  3. DS: "Implements memory-resident debug buffer" (Debug Store). Similar to DTES64, specific debug features may not have individual flags in lscpu.
  4. PDCM: "Supports Performance Capabilities MSR". lscpu typically doesn't list flags for specific MSRs by such names.
  5. xTPR: "Supports disabling task priority messages". While related to APIC, a specific xtpr or xtpr_update_control flag is not in List 2.
  6. EIST: "Supports Enhanced Intel SpeedStep". lscpu might show est on older systems or related flags like hwp (Hardware P-states) but not typically "EIST" by name. Power management features are often handled differently.
  7. ACPI: "Implements MSR for power management". ACPI is a broad standard, not a specific CPU instruction flag that lscpu would list.
  8. TM: "Implements thermal monitor circuitry" (Thermal Monitor 1). Basic thermal monitoring is standard; specific flags like tm or thermal_monitor are not in this List 2.
  9. TM2: "Implements Thermal Monitor 2 control". Similar to TM, not present as a flag in List 2.
  10. PBE: "Supports use of FERR#/PBE# pin" (Pending Break Enable). This refers to a specific hardware signaling feature not typically listed as an lscpu CPU flag.

Mapping Table of List 1 to List 2 Instructions

The following table maps each instruction from List 1 to its corresponding instruction or feature in List 2. Notes are provided where names or groupings differ but refer to similar functionalities.


List 1 Instruction (CoreInfo) List 2 Instruction/Note (lscpu)
HTT ht (Hyperthreading)
CET ibt, user_shstk (Control Flow Enforcement Technology components: Indirect Branch Tracking and User-mode Shadow Stack)
User CET user_shstk (User-mode Shadow Stack, a component of User-mode CET)
HYPERVISOR hypervisor
X64 lm (Long Mode, indicates 64-bit support)
NX nx (No-eXecute bit)
SMEP smep (Supervisor Mode Execution Prevention)
SMAP smap (Supervisor Mode Access Prevention)
PAGE1GB pdpe1gb (1GB Page Support)
PAE pae (Physical Address Extension)
PAT pat (Page Attribute Table)
PSE pse (Page Size Extension)
PSE36 pse36 (36-bit Page Size Extension)
PGE pge (Page Global Enable)
SS ss (Self-Snoop)
VME vme (Virtual Mode Extensions)
RDWRFSGSBASE fsgsbase (FS/GS Base access instructions)
FPU fpu (Floating Point Unit)
MMX mmx
SSE sse (Streaming SIMD Extensions)
SSE2 sse2 (Streaming SIMD Extensions 2)
SSE3 pni (Prescott New Instructions, an alternative name for SSE3)
SSSE3 ssse3 (Supplemental Streaming SIMD Extensions 3)
SSE4.1 sse4_1 (Streaming SIMD Extensions 4.1)
SSE4.2 sse4_2 (Streaming SIMD Extensions 4.2)
AES aes (AES New Instructions)
AVX avx (Advanced Vector Extensions)
AVX2 avx2 (Advanced Vector Extensions 2)
AVX-512-F avx512f (AVX-512 Foundation)
AVX-512-DQ avx512dq (AVX-512 Doubleword and Quadword Instructions)
AVX-512-IFAMA avx512ifma (AVX-512 Integer Fused Multiply-Add)
AVX-512-CD avx512cd (AVX-512 Conflict Detection Instructions)
AVX-512-BW avx512bw (AVX-512 Byte and Word Instructions)
AVX-512-VL avx512vl (AVX-512 Vector Length Extensions)
FMA fma (Fused Multiply-Add)
MSR msr (Model Specific Registers RDMSR/WRMSR)
MTRR mtrr (Memory Type Range Registers)
XSAVE xsave (XSAVE/XRSTOR instructions). List 2 also has xsaveopt, xsavec, xsaves.
OSXSAVE xgetbv1 (Indicates OS support for XSAVE features via XGETBV[1])
RDRAND rdrand (RDRAND instruction)
RDSEED rdseed (RDSEED instruction)
CMOV cmov (Conditional Move instruction)
CLFSH clflush (CLFLUSH instruction). List 2 also has clflushopt, clwb.
CX8 cx8 (CMPXCHG8B instruction)
CX16 cx16 (CMPXCHG16B instruction)
BMI1 bmi1 (Bit Manipulation Instructions 1)
BMI2 bmi2 (Bit Manipulation Instructions 2)
ADX adx (ADCX/ADOX instructions)
F16C f16c (16-bit Floating-Point conversion instructions)
FXSR fxsr (FXSAVE/FXRSTOR instructions)
MONITOR Not directly listed in List 2.
MOVBE movbe (Move Big-Endian instruction)
ERMSB erms (Enhanced REP MOVSB/STOSB)
PCLMULDQ pclmulqdq (Carry-Less Multiplication instruction)
POPCNT popcnt (Population Count instruction)
LZCNT abm (Advanced Bit Manipulation, includes LZCNT). Note: popcnt is also part of abm but listed separately in both.
SEP sep (SYSENTER/SYSEXIT, Fast System Call)
LAHF-SAHF lahf_lm (LAHF/SAHF in Long Mode)
DE de (Debugging Extensions)
DTES64 Not directly listed in List 2.
DS Not directly listed in List 2.
PCID pcid (Process Context Identifiers)
INVPCID invpcid (Invalidate Process Context Identifier)
PDCM Not directly listed in List 2.
RDTSCP rdtscp (Read Time-Stamp Counter and Processor ID)
TSC tsc (Time Stamp Counter)
TSC-DEADLINE tsc_deadline_timer (TSC Deadline Timer)
TSC-INVARIANT constant_tsc, nonstop_tsc, tsc_reliable (These flags collectively indicate an invariant TSC)
xTPR Not directly listed in List 2.
EIST Not directly listed in List 2 by this name.
ACPI Not directly listed in List 2 as a CPU flag.
TM Not directly listed in List 2 by this name.
TM2 Not directly listed in List 2 by this name.
APIC apic (Advanced Programmable Interrupt Controller)
x2APIC x2apic (x2 Advanced Programmable Interrupt Controller)
MCE mce (Machine Check Exception)
MCA mca (Machine Check Architecture)
PBE Not directly listed in List 2.
PREFETCHW 3dnowprefetch (AMD 3DNow! prefetch extensions, which include PREFETCHW). Intel CPUs might list prefetchw separately; if so, it's missing from this specific List 2 snippet

Monday, June 2, 2025

New AI Search function in SQL Server 2025 Preview

SQL Server 2025 Preview has added a new AI vector search feature, developers now can you semantic or natural language to search their own data instead of just SQL script such as <code>LIKE</code> syntax. This should be a very convenient thing for developers, though it requires some setup. Please watch the video for details. 


Saturday, May 31, 2025

What is the role of AI models in term of developer's perspective?

Nowadays in year 2025, the storm of generative AI already happening for about two and the half years. But what is the role of AI models such as Open AI models, Gemini models, and many other open-source models such as Llama and Phi from developer's perspective? 

From a raw perspective, all AI models are just a raw material that required to build some things useful, but by itself it can be very primitive. Developers should use the raw material and by creativity and innovation build some things useful using the generative AI models.

By using another metaphor, AI models are just like programming languages, a programming language can be powerful, but without developers to build and innovate new pieces of software, the programming itself cannot be as useful as it can. 

Therefore, it is important and useful to at least learn how to apply the AI model before that can further innovate new pieces of software instead of just leaving generative AI as chatbots only. Developers do not always need to learn about machine learning, though it some time be useful and help, but they must learn how to apply the AI models.



Friday, May 30, 2025

SQL Server 2025 Incorrect syntax near '=' for AI_GENERATE_CHUNKS

If you get the error below on SQL Server 2025 for AI_GENERATE_CHUNKS AI functions, please make sure your database compatibility level is in SQL Server 2025 version.

Msg 102, Level 15, State 38, Line 8
Incorrect syntax near '='.

Completion time: 2025-05-30T16:50:52.0246402+08:00

You can set the DB compatibility level by right-click the DB > click the Properties menu > Options tab > Compatibility level.



How to add a Windows 11 guest that support the Windows 11 requirements on Windows 11 Hyper-V host?

If you try to setup Windows 11 guest on Windows 11 Hyper-V default template, you will found the error below during setup.
But since you are already in Windows 11 host, then your system should be supported Windows 11 system requirements. So, how to resolve this issue?

You just need to go to your virtual machine settings on Hyper-V, enable the TPM (Trusted Platform Module), then you are set to go on Windows 11 guest setup.



Tuesday, May 27, 2025

Intel 11th Generation CPU Instructions Available on Hyper-V

Below is list of CPU instructions available on Windows 11 Pro Host for an 11th Gen Intel processor using Sysinternals Coreinfo
Note: * should be available CPU Instruction, and - is not available.
HTT             *       Hyperthreading enabled
CET             *       Supports Control Flow Enforcement Technology
Kernel CET      -       Kernel-mode CET Enabled
User CET        *       User-mode CET Allowed
HYPERVISOR      *       Hypervisor is present
VMX             -       Supports Intel hardware-assisted virtualization
SVM             -       Supports AMD hardware-assisted virtualization
X64             *       Supports 64-bit mode

SMX             -       Supports Intel trusted execution
SKINIT          -       Supports AMD SKINIT
SGX             -       Supports Intel SGX

NX              *       Supports no-execute page protection
SMEP            *       Supports Supervisor Mode Execution Prevention
SMAP            *       Supports Supervisor Mode Access Prevention
PAGE1GB         *       Supports 1 GB large pages
PAE             *       Supports > 32-bit physical addresses
PAT             *       Supports Page Attribute Table
PSE             *       Supports 4 MB pages
PSE36           *       Supports > 32-bit address 4 MB pages
PGE             *       Supports global bit in page tables
SS              *       Supports bus snooping for cache operations
VME             *       Supports Virtual-8086 mode
RDWRFSGSBASE    *       Supports direct GS/FS base access

FPU             *       Implements i387 floating point instructions
MMX             *       Supports MMX instruction set
MMXEXT          -       Implements AMD MMX extensions
3DNOW           -       Supports 3DNow! instructions
3DNOWEXT        -       Supports 3DNow! extension instructions
SSE             *       Supports Streaming SIMD Extensions
SSE2            *       Supports Streaming SIMD Extensions 2
SSE3            *       Supports Streaming SIMD Extensions 3
SSSE3           *       Supports Supplemental SIMD Extensions 3
SSE4a           -       Supports Streaming SIMDR Extensions 4a
SSE4.1          *       Supports Streaming SIMD Extensions 4.1
SSE4.2          *       Supports Streaming SIMD Extensions 4.2

AES             *       Supports AES extensions
AVX             *       Supports AVX instruction extensions
AVX2            *       Supports AVX2 instruction extensions
AVX-512-F       *       Supports AVX-512 Foundation instructions
AVX-512-DQ      *       Supports AVX-512 double and quadword instructions
AVX-512-IFAMA   *       Supports AVX-512 integer Fused multiply-add instructions
AVX-512-PF      -       Supports AVX-512 prefetch instructions
AVX-512-ER      -       Supports AVX-512 exponential and reciprocal instructions
AVX-512-CD      *       Supports AVX-512 conflict detection instructions
AVX-512-BW      *       Supports AVX-512 byte and word instructions
AVX-512-VL      *       Supports AVX-512 vector length instructions
FMA             *       Supports FMA extensions using YMM state
MSR             *       Implements RDMSR/WRMSR instructions
MTRR            *       Supports Memory Type Range Registers
XSAVE           *       Supports XSAVE/XRSTOR instructions
OSXSAVE         *       Supports XSETBV/XGETBV instructions
RDRAND          *       Supports RDRAND instruction
RDSEED          *       Supports RDSEED instruction

CMOV            *       Supports CMOVcc instruction
CLFSH           *       Supports CLFLUSH instruction
CX8             *       Supports compare and exchange 8-byte instructions
CX16            *       Supports CMPXCHG16B instruction
BMI1            *       Supports bit manipulation extensions 1
BMI2            *       Supports bit manipulation extensions 2
ADX             *       Supports ADCX/ADOX instructions
DCA             -       Supports prefetch from memory-mapped device
F16C            *       Supports half-precision instruction
FXSR            *       Supports FXSAVE/FXSTOR instructions
FFXSR           -       Supports optimized FXSAVE/FSRSTOR instruction
MONITOR         *       Supports MONITOR and MWAIT instructions
MOVBE           *       Supports MOVBE instruction
ERMSB           *       Supports Enhanced REP MOVSB/STOSB
PCLMULDQ        *       Supports PCLMULDQ instruction
POPCNT          *       Supports POPCNT instruction
LZCNT           *       Supports LZCNT instruction
SEP             *       Supports fast system call instructions
LAHF-SAHF       *       Supports LAHF/SAHF instructions in 64-bit mode
HLE             -       Supports Hardware Lock Elision instructions
RTM             -       Supports Restricted Transactional Memory instructions

DE              *       Supports I/O breakpoints including CR4.DE
DTES64          *       Can write history of 64-bit branch addresses
DS              *       Implements memory-resident debug buffer
DS-CPL          -       Supports Debug Store feature with CPL
PCID            *       Supports PCIDs and settable CR4.PCIDE
INVPCID         *       Supports INVPCID instruction
PDCM            *       Supports Performance Capabilities MSR
RDTSCP          *       Supports RDTSCP instruction
TSC             *       Supports RDTSC instruction
TSC-DEADLINE    *       Local APIC supports one-shot deadline timer
TSC-INVARIANT   *       TSC runs at constant rate
xTPR            *       Supports disabling task priority messages

EIST            *       Supports Enhanced Intel Speedstep
ACPI            *       Implements MSR for power management
TM              *       Implements thermal monitor circuitry
TM2             *       Implements Thermal Monitor 2 control
APIC            *       Implements software-accessible local APIC
x2APIC          *       Supports x2APIC

CNXT-ID         -       L1 data cache mode adaptive or BIOS

MCE             *       Supports Machine Check, INT18 and CR4.MCE
MCA             *       Implements Machine Check Architecture
PBE             *       Supports use of FERR#/PBE# pin

PSN             -       Implements 96-bit processor serial number

PREFETCHW       *       Supports PREFETCHW instruction
Below is a list of CPU instructions available on Hyper-V Windows 10 guest.
HTT             *       Hyperthreading enabled
CET             *       Supports Control Flow Enforcement Technology
Kernel CET      -       Kernel-mode CET Enabled
User CET        *       User-mode CET Allowed
HYPERVISOR      *       Hypervisor is present
VMX             -       Supports Intel hardware-assisted virtualization
SVM             -       Supports AMD hardware-assisted virtualization
X64             *       Supports 64-bit mode

SMX             -       Supports Intel trusted execution
SKINIT          -       Supports AMD SKINIT
SGX             -       Supports Intel SGX

NX              *       Supports no-execute page protection
SMEP            *       Supports Supervisor Mode Execution Prevention
SMAP            *       Supports Supervisor Mode Access Prevention
PAGE1GB         *       Supports 1 GB large pages
PAE             *       Supports > 32-bit physical addresses
PAT             *       Supports Page Attribute Table
PSE             *       Supports 4 MB pages
PSE36           *       Supports > 32-bit address 4 MB pages
PGE             *       Supports global bit in page tables
SS              *       Supports bus snooping for cache operations
VME             *       Supports Virtual-8086 mode
RDWRFSGSBASE    *       Supports direct GS/FS base access

FPU             *       Implements i387 floating point instructions
MMX             *       Supports MMX instruction set
MMXEXT          -       Implements AMD MMX extensions
3DNOW           -       Supports 3DNow! instructions
3DNOWEXT        -       Supports 3DNow! extension instructions
SSE             *       Supports Streaming SIMD Extensions
SSE2            *       Supports Streaming SIMD Extensions 2
SSE3            *       Supports Streaming SIMD Extensions 3
SSSE3           *       Supports Supplemental SIMD Extensions 3
SSE4a           -       Supports Streaming SIMDR Extensions 4a
SSE4.1          *       Supports Streaming SIMD Extensions 4.1
SSE4.2          *       Supports Streaming SIMD Extensions 4.2

AES             *       Supports AES extensions
AVX             *       Supports AVX instruction extensions
AVX2            *       Supports AVX2 instruction extensions
AVX-512-F       *       Supports AVX-512 Foundation instructions
AVX-512-DQ      *       Supports AVX-512 double and quadword instructions
AVX-512-IFAMA   *       Supports AVX-512 integer Fused multiply-add instructions
AVX-512-PF      -       Supports AVX-512 prefetch instructions
AVX-512-ER      -       Supports AVX-512 exponential and reciprocal instructions
AVX-512-CD      *       Supports AVX-512 conflict detection instructions
AVX-512-BW      *       Supports AVX-512 byte and word instructions
AVX-512-VL      *       Supports AVX-512 vector length instructions
FMA             *       Supports FMA extensions using YMM state
MSR             *       Implements RDMSR/WRMSR instructions
MTRR            *       Supports Memory Type Range Registers
XSAVE           *       Supports XSAVE/XRSTOR instructions
OSXSAVE         *       Supports XSETBV/XGETBV instructions
RDRAND          *       Supports RDRAND instruction
RDSEED          *       Supports RDSEED instruction

CMOV            *       Supports CMOVcc instruction
CLFSH           *       Supports CLFLUSH instruction
CX8             *       Supports compare and exchange 8-byte instructions
CX16            *       Supports CMPXCHG16B instruction
BMI1            *       Supports bit manipulation extensions 1
BMI2            *       Supports bit manipulation extensions 2
ADX             *       Supports ADCX/ADOX instructions
DCA             -       Supports prefetch from memory-mapped device
F16C            *       Supports half-precision instruction
FXSR            *       Supports FXSAVE/FXSTOR instructions
FFXSR           -       Supports optimized FXSAVE/FSRSTOR instruction
MONITOR         -       Supports MONITOR and MWAIT instructions
MOVBE           *       Supports MOVBE instruction
ERMSB           *       Supports Enhanced REP MOVSB/STOSB
PCLMULDQ        *       Supports PCLMULDQ instruction
POPCNT          *       Supports POPCNT instruction
LZCNT           *       Supports LZCNT instruction
SEP             *       Supports fast system call instructions
LAHF-SAHF       *       Supports LAHF/SAHF instructions in 64-bit mode
HLE             -       Supports Hardware Lock Elision instructions
RTM             -       Supports Restricted Transactional Memory instructions

DE              *       Supports I/O breakpoints including CR4.DE
DTES64          -       Can write history of 64-bit branch addresses
DS              -       Implements memory-resident debug buffer
DS-CPL          -       Supports Debug Store feature with CPL
PCID            *       Supports PCIDs and settable CR4.PCIDE
INVPCID         *       Supports INVPCID instruction
PDCM            -       Supports Performance Capabilities MSR
RDTSCP          *       Supports RDTSCP instruction
TSC             *       Supports RDTSC instruction
TSC-DEADLINE    *       Local APIC supports one-shot deadline timer
TSC-INVARIANT   *       TSC runs at constant rate
xTPR            -       Supports disabling task priority messages

EIST            -       Supports Enhanced Intel Speedstep
ACPI            -       Implements MSR for power management
TM              -       Implements thermal monitor circuitry
TM2             -       Implements Thermal Monitor 2 control
APIC            *       Implements software-accessible local APIC
x2APIC          *       Supports x2APIC

CNXT-ID         -       L1 data cache mode adaptive or BIOS

MCE             *       Supports Machine Check, INT18 and CR4.MCE
MCA             *       Implements Machine Check Architecture
PBE             -       Supports use of FERR#/PBE# pin

PSN             -       Implements 96-bit processor serial number

PREFETCHW       *       Supports PREFETCHW instruction
If we compare between both, the result will be like below. As you can see, most of the CPU Instructions not available to the guest are mainly important for the Host OS only, such as Debug, Monitor, and Power Management.
List of CPU Instructions not available on the guest.
MONITOR         -       Supports MONITOR and MWAIT instructions
DTES64          -       Can write history of 64-bit branch addresses
DS              -       Implements memory-resident debug buffer
PDCM            -       Supports Performance Capabilities MSR
xTPR            -       Supports disabling task priority messages
EIST            -       Supports Enhanced Intel Speedstep
ACPI            -       Implements MSR for power management
TM              -       Implements thermal monitor circuitry
TM2             -       Implements Thermal Monitor 2 control
PBE             -       Supports use of FERR#/PBE# pin
For Windows 11 Sandbox, strangely enough, the differences are slightly difference with Hyper-V guest.
HTT             *       Hyperthreading enabled
CET             *       Supports Control Flow Enforcement Technology
Kernel CET      -       Kernel-mode CET Enabled
User CET        *       User-mode CET Allowed
HYPERVISOR      *       Hypervisor is present
VMX             -       Supports Intel hardware-assisted virtualization
SVM             -       Supports AMD hardware-assisted virtualization
X64             *       Supports 64-bit mode

SMX             -       Supports Intel trusted execution
SKINIT          -       Supports AMD SKINIT
SGX             -       Supports Intel SGX

NX              *       Supports no-execute page protection
SMEP            *       Supports Supervisor Mode Execution Prevention
SMAP            *       Supports Supervisor Mode Access Prevention
PAGE1GB         *       Supports 1 GB large pages
PAE             *       Supports > 32-bit physical addresses
PAT             *       Supports Page Attribute Table
PSE             *       Supports 4 MB pages
PSE36           *       Supports > 32-bit address 4 MB pages
PGE             *       Supports global bit in page tables
SS              *       Supports bus snooping for cache operations
VME             *       Supports Virtual-8086 mode
RDWRFSGSBASE    *       Supports direct GS/FS base access

FPU             *       Implements i387 floating point instructions
MMX             *       Supports MMX instruction set
MMXEXT          -       Implements AMD MMX extensions
3DNOW           -       Supports 3DNow! instructions
3DNOWEXT        -       Supports 3DNow! extension instructions
SSE             *       Supports Streaming SIMD Extensions
SSE2            *       Supports Streaming SIMD Extensions 2
SSE3            *       Supports Streaming SIMD Extensions 3
SSSE3           *       Supports Supplemental SIMD Extensions 3
SSE4a           -       Supports Streaming SIMDR Extensions 4a
SSE4.1          *       Supports Streaming SIMD Extensions 4.1
SSE4.2          *       Supports Streaming SIMD Extensions 4.2

AES             *       Supports AES extensions
AVX             *       Supports AVX instruction extensions
AVX2            *       Supports AVX2 instruction extensions
AVX-512-F       *       Supports AVX-512 Foundation instructions
AVX-512-DQ      *       Supports AVX-512 double and quadword instructions
AVX-512-IFAMA   *       Supports AVX-512 integer Fused multiply-add instructions
AVX-512-PF      -       Supports AVX-512 prefetch instructions
AVX-512-ER      -       Supports AVX-512 exponential and reciprocal instructions
AVX-512-CD      *       Supports AVX-512 conflict detection instructions
AVX-512-BW      *       Supports AVX-512 byte and word instructions
AVX-512-VL      *       Supports AVX-512 vector length instructions
FMA             *       Supports FMA extensions using YMM state
MSR             *       Implements RDMSR/WRMSR instructions
MTRR            *       Supports Memory Type Range Registers
XSAVE           *       Supports XSAVE/XRSTOR instructions
OSXSAVE         *       Supports XSETBV/XGETBV instructions
RDRAND          *       Supports RDRAND instruction
RDSEED          *       Supports RDSEED instruction

CMOV            *       Supports CMOVcc instruction
CLFSH           *       Supports CLFLUSH instruction
CX8             *       Supports compare and exchange 8-byte instructions
CX16            *       Supports CMPXCHG16B instruction
BMI1            *       Supports bit manipulation extensions 1
BMI2            *       Supports bit manipulation extensions 2
ADX             *       Supports ADCX/ADOX instructions
DCA             -       Supports prefetch from memory-mapped device
F16C            *       Supports half-precision instruction
FXSR            *       Supports FXSAVE/FXSTOR instructions
FFXSR           -       Supports optimized FXSAVE/FSRSTOR instruction
MONITOR         -       Supports MONITOR and MWAIT instructions
MOVBE           *       Supports MOVBE instruction
ERMSB           *       Supports Enhanced REP MOVSB/STOSB
PCLMULDQ        *       Supports PCLMULDQ instruction
POPCNT          *       Supports POPCNT instruction
LZCNT           *       Supports LZCNT instruction
SEP             *       Supports fast system call instructions
LAHF-SAHF       *       Supports LAHF/SAHF instructions in 64-bit mode
HLE             -       Supports Hardware Lock Elision instructions
RTM             -       Supports Restricted Transactional Memory instructions

DE              *       Supports I/O breakpoints including CR4.DE
DTES64          -       Can write history of 64-bit branch addresses
DS              -       Implements memory-resident debug buffer
DS-CPL          -       Supports Debug Store feature with CPL
PCID            *       Supports PCIDs and settable CR4.PCIDE
INVPCID         *       Supports INVPCID instruction
PDCM            *       Supports Performance Capabilities MSR
RDTSCP          *       Supports RDTSCP instruction
TSC             *       Supports RDTSC instruction
TSC-DEADLINE    -       Local APIC supports one-shot deadline timer
TSC-INVARIANT   -       TSC runs at constant rate
xTPR            -       Supports disabling task priority messages

EIST            -       Supports Enhanced Intel Speedstep
ACPI            -       Implements MSR for power management
TM              -       Implements thermal monitor circuitry
TM2             -       Implements Thermal Monitor 2 control
APIC            *       Implements software-accessible local APIC
x2APIC          *       Supports x2APIC

CNXT-ID         -       L1 data cache mode adaptive or BIOS

MCE             *       Supports Machine Check, INT18 and CR4.MCE
MCA             *       Implements Machine Check Architecture
PBE             -       Supports use of FERR#/PBE# pin

PSN             -       Implements 96-bit processor serial number

PREFETCHW       *       Supports PREFETCHW instruction
For the information above, it seems like Hyper-V exposes almost all the important CPU Instructions to the guest OS without any configuration which is difference with VirtualBox such as what mentioned on the Stack Overflow link below on quite many users find it difficult to enable AVX CPU Instructions.
How to enable AVX / AVX2 in VirtualBox 6.1.16 with Ubuntu 20.04 64bit?

Summary: The Future of Work in the Age of AI

The Edge Malaysia Weekly (May 26, 2025 – June 1, 2025) Digital Intelligence: AI’s impact on jobs: Evolution not extinction is an article that worth reading about the future of work in the AI age. Please consider heading to The Edge Malaysia to read the full article.

AI Summary

AI will transform rather than eliminate jobs, creating a net gain of millions of new roles by 2030. It automates repetitive tasks but enhances human creativity, strategy, and empathy. Across sectors like tech, finance, healthcare, and manufacturing, AI acts as a tool that boosts productivity while humans handle complex decisions. Emerging roles include AI developers and ethicists. Success in the AI era requires combining technical skills with emotional intelligence and adaptability.

Saturday, May 24, 2025

How to add Pure CSS table to Blogger.com

It is simple to add Pure CSS table CSS style to Blogger.com. First, go to Blogger dashboard > Theme > Edit HTML. Then, add the line below to before </head> and save.
<link href='https://cdn.jsdelivr.net/npm/purecss@3.0.0/build/tables-min.css' rel='stylesheet'/>
An example of table will be like below, just make sure the table has a class attribute is pure-table.
<table class="pure-table">
    <thead>
        <tr>
            <th>#</th>
            <th>Make</th>
            <th>Model</th>
            <th>Year</th>
        </tr>
    </thead>
    <tbody>
        <tr>
            <td>1</td>
            <td>Honda</td>
            <td>Accord</td>
            <td>2009</td>
        </tr>
        <tr>
            <td>2</td>
            <td>Toyota</td>
            <td>Camry</td>
            <td>2012</td>
        </tr>
        <tr>
            <td>3</td>
            <td>Hyundai</td>
            <td>Elantra</td>
            <td>2010</td>
        </tr>
    </tbody>
</table>
# Make Model Year
1 Honda Accord 2009
2 Toyota Camry 2012
3 Hyundai Elantra 2010

How to add Mermaid.js to Blogger.com with dark theme

  1. Go to Blogger dashboard > Theme > Edit HTML.
  2. Add these lines before </head>. Note: Please go to https://mermaid.js.org/config/usage.html to check the latest usage.
  3. <script src='https://cdn.jsdelivr.net/npm/mermaid@11.6.0/dist/mermaid.min.js'/>
    <script>
      mermaid.initialize({startOnLoad: true, theme: 'dark'});
    </script>
  4. Finally, the example mermaid.js code and diagram will be like below:
  5. <div class="mermaid">
      graph TD;
        A-->B;
        A-->C;
        B-->D;
        C-->D;
    </div>
graph TD; A-->B; A-->C; B-->D; C-->D;