Compare two SQL Tables

I was updating one table with data from another. However, when I did this there was a¬†discrepancy between the number of rows I had in the update table and the number of rows updated. Here the SQL that allowed me to compare and return the rows that were in the source but not the destination.…

Restarting a Computer via Terminal Session

I can never remember the key combo to do a shut down or restart of a remote computer in Terminal Session. So I’m posting this on my online memory board here. Ctrl + Alt + End. Please note unless you have quick access to the computer in question be sure to select Restart instead of…

Trouble removing trailing space in Excel 2010

I could not remove the trailing space in an Excel 2010 column with the Trim() function. Doing a little research led me to believe this might possibly be caused by the space being something other than the ASCII code for space. (Decimal 32). The function I used to find this. =CODE(RIGHT(A1)) It returned a code…

Shortcut Keys for Terminal Server

If you’re like me then you spend copious amounts of hours in Terminal Sessions via Microsoft’s Remote Desktop. Frequently I’m in a remote session via a remote session so it can get quite complicated getting around. Here’s info from Microsoft Support on using shortcut keys. CTRL+ALT+END = CTRL+ALT+DEL. ALT+PAGE UP switches between programs from left…

Lions and Tigers and Google Apps! Oh My!

I have just gotten off the phone with my contact at Google and told him to run the card. We’re in with Google Apps. Because we have over 50 email accounts we can take advantage of the Google Apps Fast Track service. This entitles us to us of an implementation specialist to assist in making…

Restricting Access by URL to Internet Explorer

I needed to restrict a computer in a public area to specific URL related to HR sites. I found this article on taking care of this in Internet Explorer. Boutell.com To summarize: create a IE ratings file with the following content to restrict everything. ( (PICS-version 1.0) (name “Thumbs Down”) (description “A fake rating service…

PHP -safe_mode prevents uploading of themes

I was attempting to upload a theme for a new WordPress install and I kept getting an error that read. The uploaded file could not be moved to /var/www/vhosts/domain.com/httpdocs/wp-content/uploads What had happened was when I created this site I did not uncheck the default setting of Plesk 9 for PHP safe_mode