Category Archives: computer tips

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! šŸ™‚ Top Search Terms:list all

Read more computer tips, Database tips, programming, Work

Turn off Facebook auto play videos [SOLVED]

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)

Read more computer tips

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

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

2 comments

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

Read more computer tips

HP 23xi review (long term review w/reliablity & warranty info)

Leave a comment

For the past two years we have been using a number of HP 23xi displays at home and the office. Overall these are some of my favorite monitors. Here are the pros: IPS Reasonable price (~$130 USD when on sale) Energy efficient External power supply (this is nice b/c if the power supply fails, you just replace it… not the entire monitor) Power supplies are readily available (I had two spare laptop/HTPC power supplies that worked fine) Nice looking and

Read more computer tips, Computers, Gadgets and Tech
« Older Entries Recent Entries »