I was curious as to how much bandwidth Netflix uses when watching a movie. I decided to monitor this by watching Warrior starring Tom Hardy and Joel Edgerton. Runtime was 2:19 hrs. My 21CN broadband connections sync rate is ~6Mbps. Using my PS3 plugged directly into a Sonicwall TZ 210 I SNMP monitored the port Read More…
Month: August 2012
There isn’t enough disk space or memory when trying to update a table
OS: Windows 7 Software: MS Access 2003 When trying to change the column in MS Accees 2003 from Currency to Number we received the error : “There isn’t enough disk space or memory” Looking in the table there are 350, 000 records – which makes sense. To fix this we need to edit the registry. Go Read More…
VMware : Check new notifications are queued
Software: Vcenter 5.0 All your “Check new notifications” are queued when viewing via your client. This is very easy to fix. Log into your vCenter server. Go to Services and then restart the “VMware vSphere Update Manager Service”
MS Access displaying NULL values in currency column after upsizing to SQL 2008
Software: MS Access 2003 / MS SQL 2008 After upsizing a database, a currency column in a particular table was completely empty via the Access application. However, when viewing the table in SQL 2008, the values are present in “money” format. Suggested workarounds didn’t really fit for us (eg changing the workstations to English US Read More…
Connecting to a share on Linux via Windows 2003 (SP1) NFS Client
Scenario: We have an NFS share on a Centos 6.x server – which other Linux machines use for a data repository. A requirement arose in the network to use a Windows 2003 to server to connect to this share. I believe Windows 2003 SP2 and 2008+ all ship with the NFS Client (although you may Read More…
You must use the dbSeeChanges option with OpenRecordset when accessing a SQL server table that has an IDENTITY column
We just upgraded an internal MS Access 2003 DB to use MS SQL 2008 (in linked server table format) and immediately got the error listed in the title (and pictured below) The debug option gave the following line as the problem: Set rs = db.OpenRecordset(sql) I tried Set rs = db.OpenRecordset(sql, dbSeeChanges) but just Read More…
Setting up a daily cron job to mysqldump
Here is a a little life saver to dump a MySQL DB via cron and zip it up in date format 0 2 * * * root mysqldump -u root -pPASSWORD databasename | gzip > /tmp/DBBACKUPS/database_`date ‘+%Y-%m-%d’`.sql.gz This runs at 2am every morning. You can then set up another cron to delete old files or use logrotate to save Read More…
Searching using the command prompt in MS DOS
Useful command in DOS for searching within a directory : findstr /spin /d:\dir1\dir2\ “searchstring” Note: Flags: /s : Searches for matching files in the current directory and all subdirectories. /p : Skips files with non-printable characters /i : Specifies that the search is not to be case-sensitive. /n : Prints the line number before each line that matches.
Get the top 20 largest files in a directory
ls -lhS | head -20 To delve further into sub directories set the R (for recursive) flag. ls -lhRS | head -20
Veeam/VMware Error: Failed to parse “.”
OS: Centos6.2 (64bit) running on ESXi5 / Veeam 6.0 Scenario: I tried to backup a freshly created VM with Veeam Backup but get the message: Error: Failed to parse “.” Looking at the .vmx file there appeared to be an incomplete value: isolation. =”true” I removed this then, bingo! Please note that you”ll need to switch Read More…
You must be logged in to post a comment.