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 Mac 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. 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: 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 »