Posts by ISeeTWizard

  • Add the registry editor to the Control Panel

    The text is in German and can obviously adapted to your needs.

  • Add .reg, .bat and .cmd to the shell menu

  • Change the start menu in Windows 11

    Code
    Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced]
"Start_ShowClassicMode"=dword:00000000

    Setting its data to 1 would enable the classic menu, while setting it to 0 (or deleting it) restores the default Windows 11 Start Menu, though Microsoft has disabled this function in newer Windows 11 builds.

  • Add the Control Panel to the Shell Menu

    Code
    Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\DesktopBackground\Shell\Systemsteuerung]
"icon"="control.exe"
@="@=@shell32.dll,-4161"

[HKEY_CLASSES_ROOT\DesktopBackground\Shell\Systemsteuerung\command]
@="control.exe"

    This is the german version - you can replace "Systemsteuerung" by "Control Panel" as example

  • Disable UAC

    Code
    Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System]
"ConsentPromptBehaviorAdmin"=dword:00000000
"ConsentPromptBehaviorUser"=dword:00000000
"EnableLUA"=dword:00000000
"PromptOnSecureDesktop"=dword:00000000

  • Add Command Prompt to right click menu

  • Add Windows Update to Control Panel

  • Windows cannot be installed on USB disk

    I recently had the issue that I wanted to upgrade to the latest Windows 11 version for a customer but it didn't work. I just always got a message that it couldn't be installed on a USB disk but it was an SSD.

    If you get this maybe the one who installed the OS primarily did an error by mistake or knowingly so he could return and get even some more money...

    But I found out what registry key to remove:

    Code
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control
Look for PortableOperatingSystem and if this one is set to 1 set it to 0 or simply delete it
    Code
    Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control]
"PortableOperatingSystem"=dword:00000000

    You need to restart the installer from scrap at this time or even better reboot the machine first.

    If that doesn't help the issue is much more complicate and most of the time it's easier to simply reinstall the machine correctly.

  • HUAWEI Band 10

    Rating
    4.2/5
    Good

    Description

    The Huawei Band 10 is a lightweight, affordable fitness tracker that offers comprehensive health and activity monitoring, featuring a vibrant AMOLED screen, extensive workout modes (over 100), advanced sleep tracking with HRV monitoring, SpO2, stress management, and long battery life (up to 14 days), designed for users who want detailed wellness insights and smart notifications without the complexity or cost of a full smartwatch, making it an excellent budget-friendly option compatible with both iOS and Android.


    Ratings

    Quality

    4 out of 5

    Easy to use

    4 out of 5

    Sensors

    4 out of 5

    Battery

    4 out of 5

    App

    3 out of 5


    Photos


    Specifications

    Dimensions: 43.45 × 24.86 × 8.99 mm
    Weight: about 15g
    Display: 1.47 inch AMOLED, 194 × 368 pixels, PPI 282
    Sensors: 9-axis IMU sensor (Accelerometer sensor, Gyroscope sensor, Magnetometer sensor), Optical heart rate sensor, Ambient light sensor
    Charging: Magnetic charging port
    System requirements: Android 9.0 or later / iOS 13.0 or later
    Waterproof: 5 ATM
    Connectivity: 2.4 GHz, BT 5.0, and BLE

    My Opinion

    I love this band. It's so small and light. You can wear it all day without realizing that it is their.

    The sensors are working very well and are even accurate and that for that small price. But pay attention that this isn't an health device - it's just to use as additional info.

    The app in itself is also OK but it's more doing advertising for their payed watch faces than anything else.
    What I also don't like is that you need an account with Huawei and for that you need to be 18. As I bought those for my kids (12 and 13) I couldn't create an account for them which is ridiculous - so I simply made them 10 years older just to be able to create that account to be able to use that watch.


    Related links (non affiliate!)

    Amazon Germany


  • DYMO LetraTag 200B

    Rating
    3.4/5
    Neutral

    Description

    The DYMO LetraTag 200B is a portable, Bluetooth-enabled label maker that connects wirelessly to your smartphone or tablet via the DYMO LetraTag Connect app for easy label creation and printing, ideal for home and office organization, offering various fonts, icons, and boxes on different tape types, including plastic, paper, and iron-on fabric, with its compact design and automatic connection making it convenient for on-the-go use.


    Ratings

    Quality

    4 out of 5

    Easy to use

    4 out of 5

    Print Speed

    3 out of 5

    App

    3 out of 5


    Photos


    Specifications

    • Dimensions: 120mm x 120mm x 45mm
    • Color: Black
    • Software Compatibility: Android v10.0 (or higher) / Apple iOS v13 (or higher)
    • Label Compatibility: LetraTag Tapes


    My Opinion

    I thought it was a good device for replacing my normal Dymo Label Printer but I didn't expect to get such a device in our actual time that only works exclusively with batteries. No possibility to connect an external power supply - nothing.
    Than you need a special app for this device, the normal DymoConnect App doesn't work, you need LT Connect.
    And the worst: On every single print the app reconnects to the printer - so you loose so many time due to that.

    Not even an auto cut function is included - so also after every print you have to cut your label.

    For me at the end it's a downgrade from the one I already own - the only positive is that I can use my phone to print which is more convenient for typing but for the rest... At least it takes the same tapes as my old device...


    Related links (non affiliate!)

    Amazon Germany


  • Govee 38cm RGBICWW Smart Ceiling Light Pro

    Rating
    4.8/5
    Excellent

    Description

    Introducing the Govee Smart Ceiling Light Pro! With its RGBIC+WW technology magic, your room will transform into a vibrant wonderland. Bigger in size, it blankets your space with dazzling colors and effects.

    • Planar Colorful Lighting Effect: The internal lamp beads of the main light are arranged in five concentric circles. Independent control for each light, a total of 120 segments, creating more detailed and dynamic effects.
    • High-Intensity Lighting: With a brightness of 4300lm, 79% brighter than normal lighting, it's suitable for multi-scene lighting.
    • Simple Installation: This 15-inch flush mount ceiling light can be installed in just five easy steps, saving time and effort.
    • Multiple Scene Modes & Music Modes: Includes 66+ scene modes, allowing you to DIY any lighting effect.
    • Smart Lighting Control: Adjust your light with a voice command. Supports Alexa, Google Assistant, and Matter.
    • Modern Style: Low-key fashion with its white simple round appearance, suitable for a modern home style.


    Ratings

    Quality

    5 out of 5

    Easy to use

    5 out of 5

    iPhone App

    4 out of 5

    Brightness

    5 out of 5

    Different Modes

    5 out of 5

    Music Mode

    4 out of 5


    Photos



    Specifications

    Model → H60A6
    Product Title → Govee 38cm RGBICWW Smart Ceiling Light Pro
    Main Light Displaying Technology → RGBIC+WW
    Back Light Displaying Technology → RGBICWW
    Lumens → 4300lm
    Color Temperature → 2700k-6500k
    Wattage → 48.5W
    App Connectivity → 2.4GHz Wi-Fi + Bluetooth
    Control Methods → Govee Home, Voice Control, Matter
    Energy Class → F


    My Opinion

    I was so impressed when switching this light on. It's so bright I wasn't prepared to it.

    Such a light falls and stands with it's app and the Govee Home App is great. You have so many scenes, colors and so on. Even the light can react to the music (with the help of the micro of your phone).

    Installation is very easy but don't use the screws you get with the package - they are a mess. Simply take your own or buy some good ones...

    For the rest myself I gonna replace every light in my apartment with this one. Of course not for the full price of 98,32€ but when they have some actions when I bought mine for 74,99€.


    Related links (non affiliate!)

    Amazon Germany


  • Apple iPad Air 11" with M3 chip

    Rating
    4.9/5
    Excellent

    Description

    iPad Air with the M3 chip and built for Apple Intelligence. iPad Air with M3 brings Apple’s advanced graphics architecture to iPad Air for the first time — taking its incredible combination of power-efficient performance and portability to a new level. iPad Air with M3 is nearly 2x faster compared to iPad Air with M1,1 and up to 3.5x faster than iPad Air with A14 Bionic.2 Users will feel the speed of M3 in everything they do, from creating engaging content faster than ever to playing demanding, graphics-intensive games. Available in two sizes and four gorgeous finishes that users love, the 11-inch iPad Air is super portable while on the go, and the 13-inch model provides an even larger display for more room to be creative and productive. Designed for iPad Air, the new Magic Keyboard enhances its versatility and delivers more capabilities. With iPadOS 18, support for Apple Intelligence, advanced cameras, fast wireless 5G connectivity, and compatibility with Apple Pencil Pro and Apple Pencil (USB-C), the new iPad Air offers an unrivaled experience.


    Ratings

    Performance

    5 out of 5

    Quality

    5 out of 5

    Weight

    4 out of 5

    Display

    5 out of 5


    Photos


    Specifications

    Width: 214.9 mm
    Height: 280.6 mm
    Depth: 6.1 mm
    Weight: 616 grams
    Color: purple
    Year introduced: 2025

    LED backlit Multi‑Touch display with IPS technology
    2732-by-2048-pixel resolution at 264 ppi
    Wide color (P3)
    True Tone
    Fingerprint-resistant oleophobic coating
    Fully laminated
    Antireflective coating
    600 nits brightness
    Supports Apple Pencil Pro, Apple Pencil (USB‑C)
    Apple Pencil hover

    Apple M3 chip
    8-core CPU with 4 performance cores and 4 efficiency cores
    9-core GPU
    Hardware-accelerated ray tracing
    16-core Neural Engine
    8GB RAM
    Media Engine
    Hardware-accelerated 8K HEVC, 4K H.264, ProRes, and ProRes RAW
    Video decode engine
    Video encode engine
    ProRes encode and decode engine
    AV1 decode

    12MP Wide camera, ƒ/1.8 aperture
    Digital zoom up to 5x
    Five-element lens
    Panorama (up to 63MP)
    Sapphire crystal lens cover
    Autofocus with Focus Pixels
    Smart HDR 4
    Wide color capture for photos and Live Photos
    Photo geotagging
    Auto image stabilization
    Burst mode
    Image formats captured: HEIF and JPEG

    You can find more specs here.


    My Opinion

    Like every iPad it's for me simply the best you can get in a tablet form. The speed, the quality, the price, everything is top. You can buy the simple iPad, the Air, the Pro, with every model you'll be satisfied. You just need to choose your model, so the one that fits your needs.

    Combined with the Magic Keyboard and Pencil it's a beast. My wife works a lot with the pencil and the iPad and she is so happy with the new one (she had my Pro one from 2018 and it's a huge difference)

    I just can recommend it - it's more than enough for most of the people. For kids I would use the normal one.


    Related links (non affiliate!)

    Amazon Germany


  • Apple Magic Keyboard Case for the 11" iPad Air (M3)

    Rating
    4.8/5
    Excellent

    Description

    Magic Keyboard is the perfect companion for iPad Air. It delivers an amazing typing experience and a trackpad for precision tasks in a sleek, portable design. The keyboard includes a 14‑key function row, a USB‑C connector for pass‑through charging, and front and back protection for your iPad. The floating cantilever design smoothly adjusts to multiple viewing angles and a large glass trackpad expands how you can work with iPadOS.


    Ratings

    Noise while typing

    4 out of 5

    Quality

    5 out of 5

    Weight

    3 out of 5

    Functionalities / Additional buttons / etc.

    4 out of 5


    Photos



    Specifications

    Portable cantilever design provides smooth adjustability and delivers the perfect viewing angle.
    Large glass trackpad for a responsive and intuitive experience.
    14-key function row for convenient access to screen brightness, volume controls, and other features.
    Comfortable typing experience with a scissor mechanism with 1 mm travel.
    Designed for Multi-Touch gestures and the cursor in iPadOS.
    USB-C connector for charging iPad Air, freeing up the connector on the iPad for other accessories.
    Folds into a case to provide front and back protection for traveling with iPad Air.

    Weight: 627g!!!


    My Opinion

    I never knew why someone would spend so much money for a keyboard only but this time I wanted to give it a try for the iPad Air I bought for my wife.

    I was more than astonished how good this keyboard is and how well manufactured. It takes it's energy directly from the iPad and the typing is really really relaxing. Even the trackpad works very well and with the latest iPadOS even the mouse pointer looks good and useful.

    The only inconvenient may be the weight. I found it very heavy with it's 627g - this is even more than the iPad Air itself which is about 460g.


    Related links (non affiliate!)

    Amazon Germany


  • SQL commands to master

    SELECT + FROM

    SQL
    SELECT
  order_id,
  customer_id,
  amount
FROM orders;

    Choose exactly which columns you want from which tables; every query starts here.


    WHERE

    SQL
    SELECT
  order_id,
  customer_id,
  amount
FROM orders
WHERE status = 'Completed'
  AND amount > 2000;

    Filters rows by conditions using > , < , AND , OR, IN, BETWEEN, LIKE


    JOIN (INNER + LEFT)

    INNER for "only matched"; LEFT for "all from left, even if no match", with NULL logic.


    GROUP BY

    SQL
    SELECT
  customer_id,
  COUNT(*) AS order_count,
  SUM(amount) AS total_spend
FROM orders
GROUP BY customer_id;

    Rolls many rows into one row per group (per customer, per month, per product).


    HAVING

    SQL
    SELECT
  customer-id,
  COUNT(*) AS order-count
FROM orders
GROUP BY customer_id
HAVING > 10;

    Filters groups after aggregation; use it when you need conditions on COUNT / SUM etc.


    Aggregates (COUNT, SUM, AVG, MIN, MAX)

    SQL
    SELECT
  COUNT(*) AS total_orders,

  SUM(amount) AS total-revenue,
  AVG(amount) AS avg_order-value,
  MIN(amount) AS min_order_value,
  MAX(amount) AS max_order_value
FROM orders;

    Core KPI tools; almost every analytics query uses at least one aggregate.


    Window functions (OVER)

    SQL
    SELECT
  account-id,
  txn-date,
  amount,
  SUM(amount) OVER (
    PARTITION BY account-id
    ORDER BY txn_date
   AS running_balance
FROM transactions;

    Lets you compute running totals, ranks, and "value vs group average" without collapsing rows.


    WITH (CTE) + subqueries

    CTE/subquery breaks complex logic into steps; used everywhere in reporting and interview questions.