rosswd

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

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

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.

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)

Learning Relational Database Design and SQL

Learn SQL (interactive)

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

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

	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

	# raspberry pi locales

	#
	# dynamically set locales
	#

	# check current locale settings
	locale

	# reconfigure locale settings (option 1)

	# 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 [email protected]

	# set up passwordless access

	'''
	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]