Skip to content

Instantly share code, notes, and snippets.

Andrew mcandre

View GitHub Profile
@mcandre
mcandre / windows-tablet-unsplit-screen.md
Created Jul 10, 2020
Windows Tablet unsplit screen
View windows-tablet-unsplit-screen.md
  1. Swipe downward from the very top of the screen.
  2. Drag the app from a vertical split into either a left or right horizontal split.
  3. Swipe down from the very top of the screen.
  4. Drag the app to the middle, forming a regular, full screen split.

Annoying, but it works.

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

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 / captive-portal-free-browsing.md
Created Apr 16, 2020
Captive Portal Free Browsing
View captive-portal-free-browsing.md

Captive Portal Free Browsing

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

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 Apr 9, 2020
PostgreSQL Backup and Restore
View postgresql-backup-and-restore.md

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 Apr 3, 2020
How to Fix Hardware Boot Problems
View how-to-fix-hardware-boot-problems.md

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 Jun 28, 2020
How to Make a Windows Boot USB Drive
View how-to-make-a-windows-boot-usb-drive.md

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 Mar 19, 2020
How to Duplicate Preview.app Pages
View how-to-duplicate-preview.app-pages.md
  1. Click on the desired page.
  2. Press and hold the Option key.
  3. Drop duplicated page between other pages.
You can’t perform that action at this time.