Category: Windows Desktop
-
Windows Home Server PC Restore does not work
The short version Last week my laptop crashed and I needed to restore the hard disk. I make a backup everyday automatically using my Windows Home Server (version 1). I took the PC restore disc and booted the laptop and although the restore would start it would never complete. Windows Home Server version 1 is…
-
Fix for Windows 7 “Save as” dialogue is very slow
For several months I have suffered from a very slow “save as” dialogue in many applications. It would often take 20 seconds to render. The opinion on the Internet seems to be that Windows 7 is looking for possibly non-existent shares on the local network. A diagnostic test that this behaviour is that the fault…
-
Accessing Webmin as http://localhost:10000 through an ssh tunnel
If you have an EC2 server it is great to install Webmin on it but it undesirable to expose it through the EC2 firewall. An easier and more secure way to access it is using PuTTY to create a tunnel from a local port to a remote port. When you have done this you can…
-
How to connect as root using WINSCP
In my previous post I noted that I had not succeeded in in connecting to a linux machine as root using WINSCP when using the bitnami virtual machine. My development implementation works, so I have progressed to using the cloud hosted bitnami instance. This comes with public key access rather than password access. This actually…
-
How to install WordPress Multisite on Virtual Box
I do all my development on a Windows 7 computer but the natural environment for WordPress execution is Linux. I would like to use my tools on Windows and then see the running code on a Linux box. One way of doing this is to use a virtual appliance. This is what we are going to…
-
Tomcat 7 on Windows is not UTF-8 by default
When building web applications one typically uses UTF-8 encoding thoughout to ensure that you can send and receive text in multi-byte languages such as Russian, and Chinese. The Window 7 version of Tomcat is (insanely) not UTF-8 by default. This is because it picks up the default encoding from your installation of Java which is…
-
Skype stops Tomcat 7 working on port 80
I recently reinstalled my Rialo application server on a Windows 7 Home Premium PC. I changed the port in server.xml from 8080 to 80 but Tomcat no longer would serve pages. After about an hour I found a forum post that blamed Skype. Sure enough I stopped Skype and Tomcat now runs. c:\ netstat -abn…
-
How to add a row number to an Excel table
Excel tables provide a lot of support for data processing and the use of structured references can improve readability. We want to number rows in an Excel table and we can do it really easily using structured references. =ROW(Table01[@])-ROW(Table01[[#Headers],[RowId]]) We simply find the row number of the current cell [@] using ROW and then subtract…
-
SQL Server Import Wizard cannot import fields containing more than 255 characters
I have been importing data from Excel to SQL Server using the SQL Server Import Wizard. Usually there is no problem but I have found a bug. 1. To reproduce: Try to import a column containing more than 255 characters text, optimistically set the destination datatype to nvarchar(max) and the failure options to “ignore” on…
Dr James Bayley 