rosswd

MSI MAG274QRF-QD Color Settings

Firmware version: FW.019
It should be noted, at time of this gist, MSI have moved to naming their firmware by date. FW.020 bricked some monitors and no firmware was available for a time.

Game Mode: User
Night Vision: Off
Response Time: Fast
MPRT: Off
Refresh Rate: Off

rosswd

How to run Lego Star Wars: The Complete Saga in Windowed Borderless mode

1. Download DxWnd and unpack the folder. 7zip can unpack .rar files
2. Open dxwnd.exe
3. Go to Edit > Add and browse to the game executable
4. Select Run in Window and Fullscreen to run the game in borderless windowed
5. Under Position make the following changes:
   • X: 0, Y: 0, W: 1920, H: 1080 (for HD Resolution)
   • Select Desktop
6. On the Video tab, for Screen Resolution ensure 'Native' is selected
7. Press OK to exit

rosswd

How to stop Steam Big Picture opening when you press the guide button on your XBox Controller

Scenario: You have an XBOX One Controller, or similar, and to turn off the controller you press and hold the guide button. Unfortunately, even though you have turned off guide button focuses steam in Steam's Controller Settings, the button press still opens Big Picture Mode.

Guide

• With your controller on, open Controller Settings: Steam > Settings > Controller > General Controller Settings
• Using the controller, highlight Xbox One Controller or similar, navigate to Define Layout and press A on the controller

The next step involves remapping the Guide Button to another button and then reassigning that button back to the original. This will leave the guide button unassigned so that the controller can be turned off without Steam getting involved.

rosswd

# raspberry pi locales

#
# dynamically set locales
#

# check current locale settings
locale

# reconfigure locale settings (option 1)

rosswd

# ssh on raspberry pi

# in these examples I use 192.168.1.10 as an example ip address for the raspberry pi

# enable ssh either using raspi-config or by placing a file named 'ssh' in the boot partition

# connect from a client
ssh pi@192.168.1.10

# set up passwordless access

rosswd

Gmail Search

is:unread
is:starred
from:apple subject:invoice
from:youtube is:unread
has:youtube
has:attachment
subject:order details
subject:(order statement refund)

rosswd

Learning Relational Database Design and SQL

Learn SQL (interactive)

• SQLBolt
• SQLZoo
• GalaXQL
• Mode SQL Tutorial
• Datacamp: Intro to SQL for Data Science
• Codecademy Learn SQL
• Select Star SQL

rosswd

Drawing Tablet Software

Software for drawing using graphics tablets like wacom or using a tablet like an iPad.

Software List

Title	Platforms	Pricing
Medibang Paint / Paint Pro	Windows, Mac OS, iOS, Android	Adware, no paid version
Paint Tool SAI	Windows	$51
ArtRage	Windows, Mac OS, Android, iOS	$79 + tax

rosswd

'''
Uses the pandas and wikipedia libraries to create a json file from a wikipedia table

table: https://en.wikipedia.org/wiki/List_of_first-person_shooters
'''
import pandas as pd
import wikipedia as wp

html = wp.page('List_of_first-person_shooters').html().encode("UTF-8")
df = pd.read_html(html)[1]

rosswd

Installing a new ssd in MacOS High Sierra

This guide is for upgrading to a new SSD, restoring from Time Machine and keeping your Recovery Partition.

The first time I tried to install a new SSD I just installed the SSD and didn't format anything. I figured the format would be chosen by MacOS but it wasn't and the recovery partition didn't copy over to the new disk. If you don't have a Recovery Partition you can't use Disk Encryption or Find My Mac.

Note: you may have to disable/remove disk encryption but my Disk wasn't encrypted so I don't have steps for that

Preparing your Computer

• Do a Time Machine Backup and make sure you're not excluding anything you need
• Shut down your Mac and go through the process of removing the old drive