tools Archives - Michael Bianco

Building a High-Performance Local Server

It’s been a really long time since I built a custom PC. At least 15 years, maybe closer to 20. Inspired by DDH, the crazy high cost of renting high-performance compute in the cloud1 , and my success with running both an Orange Pi and Raspberry Pi I decided to go ahead and do a custom build to create a high-powered home server box that I could use to play with some higher-compute workloads and get to play with desktop ubuntu at the same time (I’ve only ever interacted with linux via the CLI). Additionally, I wanted to play with self-hosting a wider array of production-related supporting applications: Sentry Windmill Prometheus and other observability tools As a bonus, I’m hoping this will heat my tiny house/office structure in the winter…

My Ergonomic Desk Setup

Years ago, I had wrist issues. After a certain point, they would just constantly hurt. Since then I’ve always tried to iterate on my desk setup each year. I sit at my computer typing a lot; investing in the tools I use every day always made a bunch of sense. I’ve spent time & money researching, purchasing, testing, etc various tools to improve my desk setup to eliminate pain. Notes from an Ergonomic Consultation One of the neat things my BigTech job provided was a session with an ergonomic consultant. Here are some notes: The screen should be at arm’s length from your body. Most likely, you should pull your screen closer to your face. The knees should be at or below the hip level. This means your desk and chair should sit lower…

Get a Dedicated, Free, High Quality Conference Line

Premium services often end up being cheaper. This doesn’t meant that all premium services are expensive. Systems are being disrupted at such a rapid pace you can often find incredible services – like a free virtual fax machine – completely free. One of these services is UberConference. Even if you run a one man shop (like I do!) you should signup for UberConference and use it exclusively for calls. Here’s why: Hangouts is not reliable for phone calls. They have a great dial out feature, but I’ve been on a couple calls where the call connection kept dropping out. It was embarrassing and made me lool sloppy. Calling someone’s cell, or having them call you, often creates a coordination problem…

Convert MS SQL Database to CSV or MySQL

This is more of a thorny issue that you would at first expect – Microsoft does not provide an easy way out of their database if you are on a different platform. The open source (or paid!) tools available for interacting with Microsoft SQL databases on OS X are very limited. There are not any native GUIs available (to my knowledge), I’ve found that getting TDS up and running is a pain, and it seems impossible to import a .bak or ms sql insert dump. Additionally, I’ve had weird encoding + CSV formatting issues when given a CSV exported from a dump given to me. I’ve discovered a workaround to the issue that has worked reliable for very large data sets (30,000+ rows). Oracle’s SQL Developer application can connect to a ms sql database…

JPEG + PNG Color Management Strategies for the Web

The first step in the design process of any website is to mockup the design in Photoshop. One of the most frustrating parts of the design process can be converting your mockup into image slices whose colors mix well with native CSS styles. Mark Edwards, over at Bjango, has a great writeup on color profile management and UI design. The basic tenants are: don’t color manage, use native monitor color profile, use RGB, and do not attach color profiles to JPG or PNG images. However, in my senario, I often work with graphics that have been designed by people who work in print and don’t understand web image generation in the slightest. Often I’ll receive unoptimized PNGs, JPGs in CMYK, images with color profiles, etc…

Tag: tools