I have now started using SQL Server 2005 in production for new projects. I have one SQL Server 2005 project currently deployed.

I'm now using this technology for production work and quite recently have deployed three projects using it.

The first quarter of 2006 has been a good one and a nice start to the year, I hope my hard work can keep up this trend and maybe even surpass it!

Google »

MSN Search »

Amazon (UK) »

Dictionary »

Dev Guru »

Momo »

Inky Willows »

G72 Creative »

A List Apart »

W3Schools »

Web Integrators Ltd contracted me to develop an MP3 browser that would utilise Windows Media Services for audio delivery. Another requirement was the ability for the the users to comment on each track and give a rating. The ratings are averaged and shown on the file browser page.

This project was ultimatly for the Crowley Foyer Radio Project so the tracks produced at the new recording facility can be shown on their Intranet.

1 Week

1. C#.NET
2. .NET 2.0
3. SQL Server 2005

I tried to create an application that would not require an administrator to have to use a custom tool, this project had just the right attributes to be perfect.

MP3 ID3 tag information can be changed through Windows Explorer, the application mirrors the directory structure straight off the server so the MP3 files can be moved around and the application will update itself and even perserve the comments and ratings by using an XML file that goes with the MP3.

The XML file has all the comments too, so comments can be deleted through Windows Explorer. This allows the administrator to administrate the entire application via Windows Explorer and not have to keep two windows in sync with each other.

The web application uses SQL Server 2005 and only the sync service uses the XML files during an import that runs on a schedule.

1. Supports ID3 tag information (The artist, album, duration info from the Mp3 file)
2. Each MP3 has an associated XML document that contains a copy of the MP3's ID3 tag information and the comments left by users.
   1. This file can be moved with the MP3 to a new location and the application will load the comments and meta-data back to the database
   2. It can act as an overide allowing comments to be deleted and any offensive material in the ID3 tag to be removed.

Media Browser

Media Rating & Comments

Infinity »

Beermat Entrepreneur »

Direct From Dell »

OO Programming »

Visual C#.NET »

VBScript Reference »

Pro' ASP XML »

SQL Server 2000 »

"You only live once - but if you work it right, once is enough. "
Joe E. Lewis

"Fall seven times, stand up eight"
Japanese proverb