Archive: page 18
Say you have a development environment setup using SQL Server 2005 Express Edition and your customer has a SQL Server 2000 database accessible only via ODBC and you can only run a DB import via a script. How would you do it? Easy you might think just run msdbdump.exe on the command line, well this isn’t MySQL so you are not so fortunate. Backing up your DB is easy with SQL Server using the following commands: Read more ⇒
If you haven’t been riding through winter like me then take care getting back out there and wear good gear. Check all the essentials: Oil Water (if applicable) Tyre pressures and wear Chain tension and wear Check all electrics (kill switch and all lights being the main ones) Also have a glance at your sprockets If the bike has been sitting for more than a month then you will probably want to drain the fuel tank as well as the petrol may have gone off. Read more ⇒
Recently I produced a website for hosting on a Linux box running with PHP5 and MySQL5. Well it now needs to move over to a Windows 2003 server with MS SQL as the DB and IIS as opposed to Apache. Install MyODBC Install SQL Server 2005 Express Using MS SQL Server Management create a new database. (right click on databases in the Object Explorer) Use the following SQL Server SQL to create a link to your MySQL DB: Read more ⇒
I recently asked my girlfriend for her hand in marriage; she said yes! We are both very excited and have begun to make arrangements. No date has been set yet but we aim to walk down the aisle before the end of the year. As we are from different countries we have decided to hold a ceremony in each of our countries and England to involve all of our friends and family. Read more ⇒
I have been a little slow to update my website of late due to a change of jobs and having recently moved house. I am now working for WickedWeb (and have been since July), which is a web agency in the Kent countryside and with an office in London (Covent Garden). I am based in the Edenbridge office where I am a web developer working mainly in PHP with some ASP maintenance. Read more ⇒
Here is a small script that I put together to grab the XML list from the ISO website and convert it into an SQL statement. The idea is that the script can be used to just obtain a list for web projects or it can be setup to run periodically to make sure that a list is always kept up to date. Obviously none of the associated checks to make that work have been written into this code so you will need to add it yourself (ie. Read more ⇒
Just a few tips for fellow bikers who might be considering a move to the UK from Victoria. If you only have your L’s pass you test before you come so you can transfer your licence over. When you have a full licence (ie over 21 with a restricted motorcycle licence) this will be transferred to a full A licence in the UK meaning you can ride any capacity bike you like. Read more ⇒
Yeah I know I am not that quick off the mark posting this up, but I have been admiring it for days. The new Street Triple is running a slightly retuned version of the Daytona’s 675cc triple cylinder engine. It also shares the same frame and swing arm as its much lauded super sport colleague from what I can tell. I have always loved the styling of the larger Speed Triples, but I am not keen to go to much over a 600cc until I have had more on road experience in this country. Read more ⇒
I am now based in London and I am working for a company called underwired* based near Farringdon train station. A few observations: The trains are slow, late, expensive and overcrowded Carrying a skateboard around town appears to be frowned upon The roads are rubbish, but entertaining on a motorbike They speak weirdly and sometimes smell funny ;-) Read more ⇒
Geographic Calculations in PHP
warning This library is now deprecated in favour of my new Navigator library. Please use it instead - its much better, tested and makes use of newer PHP features! Recently I have been involved with a project that maps yachts during an ocean race, which got me thinking about basic calculations and conversions that would be useful to fellow developers. I envisage this being useful in projects leveraging Google or Yahoo maps. Read more ⇒