Category Archives: computer tips

Fixed skewed pages in ScanSnap

Make sure to select 'Deskew by txt on document'

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

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

Error message displayed by AT&T wifi hostpot tethering

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

Disable Skype voicemail [SOLVED]

Click the slider to disable voicemail

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 Skype

SQL Server: list all user defined functions in a database

List of all user functions!

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!

How to set the time zone & time on Synology NAS DSM

Screenshot showing how to set the timezone in Synology's DSM NAS software

Recently I needed to setup a scheduled shutdown task for my Synology DS 1813+ NAS. After I created the task, I wanted to check the time to make sure it would be triggered at the correct time. Turns out that my timezone had never been set correctly, so here is how I fixed it: Login to NAS via web brower -> Control Panel -> Regional Options -> Time Zome Just FYI here is the awesome NAS in question (though DSM

Intel Centrino 6235 or 7260 Bluetooth not detected by Windows [SOLVED]

Intel wifi card in Lenovo X220, before connecting blue antenna

I came across an interesting tip today: [...] Samsung RC530 and a 7260.HMWWB. Bluetooth can’t be activated on some notebooks, so you need to activate it manually with a hardware “hack”. Just get some Scotch Tape / Sellotape (in german “Tesafilm”) and stick it on pin #51 (picture). Put the card back in the PCIe slot and have fun . [...] this workaround works also for the 6235 and other Intel Wifi/Bluetooth cards.. via Intel Communities. Well worth checking out

Select top 2 rows from records, grouped/partitioned by Unique ID

Shows the records with their new ROW_NUMBERs added and paritioned

The Problem: A client needed a query that selected the two most recent tour dates for each user ID. This is an easy task for a single user ID because specifying the user ID and an ORDER BY tour_date DESC with a LIMIT 2 clause would get the dates needed. However, when there are a lot of users it gets harder. For a single date, the MAX function works great but in our instance it will not work because we

Page 1 of 4112345...102030...Last »