The lead developer at Mosaic, Brighton with a passion for web application development and motorcycles.
3rd June 2011
Reblogged From jeffreyshek
(Source: hotvvheels)
FullOctane: Bike and Car Blog
External Link: FullOctane: Bike and Car Blog
I have setup a site to post all my automotive related discoveries. Currently I have two posts up there about fuel degradation and storage.
Putting motorcycles into storage or “winterizing” can be an involved procedure so I have decide to cover it in a series of posts beginning with the fuel system in the post entitled ‘Winter Motorcycle Storage: Fuel System’.
Continuing the fuel theme the reasoning behind previous post is backed up by a technical article that addresses the question; ‘Why does fuel go stale?’.
A nice modern take on the original Stratos by Pininfarina set to be sent into production. Thankfully they preserved original rear end lights and lip spoiler. Not so sure about the headlights.
1970 Adenauer Forst crashes
Gives an amazing sense of speed.
Norma M20 makes its way up the Sainte Beaume Hill. (via ibanez80)
Nice footage. Particularly interesting, I find, are the tyres when the dragsters are leaving the line.
Seven stories up. Whoops.
SQL SERVER
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:
But this just gives you a binary file that can be restored if you have access privileges to the live database for restoring. If you are in a shared hosting environment or one where the paranoid admins won’t give you remote desktop access and the only access you have is to run a PHP script to import the data and schema via SQL you will need to export the DB to T-SQL format.
Microsoft have a little program to perform this very function: Microsoft SQL Server Database Publishing Wizard 1.1 It is difficult to find on the web so I aim to save you the time I spent hunting for it. When you run the wizard make sure to set:
- Drop existing objects in script to false
- Schema qualify to false
- Script for target database to SQL Server 2000
It does seem to chew on the cud for quite some time so grab a beverage.
Now for the PHP portion of the process. So you have uploaded your lovely T-SQL dump file to a PHP accessible location on your webserver and now you are wondering how to get into your DB via ODBC. Well you will need a PHP script like the one I have supplied below.
A couple of the complexities to be aware of before you continue. It seems that the T-SQL dump file comes out as UTF16 and we need it in UTF8 so you will need to convert it to UTF8 before you can import. I used a neat little function available from Modular.org for this purpose. This may or may not meet your needs. If you need a more accurate conversion method then I recommend you start your search with the PHP module/function mbstring . T-SQL contains reference and keywords that ODBC/MS SQL cannot understand. I have included some regex to strip these out.
My script is by no means perfect or factored down so feel free to make suggestions or improvements.
Lancia Stratos
Ever since I first saw Phill Eather’s Lancia Stratos at the Targa Tasmania race event when I was a kid I have wanted a one. They have classic styling that has not dated at all, well not much for a car of its age. Most of its competitors are all but forgotten. Yes Bertone did a wonderful job on the coachwork for Lancia’s rally monster. Despite not having any money I have been looking into the Stratos replica options. There are two companies involved in the production of these wonderful cars: Hawk Kit Cars (UK) and Napiersport (UK).
Hawk seem to have sold the most kits of the two and they produce the most accurate replica of the Stratos, panels may even be used on an original Stratos! But some of the complexities and irritations of the orginal Stratos have been copied verbatim into the Hawk design. Napiersport have taken a different approach, keep the looks but improve upon comfort and ease of setup with a better suspension geometry. The Corse (Napiersport’s replica) has however been produced by many owners over the years and I would be a litte cautious to pay in full before I have received the car kit from them in its totallity.
Phill Eather’s Genuine Stratos
The Australian and New Zealand Lancia Stratos and Stratos Replica Register
The biggest Stratos and Stratos replica forum.
A couple of Lancia Stratos books that I found very interesting Lancia Stratos (Rally Giants Series)
