Chris Rickard chrisrickard

Never touch your local /etc/hosts file in OS X again

To setup your computer to work with *.test domains, e.g. project.test, awesome.test and so on, without having to add to your hosts file each time.

Requirements

Homebrew
Mountain Lion -> High Sierra

Install

Set up a VPN Server (PPTP) on AWS

Create a EC2 instance using Ubuntu 14.04.
In Secure Group Inbound Rules, add a SSH Rule(TCP, Port 22, 0.0.0.0/0) and a Custom TCP Rule(TCP, Port 1723, 0.0.0.0/0).
Optional: Associate a Elastic IP with the instance.
SSH into the instance.
sudo apt-get install pptpd.
sudo vim /etc/pptpd.conf. Uncomment localip 192.168.0.1 and remoteip 192.168.0.234-238,192.168.0.245.
sudo vim /etc/ppp/pptpd-options. Uncomment ms-dns and ms-wins. Change the IP to Google's DNS like this:

Some of the Redis best practices content has moved

This content from this markdown file has moved a new, happier home where it can serve more people. Please check it out : https://docs.microsoft.com/azure/azure-cache-for-redis/cache-best-practices.

NOTE: Client specific guidance listed below is still valid and should still be considered. I will update this document once all content has been moved.

Howto Install clamav on OSX with brew

Note: on legacy intel system the path may be /usr/local/etc/clamav instead of /opt/homebrew/etc/clamav/

$ brew install clamav
$ cd /opt/homebrew/etc/clamav/
$ cp freshclam.conf.sample freshclam.conf

The default formula use by AWS RDS to calculate the max_connections parameter is: LEAST({DBInstanceClassMemory/9531392},5000)

But It's hard to find the exact value of DBInstanceClassMemory.

So, here are the values I got when I ran the SQL commmand: show max_connections; in some RDS instances:

Instance type	RAM (GB)	max_connections
db.t2.small	2	198
db.t2.medium	4	413

To support my open-source work, consider adding me on Patreon.

macOS 10.14 Mojave Mostly-Automated Setup

An easy to refer to document for regularly setting up macOS 10.14 Mojave.

Controversy

The topic of recipe-based frequent fresh reinstalls of macOS is a controversial issue. Some people are against reinstalling macOS, citing that they have never had an issue with Apple provided upgrade installs.

	Hi David,
	I came across your profile online and wanted to reach out about Development
	Opportunities here at Groupon. The company is growing, and we're always
	looking for folks with solid skills that can make positive contribution to
	our continued success. Any chance you'd be open to a quick conversation
	about opportunities, or for any possible networking potential? If so, let me
	know when you're free and we can set up a time to chat. Also, if you are
	interested, it would be great if you could forward a current resume over
	that I can take a look at. I look forward to hearing back from you! Please
	let me know if you have any questions.

	# https://www.nginx.com/blog/tuning-nginx/
	worker_connections 1024;

	# Limit the number of connections NGINX allows, for example from a single client
	# IP address. Setting them can help prevent individual clients from opening too
	# many connections and consuming too many resources.
	server {
	# When several limit_conn directives are specified, any configured limit will apply.
	limit_conn perip 10;
	limit_conn perserver 100;

	#!/usr/bin/expect -f
	# This installs MSSQL server and drivers on a vagrant ubuntu machine
	#
	# To use you need to install expect: `sudo apt-get install -y expect`
	# and then run the script with the password you want: install-mssql.sh myPass123
	# Then log in to the sql server with username `sa`and the password `myPass123`

	set password [lindex $argv 0]

	#Add MSSQL to package manger

	const hoverTime = 400
	const fetchers = {}
	const doc = document.implementation.createHTMLDocument('prefetch')

	function fetchPage (url, success) {
	const xhr = new XMLHttpRequest()
	xhr.open('GET', url)
	xhr.setRequestHeader('VND.PREFETCH', 'true')
	xhr.setRequestHeader('Accept', 'text/html')
	xhr.onreadystatechange = () => {