J.D. H. | J.D. Hodges

Author Archives: J.D. H.

Fixed skewed pages in ScanSnap

Monday, 2014.11.17 J.D. H. Leave a comment

I adore my Fujitsu ScanSnap ix500 scanner. It lets me scan 70+ pages with ease (simplex or duplex) all the while OCRing every shred of text and therefore saving me oodles of time. Fujitsu ScanSnap iX500 Scanner for PC and Machttp://www.amazon.com/gp/product/B00ATZ9QMOAwesome scanner which I really love. Easy to install and works seamlessly on my Windows 8 laptop. I use this all the time to scan and archive all the papers in my house and the… Read more However, today I

Read more computer tips, Software Tips, Work

AT&T double data rate table (cost per GB)

Thursday, 2014.11.06 J.D. H. Leave a comment

AT&T data plan table when they were doing double data: GB per month Dollars per month Dollars per GB 10 $115 $11.50 30 $145 $4.83 40 $165 $4.13 60 $240 $4.00 80 $315 $3.94 100 $390 $3.90 I chose the 40GB plan and have been very happy with the speeds. 🙂 However, their customer service has been terribly disappointing. 🙁 Top Search Terms:at (1)att double data review (1)att wireless double data (1)double data rate at and t wireless (1)

Order SQL query manually when numeric string representation is out of order

Sunday, 2014.11.02 J.D. H. Leave a comment

In some instances, doing a straight ORDER BY ASC (OR DESC) does not work as one might want: 0-50 101-200 201-300 301-400 401-500 501-600 51-100 601+ That is not how humans do it 😉 A way to get around this, is to add a new column and put in an ordering value, for instance: 1. 0-50 2. 51-100 3. 101-200 4. 201-300 5. 301-400 6. 401-500 7. 501-600 8. 601+ Now that is much better 🙂 Here is a real

Read more programming, Software Tips, Work

We’re sorry, but you are attempting this transaction during a restricted time period set by your wireless account

Sunday, 2014.11.02 J.D. H. 2 comments

If you get an error message like this: We’re sorry, but you are attempting this transaction during a restricted time period set by your wireless account owner. http://redirect.ac.sl.attcompute.com/cgi-bin/redirect.cgi Then my suggestion is to restart your phone or reboot your wifi hotspot. That will likely resolve the issue for you 🙂 Top Search Terms:http://redirect.ac.sl.attcompute.com/cgi-bin/redirect.cgi (6)redirect.ac.sl.attcompute.com (3)http://redirect.ac.sl.attcompute.com/cgi-bin/redirect.cgi?msg=2 (2)we're sorry, but your message could not be delivered because you are in a restricted time period set by your wireless account owner. (2)redirect.ac.sl.attcompute.com/ (2)data

Disable Skype voicemail [SOLVED]

Tuesday, 2014.10.21 J.D. H. Leave a comment

I use a Google Voice number in conjunction with Skype. It allows me to receive calls at home via satellite internet. However, when I miss a call I want Google to take the voicemail not Skype. Thankfully, the steps for disabling Skype voicemail are fairly easy. First, go to the following URL: https://secure.skype.com/account?page=voicemail Second, click to uncheck the voicemail setting: That is it, Skype voicemail is now disabled! 🙂 *PS you may have to disable this annual, as I believe certain

Read more computer tips, Off the Grid, Software Tips, Work

SQL Server: list all user defined functions in a database

Tuesday, 2014.10.21 J.D. H. Leave a comment

Recently I inherited a database project where many of the functions were not listed nor documented. Thankfully, with the help of the always useful stackoverflow, I was able to find the following snippet for displaying all user functions: select name, definition, type_desc FROM sys.sql_modules m INNER JOIN sys.objects o ON m.object_id=o.object_id where type_desc like ‘%function%’ via sql server – SQL list of all the user defined functions in a database – Stack Overflow. Very cool! 🙂 Top Search Terms:list all

Read more computer tips, Database tips, programming, Work

Create PayPal subscription buttons [SOLVED]

Tuesday, 2014.10.21 J.D. H. Leave a comment

Since PayPal came up with their new ‘streamlined’ interface, it seems to have made some core features very difficult to find 🙁 A prime instance is the subscription buttons and links. These tools are very useful for webmasters and anyone offering recurring services online. Here is how to find the subscription tools: #1 Login to PayPal: https://www.paypal.com/ #2 Go to the ‘Buttons for subscriptions and recurring billing‘ page #3 Click ‘Create your button now‘ (you must be logged in for

Turn off Facebook auto play videos [SOLVED]

Sunday, 2014.10.19 J.D. H. Leave a comment

It is super annoying to me when Facebook autoplays videos, plus it eats through my limited bandwidth. Thankfully, the auto-play ‘feature’ can be turned off! Here’s how to easily turn it off: #1 Go to https://www.facebook.com/settings?tab=videos #2 Turn it OFF Enjoy! :-0 Top Search Terms:facebook video won't play (1)how do you turn videos off in facebook (1)how to turn videos off on facebook (1)