C-NET :: PROJECTS

ls -t projects/ | grep -i "Windows"

Windows

2026

Excel Conditional Formatting

Two Excel conditional formatting tricks: apply a rule to a whole sheet, and match exact cell values with EXACT().

Windows · Reference

2025

Posting table data to a web API using PowerQuery in Excel

How to send Excel table data to a web API from PowerQuery by building a CSV payload and forcing Excel to make the request.

Howto's · Windows · Solved Problems · Software

2024

What the heck is Windows Antimalware Service scanning all the time?

How to find the files Windows Defender keeps scanning with MpPerformanceRecording, and exclude them to cut CPU use.

Windows · Solved Problems

2022

Moving columns in PowerQuery without naming every column

How to move a column to a given position in Power Query without naming every column, also when merging and expanding tables.

Windows · Reference · Solved Problems

2021

Allowing RDP remote passwords in Windows 10 in 2021

How to stop Windows 10 from prompting for a password when connecting with saved RDP credentials, through a Group Policy setting.

Windows · Reference · Solved Problems
DNS names for VirtualBox client machines

A PowerShell script that adds the IP addresses of running VirtualBox guests to the Windows hosts file, and autostarts chosen VMs headless.

Howto's · Linux · Windows · Reference · Solved Problems
DNS names for Hyper-V client machines

A PowerShell script that keeps the Windows hosts file updated with the IP addresses of running Hyper-V virtual machines.

Howto's · Linux · Windows · Solved Problems
Generating a C# library from swagger.json using Docker for Windows

How to generate a C# client library from a swagger.json URL with swagger-codegen or openapi-generator in Docker for Windows.

Windows · Reference

2019

“Invalid provider type specified” CryptographicException when accessing the PrivateKey property of a certificate in C#/.Net

How to fix the .Net "Invalid provider type specified" error on a certificate's private key by converting the CNG key to an RSA key with OpenSSL.

Windows · Solved Problems
The trust relationship between this workstation and the primary domain failed

How to fix a lost trust relationship with the domain on a restored Windows machine with Reset-ComputerMachinePassword, without rejoining the domain.

Windows · Reference · Solved Problems

2018

Who deleted the files from the Windows file server?

How to audit file deletions on a Windows file server and find who deleted a file, with a PowerShell script that reads the Security log.

Windows · Solved Problems
ClipWriter, a PowerShell script that emulates keyboard input to transfer files and text

ClipWriter, an open source PowerShell script that types text, files and directory trees into remote sessions that block pasting and file transfer.

Rants · Windows · Solved Problems
Enable remote management of Windows Server Core and Hyper-V Core

PowerShell commands that enable the firewall rules needed to manage Windows Server Core and Hyper-V Core remotely.

Windows · Reference
Forcing Cygwin to create sane permissions on Windows

How to stop Cygwin from creating incorrectly ordered Windows permissions by adding noacl to the /cygdrive mount options.

Linux · Windows · Solved Problems
Property 'BindToHostTpm' does not exist in class 'Msvm_SecuritySettingData'

How to disable Secure Boot on a Hyper-V Server guest with PowerShell when Hyper-V Manager shows the BindToHostTpm error on the Security tab.

Windows · Solved Problems
Using external Certificate Authority certificates in a restricted or closed environment

How to find the CRL and OCSP URLs of a public CA certificate and open the pinholes a closed network needs to verify it, on Linux and Windows.

Howto's · Windows
Outlook removes "extra line breaks" from plain text emails: How to stop it

How to stop Outlook from removing line breaks in plain text emails, in Outlook's options or by ending each line with three spaces.

Windows · Solved Problems
How to deal with error 0xC03F6506 when upgrading stubborn Windows 10 Home Edition machines to Pro using a VLK

How to upgrade Windows 10 Home to Pro with the generic upgrade key when activation fails with error 0xC03F6506.

Windows · Solved Problems
Shrinking a Windows 10 installation for small harddrives

How to save disk space on small Windows 10 devices by compressing the operating system files with compact.exe /CompactOS.

Howto's · Windows · Solved Problems
Drivers for the Multicom Talisa U230

A download of the WiFi driver and the other drivers for the Multicom Talisa U230 laptop that Windows Update does not provide.

Windows · Reference · Solved Problems
Avoid having Visual Studio put all its floating windows on top

How to stop Visual Studio's floating tool windows from staying on top of other applications on multi-screen setups.

Windows · Solved Problems

2017

Making Windows keep the system clock in UTC

How to make Windows keep the hardware clock in UTC with the RealTimeIsUniversal registry value, for virtual machines and dual boot.

Windows · Solved Problems
Finding the most expensive recent SQL queries on SQL Server

A SQL Server query on the dynamic management views that lists the most expensive recent queries by reads, writes or CPU time.

Windows · Reference
How to set the default location for new computers in Active Directory

How to change the default container for new computer accounts in Active Directory with redircmp.

Windows · Reference
Figuring out which session is blocking a query on Microsoft SQL Server (query suspended)

A SQL Server query that shows which session is blocking which, to find the cause of suspended queries and lock waits.

Howto's · Windows · Reference · Solved Problems
Cygwin for Windows XP - fast mirror

Where to get the last Cygwin release that works on Windows XP from a fast mirror, and the setup option needed to install from it.

Windows · Solved Problems
The Intel 82579V on Hyper-V Server 2016, installing unsupported network adapters

How to install the Intel 82579V network driver on Hyper-V Server 2016 by editing the driver .inf file and disabling driver signature checks.

Windows · Solved Problems
Installing Windows XP on the Dell Vostro 1700

How to install Windows XP on a Dell Vostro 1700, with an F6 floppy of SATA drivers and a collection of the XP drivers that work.

Windows · Reference
Windows Volume License Keys (VLK)

Windows KMS client setup keys for Windows and Windows Server editions, the Windows 10 Pro upgrade key, and the commands to activate with them.

Windows · Reference
Installing Windows XP on the Fujitsu Siemens Esprimo u9200 in 2017

How to install Windows XP on the Fujitsu Siemens Esprimo u9200 with slipstreamed SATA drivers, plus drivers, tweaks and tools.

Howto's · Windows
How to remove the "Favorites" button from Internet Explorer 8 on Windows XP

How to remove the Favorites button from the Internet Explorer 8 favorites bar on Windows XP with the NoCommandBar registry policy.

Windows · Solved Problems
The Windows XP PowerToys, archived here for your pleasure

An archive of the Microsoft PowerToys for Windows XP, with a short description of each tool.

Windows · Solved Problems

2016

Setting all SQL Server databases to "simple" recovery model and deleting all the transaction logs

A T-SQL script that sets every user database on SQL Server to the simple recovery model and shrinks its transaction log, also for odd database names.

Howto's · Windows
Debugging SQL Server Query Performance

How to measure SQL Server query time and IO, and how to clear the caches for a clean test.

Howto's · Windows · Software
Force SQL Server Database offline

How to force a SQL Server database offline when active sessions block it, and how to bring it back online.

Howto's · Windows
Automatic Windows Logon on Domain Member Machines

How to enable automatic Windows logon on a domain member machine by setting the WinLogon registry values.

Howto's · Windows · Solved Problems
Shrinking the MS SQL Server "tempdb" (when it won't shrink)

How to shrink the MS SQL Server tempdb database when it refuses to shrink, by freeing the caches first.

Howto's · Windows · Solved Problems
Fixing empty search results in the Windows 10 Settings (the shiny new Control Panel)

How to fix empty search results in the Windows 10 Settings app by toggling content indexing on its LocalState Indexed folder.

Howto's · Windows · Solved Problems
Export certificates marked as not exportable in the Windows certificate manager

How to export certificates and private keys marked as not exportable from the Windows certificate store with Mimikatz, and convert them for Wireshark.

Windows · Solved Problems · Software
Enabling Quick Launch in Windows 10

How to add the classic Quick Launch toolbar to the Windows 10 taskbar, so pinned programs stay in place.

Windows · Reference · Solved Problems
Find and kill long running MS SQL Server queries

SQL queries to list running MS SQL Server queries by elapsed time and to kill one or all long-running ones.

Windows · Reference · Solved Problems

2015

Error 0x80041002 from PowerShell after upgrade to Windows 10

How to fix error 0x80041002 from New-ScheduledTaskTrigger after a Windows 10 upgrade by rebuilding the WMI repository with a batch file.

Windows · Solved Problems
A few group policies I use on Windows 10

Group policy settings for Windows 10 that disable the lock screen and prevent the use of OneDrive.

Windows · Reference
Wiping an (Azure) SQL Server database, deleting all tables

A T-SQL script that drops all foreign keys, tables and views in a SQL Server or Azure SQL database.

Windows · Reference
Hardening IIS and scanning for SSL-related vulnerabilities - IISCrypto

IISCrypto, a tool that sets the registry entries to allow only secure cryptographic algorithms on IIS, with archived copies and a link to an SSL scanner.

Windows · Reference
Using MERGE to insert/update in SQL Server

How to insert or update a row in one statement with MERGE in SQL Server 2008.

Rants · Windows
MSSQL Mass Delete

How to delete large amounts of data from a SQL Server table in small chunks with DELETE TOP.

Howto's · Windows · Reference · Solved Problems
Installing Windows Live Essentials on Windows XP - Error: OnCatalogResult: 0x80190194

How to install Windows Live Essentials on Windows XP when the web installer fails with OnCatalogResult 0x80190194, using archived offline installers.

Windows · Solved Problems
Deleting duplicates in SQL Server before adding a Unique Index

How to delete only the duplicate rows in a SQL Server table with ROW_NUMBER() so that a unique index can be added.

Windows · Reference · Solved Problems
Taking a screenshot of an entire page with Firefox, saved as a .png

How to save a full-page screenshot as a PNG with the Firefox developer toolbar.

Linux · Windows · Solved Problems
Disable the startup page in Vistual Studio 2013 Community Edition (and probably all others)

How to disable the start page in Visual Studio 2013 Community Edition.

Windows · Solved Problems
Renaming an MSSQL instance (Invalid Urn filter on server level)

How to fix "Invalid Urn filter on server level" by renaming the SQL Server instance after a host rename.

Windows · Solved Problems
Weakening Windows Server 2012

Where to find the Windows Server 2012 settings for password policy, Ctrl+Alt+Del, Shutdown Event Tracker, IE Enhanced Security and remote desktop shadowing.

Windows · Solved Problems
Using a Windows 8 upgrade key for a clean install

How to activate a clean Windows 8 install with an upgrade key by resetting MediaBootInstall and running slmgr /rearm.

Windows · Solved Problems
MSSQL Mass Copy

SQL Server batch loops for copying large amounts of data between tables without locking them for a long time.

Windows · Reference

2014

Moving Windows' Offline File Cache away from C:\

How to move the Windows Offline Files cache (C:\Windows\CSC) to another drive with a directory junction.

Howto's · Windows
Handler “PageHandlerFactory-Integrated” has a bad module “ManagedPipelineHandler” in its module list

How to fix the IIS ManagedPipelineHandler bad module error by registering ASP.NET 4 with aspnet_regiis -i.

Windows · Reference · Solved Problems
Enabling read_committed_snapshot on an existing MSSQL database

The SQL statements that turn on snapshot isolation and read_committed_snapshot for an existing SQL Server database.

Windows · Reference · Solved Problems
Removing VMware Player or workstation when the Hyper-V role is active

How to uninstall VMware Player or Workstation when the Hyper-V role blocks the uninstaller, by editing bootstrap.lua.

Windows · Reference · Solved Problems
Samba servers show up slowly in Network Neighborhood when VMware is installed

How to make Samba servers show up quickly in Network Neighborhood when VMware network adapters are installed.

Windows · Solved Problems
Resetting an Aeon Labs Z-Stick S2

How to reset an Aeon Labs Z-Stick S2 Z-Wave adapter with the Danfoss ZWave PC Controller, with the manual, driver and firmware.

Windows · Solved Problems · Software
regedit access denied

How to edit protected registry keys that give Access Denied even to administrators, by running regedit as SYSTEM with psexec.

Windows · Solved Problems
Removing a WIFI-network in Windows 8

How to list and delete stored WiFi network profiles in Windows 8 with netsh.

Windows · Reference · Solved Problems

2013

Logging out of a samba file server

How to clear Windows' cached network credentials with net use after a samba password change gives "access denied".

Windows · Solved Problems
Creating persistent SSH tunnels in Windows using autossh

How to run autossh from Cygwin as a Windows service, to keep an SSH tunnel up with key authentication.

Howto's · Windows
Cygwin auto started sshd service as single user on Windows 8

Steps to run the Cygwin sshd service as a specific user without privilege separation on Windows 8, including the firewall rule.

Windows · Reference
Enable username and password in URL in Internet Explorer

How to re-enable usernames and passwords in URLs (http://user:pass@host/) in Internet Explorer through a FeatureControl registry key.

Windows · Solved Problems
Disable UAC in Windows 8

How to disable UAC in Windows 8 through secpol.msc or, on non-pro editions, the EnableLUA registry value.

Windows · Reference · Solved Problems

2012

XP Windows Update error 0x8024400A solution

How to fix Windows Update error 0x8024400A on Windows XP by installing Service Pack 3.

Windows · Reference · Solved Problems

2011

Tell your friends how to burn ISO files properly

A pointer to a guide on burning an ISO image to disc correctly with common Windows burning software.

Windows · Reference
Remote desktop does not support colour depth 24; falling back to 16

How to enable 24-bit colour for RDP connections to Windows XP through Group Policy, so rdesktop stops falling back to 16-bit.

Howto's · Windows · Solved Problems
How to Hide a User Account from the Welcome Screen

How to hide a user account from the Windows Welcome screen with the SpecialAccounts registry key.

Windows · Reference

2010

Putty keeps disconnecting

How to stop PuTTY SSH sessions from dropping on unstable connections by raising the TCP retransmission limits in the Windows registry.

Windows · Solved Problems
Windows XP activation doesn't pop up after repair or ghost

How to get into Windows XP when activation will not start after a repair or ghosting, and fix it with a hotfix and Internet Explorer 8.

Howto's · Windows · Solved Problems
Error -6003 during Creative X-fi driver install

How to fix InstallShield error -6003 during the Creative X-Fi driver install by removing a numbered RunTime folder.

Windows · Solved Problems

2009

Windows 7 autologin

How to open the user accounts dialog with control userpasswords2 to let Windows 7 log in automatically.

Windows · Reference
Fixing Windows Update errors

A batch file that re-registers the crypto DLLs and resets catroot2 and SoftwareDistribution to fix Windows Update errors.

Windows · Solved Problems
VMware Server and Windows Firewall

How to let VMware Server remote connections through Windows Firewall by allowing vmware-authd.exe instead of port 902/TCP.

Windows · Reference

2008

Intellisense issues in Visual C++ 2005

Basic troubleshooting steps for IntelliSense problems in Visual C++ 2005.

Windows · Reference