Category Archives: tech tips

Hearing aid apps for Android

Tonight I encountered an unexpected question: my dad asked me if I had any experience with hearing aid apps for phones. I had to tell him that I didn’t even know such things existed! After a bit of thought and research it became quite obvious that such apps would be quite useful. Unfortunately, most Android app suffer from a plethora of issues that prevent them from actually being very useful for the hearing impaired 🙁 However, there are a few

Make Amazon MP3 stores downloads on SD card

I have been investigating the best way to have Amazon’s Android MP3 player store music downloads on a MicroSD card (instead of internal storage). So far reports are somewhat conflicting… I hope to have some better, and definitive, news to report soon! Amazon MP3 won’t save music files to SD Card the HTC Incredible was first launched, it did not include the Amazon MP3 app. However, I was able to find it on the web and install it. At that

atikmpag.sys BSOD ATI/AMD Video Card (ATI M6000 on Dell M6700)

atikmpag.sys BSOD Problem signature: Problem Event Name: BlueScreen OS Version: 6.1.7601. Locale ID: 1033 Additional information about the problem: BCCode: 116 BCP1: FFFFFA80129C14E0 BCP2: FFFFF8800980ACE0 BCP3: 0000000000000000 BCP4: 000000000000000D OS Version: 6_1_7601 Service Pack: 1_0 Product: 256_1 Files that help describe the problem: C:\Windows\Minidump\120213-9266-01.dmp C:\Users\User\AppData\Local\Temp\WER-15194-0.sysdata.xml Read our privacy statement online: If the online privacy statement is not available, please read our privacy statement offline: C:\Windows\system32\en-US\erofflps.txt

Block eBay buyers in countries you don’t ship to, or with 0 feedback

eBay recently streamlined their selling process but they sacrificed  some important features. Specifically, listing items is accomplished with a simpler interface than before and the buyer requirements seems to be missing in action on the new listing form. This is a real bummer as a listing can be ruined when a bum buyer beats out legitimate users 🙁 Thankfully, you can regain your eBay buyer requirements by adjusting your eBay preferences. This means you can set some important requirements like: Block buyers

Reverse order of individual items in a delimited string

Topic: Reversing the order of individual items in a string. Specifics: I had a date contained in a GET query string that was formatted as follows: 01/27/2013 and I needed it reversed to 2013/01/27 Here is a simple method to do the reversing in PHP: $toDate = htmlentities($_GET[‘to’]); $toDateNew = implode(“/”,(array_reverse(explode(“/”,$toDate)))); Explanation of code: First you explode the $toDate variable, then reverse the resulting array, finally you implode that array back into a string. Of course there are other date

Set your own date format in MySQL

Use DATE_FORMAT in MySQL to create your date strings formatted however you like: SELECT CONCAT(YEAR(res_hotel_booking_bookings.created),’-‘,DATE_FORMAT(res_hotel_booking_bookings.created,’%m’) ,’-‘,DATE_FORMAT(res_hotel_booking_bookings.created,’%d’)) AS creationDate, Count( As reservationsMade FROM res_hotel_booking_bookings WHERE res_hotel_booking_bookings.created >= ‘2013-10-15 00:00:00’ AND res_hotel_booking_bookings.created <= ‘2013-10-17 24:00:00’ GROUP BY YEAR(res_hotel_booking_bookings.created), MONTH(res_hotel_booking_bookings.created), DAY(res_hotel_booking_bookings.created) ORDER BY creationDate DESC There are more concise ways to do this, but this was adapted from an earlier method that used CONCAT so I stuck with that… 🙂

Link aggregation / NIC teaming [Windows 7]

Some tips for link aggregation/NIC teaming in Windows 7 using Intel NICs and drivers: Intel NIC’s 802.3ad Link Aggregation in Windows 7? – [H]ard|Forum anyone else is trying to do this, I figured it out. Follow these directions for Intel NIC’s. The feature is not included in Windows 7, so the NIC drivers have to support it. You have to be logged… Network Connectivity — How do I use Teaming with Advanced Networking Services (ANS)? teaming with Intel® Advanced Network

NAS that supports SSDs with TRIM? [SOLVED]

Q. I am looking for a NAS that will let me use SSDs and supports TRIM. That is very important to me because I want the SSDs to last a long time. I like Intel or Samsung drives if possible and I only need 100GB to 200GB or so. FYI I am looking for a two bay RAID1 mirrored solution. Thank you! -Sergio Kan A. Hi Sergio, I think you are in luck 🙂 Synology is a well respected NAS brand