Category Archives: Misc Links

Construction update, bathtub update

Our house continues to take shape 🙂 After getting the roof on a week ago, not much has happened since. However, having everything dry and protected is VERY nice! We have had some snow and heavy frosts as well. Today we picked up Samantha’s 68″ cast iron tub from the freight dock in Springfield. The tub looks awesome and the crate barely fits in our Chevy Avalanche! It should fit perfectly in the master bath and we are running some extra

Format SQL code

I have been writing copious quantities of SQL lately. Some of the queries are getting really long. When I am working with Navicat it has a nice ‘SQL beautify’ feature that takes messy SQL and makes it nice and tidy. 🙂 While that features is great when using Navicat for SQL editing, sometimes I need to workdirectly with SQL Server 2008 there is no comparable feature built into Microsoft’s SQL pane. 🙁 Thankfully, with a quick copy/paste there is an online tool

GoDaddy changes manual renewal to auto-renewal. Lame.

GoDaddy: “Unless you have specifically selected the manual renewal option, your purchase includes enrollment in our automatic renewal service” This domain was set to manual renewal and I did not even notice an option during the checkout process to “keep” it that way, instead GoDaddy automatically set it to automatic renewal 🙁 I am not a fan of that. On renewal why not have leave it at the domain’s previous renewal designation?

SMART results from unraid system, one failing drive, Aug 2014

=== START OF READ SMART DATA SECTION === SMART overall-health self-assessment test result: PASSED General SMART Values: Offline data collection status: (0x82) Offline data collection activity was completed without error. Auto Offline Data Collection: Enabled. Self-test execution status: ( 0) The previous self-test routine completed without error or no self-test has ever been run. Total time to complete Offline data collection: (36360) seconds. Offline data collection capabilities: (0x7b) SMART execute Offline immediate. Auto Offline data collection on/off support. Suspend Offline

Pixel density links

I am very fond of calculating pixel density 🙂 As such, here are some links to PPI resources: A nice (simple) pixel density calculator: http://pixeldensitycalculator.com/ Is this retina?! http://isthisretina.com/ Another simple and attractive interface: http://dpi.lv/ Old school DPI Calculator: https://www.sven.de/dpi/ Paper Pixel Ruler http://pediddle.net/dpi-ruler.html Examples of sites that Google pulls resolution phone summary/data from: http://www.phonearena.com/phones/vivo-Xplay-3S_id8248 Obligatory pixel density lists: http://pixensity.com/list/laptop/ http://pixensity.com/list/phone/

SQL Server database and table listing

I generally work with MySQL, not MS SQL Server. So when I needed some basic automated info about a SQL Server’s database/table layout I was thankful for the following two pages: Get list of databases from Sql Server – Stack Overflowhttp://stackoverflow.com/questions/147659/get-list-of-databases-from-sql-serverHow can I get the list of available databases on a SQL server instance? I’m planning to make a list of them in a combo box in vb.net. Get a list of all database on a SQL Server: SELECT name

New cool app: f.lux (auto-adjust your monitor to be easy on your eyes)

Screenshot of the f.lux settings screen

New cool app: f.lux automatically warms up your computer’s screen colors at sunset and returns them to normal at sunrise. You can change colors, location, and other settings from the f.lux menu. The f.lux menu is always located to the left of your system clock. via Thank you for installing f.lux. f.lux (auto-adjust your monitor to be easy on your eyes)