Tag Archives: DB

The Owl USB Energy Meter and using the SQLite Database with PHP

Posted by dave on June 14, 2012 2 comments

I’ve had The Owl running for a little while now and the software that comes with it is a little bit rubbish to be honest. I kinda works OK I guess but is very limited, so it was time to have a little …

Read more »

Migrating Reporting Services from SQL 2005 to 2008

Posted by dave on July 13, 2011 3 comments

I’m right in the middle of quite a large migration from one of our 2003 boxes to a fresh 2008 box. The box in question is the main SQL backend and is currently running SQL 2005, the new 2008 box …

Read more »

Backing up mySQL Databases Batch File / Script

Posted by dave on July 4, 2011 No comments

And another, this time to backup the databases, based on an earlier post or creating simple backups, I can then call this batch from within another batch file. @echo off IF %1.==. GOTO No1 ECHO Dave’s mySQL Database Backup UtilityECHO …

Read more »

OSTicket Database Errors (Polish Characters)

Posted by dave on February 16, 2011 No comments

I’ve had a few emails from OSTicket recently, telling me that there was a DB error, specifically: Incorrect string value: ‘xC2x0AThan…’ for column ‘message’ at row 1 The email had originated from a Yahoo address and so my initial thought …

Read more »

Script to backup MS SQL Server Express Databases

Posted by dave on March 16, 2010 No comments

This is a bit of SQL I use to backup Microsoft SQL Server Express Databses (the free version from Microsoft that doesn’t have all the functioanlity of the full M$ SQL Server). There’s a bit more to it than the …

Read more »