Category Archives: Software Tips

Disable Skype voicemail [SOLVED]

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

Format SQL code

I have been writing copious quantities of SQL lately. Some of the queries are getting really long. When I am working with Navicat it has a nice ‘SQL beautify’ feature that takes messy SQL and makes it nice and tidy. 🙂 While that features is great when using Navicat for SQL editing, sometimes I need to workdirectly with SQL Server 2008 there is no comparable feature built into Microsoft’s SQL pane. 🙁 Thankfully, with a quick copy/paste there is an online tool

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

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

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

Error 1962: No Operating system found. Lenovo Workstation [SOLVED]

If you are trying to install Windows 7 on a new Lenovo workstation, you may encounter the following error message: Error 1962: No Operating system found. The following steps were necessary for the system to recognize my Windows 7 USB installation flash drive: Disable Secure Boot Enable CSM Save changes and reboot 🙂 Other similar errors: b540p error 1962 no operating system found – Lenovo Communityhttps://forums.lenovo.com/t5/IdeaCentre-Desktops-Home-Servers/b540p-error-1962-no-operating-system-found/td-p/1068069i have had nothing but problems with this model since day 1. i upgraded to

USB2.0-CRW driver download [SOLVED]

Recently I came across a new Unknown Device while performing a clean install of Windows 7 Pro x64 on a Lenovo desktop: Thankfully,it was fairly easy to determine that ‘CRW’ stands for ‘card reader’ and find the correct driver here: dl link (use the drop down to select your OS version) Bitland Cardreader Driver for Microsoft Windows 7 (32-bit, 64-bit) – Desktop Bitland 5179 Card Reader Driver for Microsoft Windows 8 (64-bit) – Desktop Bitland Cardreader Driver for Windows 8.1

PCI Encryption/Decryption Controller [SOLVED]

Q. I have an unknown device PCI Encryption/Decryption Controller in Windows 8.1, what is the correct driver? A. You need the Intel Trusted Execution Engine driver: (Dell dl link) File name: TXE_Win7_8_8.1_1.1.0.1089.zip Version: 1.1.0.1089 (Latest) Date: 02/20/2014 Size: 34.39 MB Language: English Operating Systems: Windows 7 (32-bit)*, Windows 7 (64-bit)*, Windows 8, 32-bit*, Windows 8, 64-bit*, Windows 8.1, 32-bit*, Windows 8.1, 64-bit* DELL version, Intel® Trusted Execution Engine Driver This package provides Intel® Trusted Execution Engine Driver and is supported