Category Archives: computer tips

Fixed skewed pages in ScanSnap

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

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

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 🙂

Read more computer tips, Phone tips

Disable Skype voicemail [SOLVED]

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

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! 🙂

Read more computer tips, Database tips, programming, Work

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

Leave a comment

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

Read more computer tips

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

Leave a comment

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

Read more computer tips, Software Tips, tech tips

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

Leave a comment

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

Read more computer tips, programming, Software Tips, Work