Skip to content

Instantly share code, notes, and snippets.

View mcandre's full-sized avatar

Andrew mcandre

  • Milwaukee, WI
View GitHub Profile
@mcandre
mcandre / launch-valorant.md
Created June 16, 2020 16:45
Launch Valorant (from CLI, Steam, GOG, etc.)
"C:\Riot Games\Riot Client\RiotClientServices.exe" --launch-product=valorant --launch-patchline=live
@mcandre
mcandre / windows-disable-expose-on-tile.md
Created June 5, 2020 00:37
Windows Disable Expose on Tile

By default, Windows since v7 does an annoying Expose-like action every time an application window is tiled/snapped. Fortunately, this can be disabled in recent versions as follows:

  1. Select Start -> Multitasking settings.
  2. Uncheck When I snap a window, show what I can snap next to it.
@mcandre
mcandre / cs-go-launch-options-mac.txt
Created May 28, 2020 01:08
CS:GO Launch Options macOS
-fullscreen
@mcandre
mcandre / captive-portal-free-browsing.md
Created April 16, 2020 01:53
Captive Portal Free Browsing

Captive Portal Free Browsing

  1. Set primary DNS server to 45.55.142.122.
@mcandre
mcandre / microsoft-windows-persist-window-dimensions.md
Created April 15, 2020 13:59
Microsoft Windows Persist Window Dimensions

Microsoft Windows Persist Window Dimensions

  1. Hold Control while selecting the Close button.
  2. Relaunch the application.
@mcandre
mcandre / postgresql-backup-and-restore.md
Last active October 6, 2022 22:24
PostgreSQL Backup and Restore

POSTGRESQL BACKUP AND RESTORE

$ pg_dumpall --clean -U <user> -f backup.sql
$ psql -U <user> -f backup.sql

Warnings

  • A PostgreSQL user with administrative privileges is required.
@mcandre
mcandre / how-to-fix-hardware-boot-problems.md
Last active April 3, 2020 22:10
How to Fix Hardware Boot Problems

The Golden Rule of Computing

Regularly test your backups. Such as once a month (common data) or once a week (critical data). Data loss occurs in basically two kinds of situations:

  • No backups
  • Bad backups

If you practice restoring from backups every so often, then you are much more likely to be resilient in the case of computer problems.

If your computer processes depend on specific hardware or software setups, then document these requirements along with the data backups. That way, you can immediately begin provisioning the necessary components in the event of an outage. A little notetaking now saves a lot of pain later.

@mcandre
mcandre / how-to-make-a-windows-boot-usb-drive.md
Last active November 9, 2022 01:19
How to Make a Windows Boot USB Drive

How to Make a Windows Boot USB Drive

  1. Obtain a reliable copy of a Windows ISO. When in doubt, reference well known cryptographic checksums when validating such critical files.

  2. Format a USB drive for a Windows NTFS partition, such as with Tuxera. For modern hardware, opt for GPT-style instead of MBR.

  3. Mount the Windows ISO as a virtual disc.

  4. Copy all files from the Windows virtual disc onto the USB partition.

@mcandre
mcandre / how-to-duplicate-preview.app-pages.md
Created March 19, 2020 19:44
How to Duplicate Preview.app Pages
  1. Click on the desired page.
  2. Press and hold the Option key.
  3. Drop duplicated page between other pages.
@mcandre
mcandre / arturia-keystep-hold-midi-samples.md
Created February 2, 2020 19:57
Arturia KeyStep Hold MIDI Samples
  1. In MIDI Control Center, set the KeyStep's "Hold Switch Function" to "Both".
  2. In either Sequencer or Arpeggiator mode, engage the Hold button.
  3. Play notes.