August, 2012

How much bandwidth does Netflix use?

August 31, 2012 Jordansphere Sonicwall

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 […]

More

There isn’t enough disk space or memory when trying to update a table

August 30, 2012 Jordansphere MS Access

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 […]

More

VMware : Check new notifications are queued

August 24, 2012 Jordansphere VMware

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”

More

MS Access displaying NULL values in currency column after upsizing to SQL 2008

August 24, 2012 Jordansphere MS Access

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 […]

More

Connecting to a share on Linux via Windows 2003 (SP1) NFS Client

August 23, 2012 Jordansphere Linux

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 […]

More

You must use the dbSeeChanges option with OpenRecordset when accessing a SQL server table that has an IDENTITY column

August 21, 2012 Jordansphere MS Access

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 […]

More

Setting up a daily cron job to mysqldump

August 21, 2012 Jordansphere Linux

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 […]

More

Searching using the command prompt in MS DOS

August 17, 2012 Jordansphere Windows

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.

More

Get the top 20 largest files in a directory

August 9, 2012 Jordansphere FreeBSD

ls -lhS | head -20 To delve further into sub directories set the R  (for recursive) flag. ls -lhRS | head -20

More

Veeam/VMware Error: Failed to parse “.”

August 8, 2012 Jordansphere Veeam

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 […]

More

« Previous Posts

Powered by WordPress. Designed by elogi.