Category Archives: Work

Beneficiary Deeds in Missouri

Leave a comment

A beneficiary deed allows for property to transfer on death (TOD) without going through probate. The beneficiary deed only goes  into effect upon death of the owner, therefore it does not actually transfer property until the owner’s death and therefore it does notpreclude transfer before death. In other words, if an owner executes a beneficiary deed and then decides to sell the property, that it is not a problem. The Missouri Bar provides an overview of Estate Planning methods and

Read more legal, Work

MySQL: Count the total occupancy rate for a time period (month)

2 comments

Recently I encountered a somewhat interesting MySQL/PHP task: determine occupancy for a reservation system. This entailed determining how many reservation days fall within a particular month. It was not possible to simply determine each reservation length (datediff from/to) and sum them because some reservations started before the month in question and other reservations lasted until the month was over. Therefore, one solution is to get the reservation lengths then compare the start and end of the reservation to the start

Read more programming, Software Tips, Work

Synology DS1813+ Review

Leave a comment

My DS1813+ arrived yesterday via FedEx and I will soon be putting it through its paces. This article will be updated periodically. Until the next update, here are some preliminary links: DS1813+ Product Info Synology Network Attached Storage – DS1813+ Productshttp://www.synology.com/products/product.php?product_name=DS1813%2B&lang=usWith its superior performance, scalability, resilience, and comprehensive features, Synology® DS1813+ is the ideal storage solution for your growing SMB. The DS1813+ can help to simplify data… Synology DS1813+ & DS1513+ DiskStations Reviewed – Features, Performance, Conclusion – SmallNetBuilderhttp://www.smallnetbuilder.com/nas/nas-reviews/32157-synology-ds1813-diskstation-reviewed?showall=&start=1DSM 4.2

Read more computer tips, Work

ZyXEL 35 default username and password

Leave a comment

The ZyXEL 35’s default LAN IP address for accessing the web based ZyWALL interface is: 192.168.1.1 and the default password is: 1234 (no username is necessary) Make sure you access it from the LAN side and not the WAN side Ethernet port 🙂 NOTE: to reset these values to default, power on the XyXEL 35 and press and hold the physical RESET button for 30 seconds. At that time you will see all four LAN ports flash ORANGE and you

Read more computer tips, tech tips, Work

Sony RX100 Mk II extended user review

Leave a comment

Tested so far: NFC pairing with Google Nexus 7 FHD Wifi file transfer Wifi control To still be tested: Panorama iOS integration RAW quality Much more… General first impressions: Excellent speed and good handling. Very good image quality. Wifi features are a bit gimmicky but could be useful in certain situations. Specs from Sony: Product Specifications Recording Media Type : Memory Stick PRO Duo™/Pro-HG Duo™ media; SD, SDHC and SDXC memory card Color Space : sRGB standard (with sYCC gamut)

Read more camera tips, Cameras, Work

Evaluating a RAM disk as a MySQL data store

Leave a comment
DDR3 Memory

I have a situation with a relatively small set of MySQL data (5GB) and a decently large set of available ECC DDR2 memory (32GB). Therefore, I am evaluating storing the entire MySQL data directory on a ramdisk. Along those lines, here are some initial resources: 12 RAM Disk Software Benchmarked for Fastest Read and Write Speed • Raymond.CChttp://www.raymond.cc/blog/12-ram-disk-software-benchmarked-for-fastest-read-and-write-speed/Memory or RAM is much faster speed than a traditional hard drive. If you require to run a software that is database intensive,

Read more computer tips, Work

Dell PowerEdge 1950 & 2950 CMOS/RAID battery

Leave a comment

The Dell PowerEdge 1950 3rd generation server uses a standard CR2032 battery for CMOS/BIOS purposes. If your server is showing an orange warning on the front panel about low battery, you can buy a replacement battery here for less than $5 USD: 3 Volts, 2032, 2 batteries (Lithium Button Cell) CR2032http://www.amazon.com/gp/product/B0002DSVS8/This pair of three-volt lithium coin batteries is perfect for servers. 20mm diameter and 3.2mm height. Likewise, if the RAID controller’s battery is low you can find replacements starting at

Read more computer tips, Work

Dell PowerEdge 1950 III Drivers and Firmware Updates (2013)

Leave a comment

I recently set up two new Dell PowerEdge 1950 III servers. One for Weblogs.us (free blog hosting) and one for Branson’s Nantucket (a lakefront resort in Branson). Dell makes very nice servers but their support pages can be a bit confusing. Therefore, here are the latest updates/drivers for the PowerEdge 1950 III, as of July 2013: Latest Dell PERC 6/i Integrated Update, v.6.3.1-0003, A14http://www.dell.com/support/drivers/us/en/04/driverdetails?driverid=W83M2Fixes: 1. Fixes an issue where the Perc battery does not always charge up properly, causing Virtual Disks

Read more computer tips, Weblogs.us, Work