Category Archives: Software Tips

Dell Windows 8 Unknown Device SMO8800 [solved]

Q. I saw you help people with SMO8800 unknown device issues, but can you help me on my Dell Windows 8 laptop? Thanks! -Wobe A. Here is the download link for a Windows 8 driver for Dell laptops that will resolve the unknown device SMO8800 issue: (free fall sensor) OS Compatibility: MS Windows 8 64-bit, MS Windows 8 32-bit Laptop Compatibility: Dell E5420 Vostro 3450 Vostro 3750 XPS 15 (L502X) XPS 15z (L511z) XPS 17 (L702X) And many other similar

iPad Air cannot access (hotmail) mail server?! [SOLVED]

Q. My new iPad Air stopped downloading my Microsoft Hotmail and now I am stuck at about a month ago on my email! I have it set to download all time email in my settings yet every time I try to download it says something like ‘cannot connect to mail server’. Any ideas? -Ian G. A. Hi Ian, I am sorry to hear about your Hotmail problem. 🙁 It seems that in iOS7 there are a number of issues with

MySQL: Count the total occupancy rate for a time period (month)

Recently I encountered a somewhat interesting MySQL/PHP task: determine occupancy for a reservation system. This entailed determining how many reservation days fall within a particular month. It was not possible to simply determine each reservation length (datediff from/to) and sum them because some reservations started before the month in question and other reservations lasted until the month was over. Therefore, one solution is to get the reservation lengths then compare the start and end of the reservation to the start

Reverse order of individual items in a delimited string

Topic: Reversing the order of individual items in a string. Specifics: I had a date contained in a GET query string that was formatted as follows: 01/27/2013 and I needed it reversed to 2013/01/27 Here is a simple method to do the reversing in PHP: $toDate = htmlentities($_GET[‘to’]); $toDateNew = implode(“/”,(array_reverse(explode(“/”,$toDate)))); Explanation of code: First you explode the $toDate variable, then reverse the resulting array, finally you implode that array back into a string. Of course there are other date

Chromebook Guest Browsing mode for Google Chrome

Cool tip! Turn on Chromebook’s Guest Browsing in Google Chrome To test/enable Guest Browsing in Chrome 1. Visit Chrome://flags in browser address bar and enable the below two flags Enable new profile management system, and Enable GAIA profile name and icon. … via How to Get Chromebook’s Guest Browsing in Google Chrome? (click the link to get more info) Photo by JD, Google Pixel Chromebook:  

Using Parrot Zik headphones with Windows 7 / Win8 [solved]

Recently I tried pairing some Parrot Zik headphones with my Dell E6430 laptop. The pairing was quite easy but there was no sound when playing media files etc. 🙁 The solution for me was to: Disable the Parrot RFcomm service Specify that my ‘headset does not have an LCD’ After doing that, the headphones worked quite well with Windows! 🙂 It would have been nice if everything would have just worked right out of the box but overall I still rate

CMOS battery dead, lost settings, Windows won’t boot!

Q. Yo J.D……so my hoss of a Dell laptop (the one with a 20″ screen) seems to have bit it again…It was left unplugged for a couple of days and I think that internal battery was drained. So it will try and start windows, but then it crashes and starts the reboot process over…I can get into set up…do you know how I can fix that boot problem? -John A. Howdy John. Yes, it sounds like your CMOS battery is

Best monitor resolution for SC2?

Q. I read your blog and it looks like you and I share a common interest in Starcraft 2. Can you recommend which is the best resolution for SC2 from a competitive point of view? -Elly Edge A. For maximum Starcraft 2 competitive advantage, you will definitely want a monitor with a 16:9 aspect ratio* as that aspect ratio lets you see the largest amount of terrain. 🙂 Here is an imagine that illustrates the difference between 16:9, 16:10 and