Category Archives: Software Tips

PCI Encryption/Decryption Controller [SOLVED]

16 comments

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

Read more computer tips, Software Tips

Download Microsoft Office 2010

Leave a comment

The other day I needed to reinstall Office 2010 but I was away from home with no install DVD 🙁 Thankfully, you can download MS Office 2010 installation files directly from Microsoft for free, here is the URL: Simply enter your product key and follow the prompts, then your free MS Office 2010 download should start shortly! 🙂 Top Search Terms:adroid microsoft word installation free download (2)microsft office 2010 free download (2)microsoft office 2010 free download (2)download mircosoft word 2010

Read more Software Tips

Enable remote MySQL connections on Turnkey Linux LAMP

Leave a comment

I am a big fan of Turnkey Linux. It is great for working on projects locally, though sometimes I need to allow others access to the MySQL server on our LAN. Here are simple instructions for enabling remote MySQL connections and for allowing user access: How to allow remote access to databases | TurnKey GNU/Linux docshttp://www.turnkeylinux.org/docs/database-remote-accesssed -i “s/^bind-address/#bind-address/” /etc/mysql/my.cnf Configure MySQL to accept remote root connections (from any host (‘%’)): (added line breaks for readability) 🙂 Top Search Terms:conect mysql

Read more computer tips, Software Tips, Work

Fix Chrome blurry fonts on Lenovo Yoga 2 13

Leave a comment

One of the first things I do on a new laptop is install Google Chrome. Sadly, Chrome and Windows 8 do not play well on even moderately high-resolution laptop screens 🙁 Case in point, my new Lenovo Yoga 2 13 (not the pro model) has a 1920×1080 13.3″ display which is fairly pedestrian by today’s pixel density standards. Regardless, Chrome fonts look very blurry when compared to IE or most other Win8 applications. Solution: adjust Chrome properties Go to Desktop

Read more computer tips, Software Tips

Windows 8 disable left swipe (Yoga 2 Pro etc.)

3 comments

In Windows 8 left swipe is fine for touchscreens, but it is majorly annoying with touchpads 🙁 Thankfully, on laptops like the Lenovo Yoga 2 and Lenovo Yoga 2 Pro it is fairly easy to disable the edge swipe recognition on the trackpad: #1 Open the Synaptics Pointing Device Properties Detailed instructions: at the Windows 8 desktop look at the taskbar notification area (bottom of the screen, right-hand side of the taskbar). Find the Synaptics icon which looks like a small

Read more computer tips, Software Tips

Dell Inspiron/Vostro wireless driver for Windows 7 (Atheros 1506 802.11b/g/n)

2 comments

Recently I setup a new PCIt is a nice Dell 660s small form factor (SFF) PC which came Windows 8. The end users needed Windows 7 and that meant it was time to install one of my spare Windows 7 Professional SP1 licenses. Overall the process went smoothly, however, Windows 7 did not have a driver for the 660s’ wifi adapter. Thankfully, I was able to find a compatabile driver that has been working perfectly. Here is the download link: Dell

Read more computer tips, Software Tips

Dell 660s Ethernet driver for Windows 7 (Realtek RTL8111F network controller)

Leave a comment

Recently I setup a new PC for Branson’s Nantucket’s architectural department. It is a nice Dell 660s small form factor (SFF) PC which came Windows 8. However, some of their architectural software is only compatible with Windows 7. That meant it was time to install one of my spare Windows 7 Professional SP1 licenses and everything went smoothly. However, Windows 7 did not have a driver for the 660s’ ethernet controller. Thankfully, I was able to find a compatabile driver

Read more computer tips, Software Tips

Count occurrences both greater than, less than, or equal in MySQL

Leave a comment

  SELECT COUNT(recycled) AS “Total”, SUM(CASE WHEN recycled = 1 THEN 1 ELSE 0 END) AS “New”, SUM(CASE WHEN recycled > 1 THEN 1 ELSE 0 END) AS “Recycled” FROM (a SELECT phone_number, count(*) AS recycled, sale_date FROM ( SELECT DISTINCT * FROM ( SELECT customers.phone_number, customers.sale_date FROM customers INNER JOIN ( SELECT customers.phone_number FROM customers WHERE sale_date BETWEEN ‘2014-05-23’ AND ‘2014-05-30’) list on customers.phone_number = list.phone_number ORDER BY phone_number DESC, sale_date DESC ) AS multiple_sales ) AS sale_dates_analysis GROUP

Read more Software Tips, Work
« Older Entries Recent Entries »