Category Archives: computer tips

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

Disable Android lock screen, ‘None’ option missing?! [SOLVED]

I had a lock screen that just would not be disabled on my LG G.Pad 8.3 tablet Turns out it was because multiple users were enabled on my tablet. Deleting the extra users and just going back to my primary user allowed me to set the Lock Screen to ‘None’. Woot! More info on lock screens and things that can cause them to go awry: How to Disable the Lock Screen in Android | Phone Tipshttp://blog.laptopmag.com/how-to-disable-the-lock-screen-in-androidVirtually every new Android device

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