Category Archives: Misc Links

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)

SD cards for the Yoga 2 Pro that don’t stick out as much

In general, the Yoga 2 Pro is an excellent upgrade over the original Yoga 13. One of the few drawbacks of the Pro 2 is that Lenovo made it so normal SD cards stick out (rather than sitting flush like on the original Yoga). Thankfully, there are some shorter SD cards that meant to at least partially resolve this issue. You can find some more info at the links below:   PNY StorEDGE 128GB Flash Memory Expansion Module (P-MEMEXP128U1-EF): Computers &