Friday, December 29, 2006

Sub reports embedded in a table

I've had a problem with inserting sub reports into a cell of a table. Every time I inserted the sub report into a cell. The size of the report ballooned out of control and i couldn't work out why.

Well i've found out, and its kind of obvious really, the size of the sub report was too large! I kept thinking it was the size of the filed on the sub report, but then i finally realized the entire report was being inserted not just the filed.

I cant believe I didn't sus that one out right away!

Monday, December 18, 2006

Creating PDF preview on the fly using asp.net

I was looking for a way of creating a preview of a pdf document on a web based app, and I came across PDFThumbnail.NET. (Details here).

Its a free asp.net control, that will take a pdf stream and output a jpeg preview onto a page. Its free, easy to use and fast. Also they answered a couple of questions I had on the product very quickly.
There doesn't seam to be many components kicking around for free like this, so i'd highly recommend it.

Sunday, December 17, 2006

Monitoring SQL Server using SQL Server Health and History Tool (SQLH2)

A couple of weeks ago my boss came across this tool called SQLH2. Its purpose is to monitor Microsoft SQL server, by collecting data about how the machine is performing and optionally what the SQL server services are doing.

The main part is one executable file that you schedule to run every day or so. This collects data about the server, how it is performing and what the state of the sql servers are running on that machine. It logs all this info into a sql server database.

The second part is a service that runs every few mins, and collects SQL server performance counter data. These get put into a local file and when the afore mentioned exe runs this data gets put into the database as well.

Lastly there is a suite of SQL reporting services reports ready made to look at the database, and provide you with all the information it has collected.

I did run into a couple of problems when installing it, the documentation is quite good but the interface to configure it is a bit clumsy you might be better of editing the xml config files by hand.
First thing is if you want to collect perf data from more than one machine at a central point, make sure you share the SQLH2\data directory's on the remote servers out as SQLH2PerfCollector$, and make sure the user running the exe has access to this folder.
Also I found it helped to run the perf collector service as a domain user.

Then, on the server that is collecting the data, make sure you add a new target section the the H2PerfConfigFile.xml file, with the relevant counters. There doesn't seam to be anyway to do this using the GUI config application.

Once you are up and running it seams to create some very useful stats, that might help in your next push for a server upgrade!

The only thing I couldn't get working (and I'm not sure if you can do it) was monitoring a SQL server instance on a cluster. When running the app, even on the server that was currently running the database it didn't find the instance. If any one has got this working can you let drop me and email on how to get it working.

Download the SQLH2 here

Update 28/12 - I emailed Microsoft about using it on a cluster, and the responded saying that it was'nt cluster aware. They did say though that you should be able to use the performance counters section by adding it to the xml config file on another machine. I haven't managed to get this working yet though. If anyone does please let me know

Tuesday, December 05, 2006

File locking probelm sending email from .Net

I've been having fun today trying to update some of our internal advert proofing software. I have some code that attaches an pdf file to an email that I was trying to update.

I was trying to move the pdf file to an archive when it had been sent, but was constantly getting errors along the lines of 'File is locked', 'File is in use' etc that I had never had before.

After lots of head scratching, and looking around the system.net.mail class, I found a dispose method for the mailmessage and the mailmessage.attachments. As soon as I called this method after sending the mail, everything worked fine!

While looking round the class's i've also found some stuff on Delivery Notification options, sound like it might be worth looking into. Ill post on her when i've sussed that out. If anyone knows of any good articles about doing this let me know.

Sunday, December 03, 2006

Getting SQL Report Server usage

A couple of days ago some of our users were complaining about the speed at witch the reports were running.

I suspected that they were running some huge reports to get some year end data, but of course they denide that. I had seen a couple of tables that reporting services uses, and started poking about in those.

After a bit i managed to come up with the following sql that gave me a list of what reports had been run, who ran them, what parameters they used and how long they took to run:


SELECT TOP (100) PERCENT dbo.Catalog.Name, dbo.ExecutionLog.UserName, DATEDIFF(mi, dbo.ExecutionLog.TimeStart, dbo.ExecutionLog.TimeEnd)
AS Proc_time, dbo.ExecutionLog.Parameters, dbo.ExecutionLog.TimeStart
FROM dbo.ExecutionLog RIGHT OUTER JOIN
dbo.Catalog ON dbo.ExecutionLog.ReportID = dbo.Catalog.ItemID
WHERE (dbo.ExecutionLog.TimeStart > CONVERT(DATETIME, '2006-12-01 00:00:01', 102))
ORDER BY Proc_time


Please note that this works in SQL 2005 reporting services, i'm not sure if it will in previous versions. To run for different dates, just change TimeStart's parameter 

Converting RTF files to PDF using OpenOffice

Something really cool I found a while ago, and have started to use again recently is the ability to programmatically control OpenOffice (http://www.openoffice.org)

I have used this in a VB.NET application I wrote that will look into a drop folder for a .RTF file, and convert it to a .PDF file. It took me a long while to work out how to (for free) convert a variety of office type documents to a pdf, this was by far the best.


If you would like the main source code for the function I wrote I can post it up here if anyone wants, alternatively check out this article on the code project website http://www.codeproject.com/vb/net/oo2html.asp This was the article the originally helped me out, there is also quite good developer documentation on the OpenOffice web site.

Tuesday, November 28, 2006

Mail Profile in SQL Server

Tried to setup SQL 2000 today so it would email me when certain events occurred, I have done it before but it took me a bit to work out why it wouldn't work this time. Couple of things I had to do:

  • I needed to install Outlook mail client on the pc. (I suppose any mail client will do as long as it allows you to setup a mail profile)
  • The account that I was running the sql server agent service as was a domain account not the default system one. To get it to see a mail profile I had to login to the server as the user I was running the service as, and setup outlook so it had a mail profile.
  • I was using a mailbox we setup to receive log files from, so it was created under a different user. I had to give the user the SQL agent service was running as rights into this mailbox.
  • After a restart of the Agent service I could then send mail.
I also come across something else today witch look quite cool. Its called the SQL Server Health and History tool, and can be downloaded here
It will log various things about SQL installs to a database, and there is a report pack you can download so you can look at the info.
I've not managed to get the performance counters working yet, and its only logging from one server but when I get it all working ill write it up on here.

Monday, November 27, 2006

Downloading SQL Reporting Services RDL from website

Found quite a funky thing out today that i didn't know about with SQL reporting services. You can download the .rdl file from the web based reporting interface.
This could be very useful if you have lost a copy of the report, or want to look at how someone else has done something

  • Within the web browser interface into the reports, click on a report, then click its properties tab
  • On the general section, just above the apply etc buttons is a little section called Report Definition
  • Click on edit and this will then download a copy of the report as a .rdl file you can open in visual studio, easy!

Sunday, November 26, 2006

Christmas is a comming

Quite excited about Christmas this year, not sure why. Think it might help that the ashes are on over Christmas as well, so that's a good excuse to stay up and drink more. Going of the first test so far its not looking very good though.

Going to have an ashes party next week when my peps are on holiday, maybe by then England might start playing a bit and looking like there might be a slight chance they can win at least one game.

Managed to lose at footie again this aft, cant remember score but wasn't to bad to say we only had 4 of our normal team and we played a team who normally beat us anyway

Listening to: Dashboard Confessional, nice and chilled out for a Sunday afternoon

Usful SQL String Function (coalesce)

I found this function a couple of weeks ago and found it very usful. I had to add a filed to a report, that contained a list of other fileds from the report, each seperated by a comma. At first i thought i'd have to write some custom code, but then I found the COALESCE function.
You can use this in the following way, to create one output from x number of records, seperated by a comma.

DECLARE @aa varchar(100)

SELECT @aa = COALESCE (@aa + ', ', '') + CAST(name AS varchar(5))
FROM tbl_Customer

WHERE (Customer_bal > 10)
SELECT @aa AS Names

I then added this sql to a sub report and passed the id of the line to it, so I could then have this showing for each record. The time it took to render the report increased, but the user got the information they needed.
I then had to write some custom code into the report so it would sort the results in a predictable way. You can read more about the function here

Wednesday, November 22, 2006

I'm Back (but not like a bad smell)


I've not used this blog for a while, decided to start again because I keep needing to go back to things I've done at work but can never remember what the hell I did.
So everytime I do something a bit complicated or something I think other people can use ill post it here. Everyone's a winner!

Since last time I used this blog, me and my girlfriend are now engaged! I happened in Dublin when were where there on the piss for a couple of days with our mates, it wasn't planned, it just kind of happened! Really need to get my finger out and get a house now!

Saw the Killers on Monday at Manchester Apollo, they were really good, the stage looked well cool. It was made out to be like somewhere you would hold a barn dance. They had a really crap supporting band though called the Brakes, I've heard a couple of there songs before and didn't think they'd be too bad, but they were bloody awful. The bass was up way to high and the singer (who looked like Michel Stipe from rem) had a dead annoying voice.

Seeing the mighty Tenacious D next month as well, should kick some serious ass!

Ashes starting tonight, in Aus though so not going to be able to watch it very much. Might be a good thing cos I think we are going to get tanked.

Listening To: Tenacious D Pick of destiny sound track

RIS Setup on Windows2003 Server

So, we currently have a RIS server setup on Windows2000, its now very out of date, the base image has only got XP SP1 on and I cant see anyway I can just upgrade it, we can only ris clients from the subnet the servers on, and we needed to run the DHCP service on the server.
So we decided to create a new Windows2003 based ris server. This is what I had to go through to get it working:

•First of all I needed a copy of Windows XP with service pack 2 on it, to use as my XP base image on the server. There's quite a good web site about it here

Basicly you copy the contents of the XP cd to your hard disk, extract the sp2 download to your hard disk (xpsp2.exe -x:c:\sp2), then run the update app in the i386\update folder of the extracted sp2 and point it to your original xp file. Then you'll have a nice and up-to-date copy of Windows XP. Copy it onto cd or a server assessable by the new ris server


• Now just install the RIS service through the control panel/Add remove programs/Windows Components. Then you should get a Remote Install service under admin tools. Before running that you need to Authorize the RIS server on the domain. You do this (for some reason) using DHCP manager. See the Microsoft article here. Once you have authorized the server, run the new RIS setup application, point it at your new xp setup files and you should have the RIS server ready to go.


• The next thing we needed to do was not run the DHCP server on the same server as RIS, and get ris working across subnet's. When we first installed ris I couldn't find any way of doing this, but I have this time!

There are 2 scope options you can set in DHCP:
066 - Boot Server Host Name (Basicly the TFTP server the client will use)
067 - Boot File name (the file to use on the server to boot the PC)

Set the boot server host name option to be the IP address of the ris sever (give the server a static address) , and set the boot file name to be OSChooser\i386\startrom.com

Add these options to each DHCP subnet you want to use this RIS server on and the PXE clients should be able to find the RIS server and its boot file.

• Now one of the most tricky parts. Adding 3rd party drivers to the base image so that a) the basic RIS setup program will run, and b) the Windows XP setup will run.
We did most of the hard work with this when we setup the old RIS server. The best article I found on it is here. This article basicly says copy certain driver files to certain parts of the folder structure, and update your .sif file to look for the files in these location. When we did this originally we had to manually hack the drivers inf files to get them working on Dell GX270's and 280's but I don?t think that's required anymore. If you need the drivers email me and I can send you them.


• At this point you should be able to now boot your client pc, and it should pick up the ris server and boot from it (as long as you have setup the DHCP options for the subnet your client is in).
Before doing this I copied in the existing ripref.sif file from the old server, as this contained all the options about joining the domain, the product key ect. Its probably worth sorting this file out before doing an install or the install will ask you questions and it still wont be unattended There are various sources on the web that will tell you about the settings, or use can use the RIPrep wizard, as described here

• Something that I never came across on the Windows2000 RIS was it failing to join a domain (if you set that option in the .sif file) If this happens you might have to run the delegate control wizard at the root of your domain in active directory users and computers. Just add the domain admin's and any other groups that will be RISing, and make sure they have the ability to add computer accounts to the domain.

• The final problem I came across was when I pushed an image back to the server. It went back no problems, so I copied into the templates folder of the new image what i thought was a good .sif file.
When I then tried to use the new image, i kept getting an error saying
'txtsetup.sif is missing or corrupt. Error 21'
I had a look around for this error and it turned out the problem was with the .sif file I had copied in. There were some new options in the [OSChooser] section, that the image needed to find the original mirror. So I re-created my new image, and instead of copying the good .sif file over the one it created, I just added all the sections I needed to this one.

That was it, took me a few days to get it working correctly but its definitely worth it in the long run, when you have 150 machines to setup!

Monday, June 05, 2006

You can go slow or fast, but you must get to the line

BO! (a tradintional pissing taking greating in my parts)

England team have flown out today, getting quite excited about the world cup now. We're not going to win it, but might get quite far. Just found out that the day after the final im ment to be in Braknell, which is bloody miles away from where i live. I think if England are in the final i shant be going on that training course!

Got my car serviced and mot'd today, passed ok and did'nt cost me to much so quite happy. Done my insurance as well so ill save £16 a month on that. Just need my loan now and ill be all sorted for hopefully another couple of years.

Not much interesting happening at work at the mo, got the re-write the pa (press association) web app that gets all the latest stories from the national news agencys. Thinking of doing something clever with RSS but not sure yet. Nor do i know anything about RSS so i feel a new book coming on.

Also might have to look at writting a component to create pdfs from rtf files. Not sure where to start with that one though. At the minute I use OpenOffice to do this, driven from an application. Trouble is you need have OpenOffice installed for it to work. Might Try and setup a project on SourceForge and see if i get any response.

Listening To: Reel Big Fish, Favorite Noise. Nice and summary
Random Musing: Why cant I wear shorts at work! My legs are nice!

Tuesday, May 30, 2006

Just Like Arnie

Told you I'd be back! Sorry that's dead cheesy.

Anyway, not much happening at the mo. Going to the garage in the morning to book my car in for mot, its started making an odd noise so im a bit worried that my decision to buy it might be a bad one. Least i should find out soon.

Just watched the England friendly, decided that we should play 4-4-2 not that stupid formation Sven keeps playing with someone in a holding role. If he is going to play that way, why play Owen Hargreeves there, he's shit! Everyone else on this plane of existence seams to see that, so why not the Mr burns of English football. (come on, Sven looks just like Mr Burns from the Simpsons)

On a more important note, me and 2 of my mates decided on a new name for Crouch. Giraffe Boy! You can just see him now on the training ground, munching on some tree leaves while everyone else tucks into there Lucozade Sport. Tell me you dont see it!

Not much going on at work, Leeds were kicking off again on Friday that the fax system wasn't working, so i pointed out that not one job had been sent through it so im not sure how they know that. Managed to find a file spec for Genifax as well, so now i can keep a proper track of all the fax's going in and out. Seams like quite a good product but it cost them a packet, where we use the free Linux solution Hyafax and the skills of Sandy to get it working.

Also noticed there's a new virus out that attacks Word, and there's no patch out yet. Mr Gates and crew have issued a security advisory here. Been quite a while since there was a new exploit that affects office (that i can remember anyway), but at least WSUS will update office now as well as windows.

Listening to: Feeder, the singles. Feeder a classy English band, got a bit pants when the drummer killed himself though. I can kind of understand why though. Going to see them at Leeds for the first time this year

Ransom Musing:
Why is everyone saying Brazil are going to win the world cup again. Most of there (really good) players are now over 30, especially at the back. I'm not saying England are going to win but i dont think Brazil will ether.

Thursday, May 25, 2006

Citizen Journalism... (trust no one)

Ok so i've not blogged on her for ages, not sure why just been busy and stuff. Maybe i've decieded it time for another rant as well. If i can be bothered this weekend i might even try and make this blog look a bit pritter, but im not very good as designing stuff at all.

So, what been happening. Well decided to take a risk on my car and pay it of and not get a new one. Should save me some cash every month long as it dos'nt decided to blow up soon. Should'nt be that bad its only 3 years old.

Going to Leeds festival this year but had to buy tickets of eBay. Only paid £20 extra so not that bothered. Only thing thats pissed me of now is i think they have relaeased some more weekend ones. Hope its not going to be like this next year with all the fucking robbing dick head touts buying the tickets then selling them online for a nice proffit. Not sure what they can do to stop it though. Heard about a Guns 'n Roses gig (http://www.stubhub.com/sites/corpsite/?gsec=news&gact=news&article_id=1741) where they used a barcode sent to a mobile as a ticket.
Quite a good idea, but there are some guinune reasons why you would want to sell a ticket after you bought one. I think the ticket companys need to tackle this as well.
I dont see why you cant send them your ticket back once you've bought it. You can do it with trainers why not tickets?

Been dead busy at work, especailly over last couple of weeks as my boss has been off. Been doing more develpment than every trying to make our newspaper sales system and accounts system talk to each other.
Got most of it working, but one thing i'm having problems with is using the xml export option in crystal. I cant get my head round it at all, so if anyones got any info on it (tutorials, examples etc) then drop me an email or leave a comment.
Also been having to do some work to make my fax proofing system work with Leeds fax server (genifax). Most of its working now, looks like my system will become the standard for the entire division at this rate! I must be getting good!

Looking forward to the world cup loads now, mainly after that cup final a couple of weeks ago. I'm not bothered about Roony playing if Gerard is going be scoring like that!

Anyway, will probably start writing in this blog again now, so tune in for updates folks!

Listening to: Muse, Absolution. Classy album
Random Thought: Why do i never trust what people in garages tell me about my car. They could be saving me hundereds of pounds and i still would'nt belive them.

Sunday, February 12, 2006

Freshly Made Pizza

I think for the fist time ever, i bought a pizza last night after going out on the beer, and i did'nt eat it. Its on my floor as i speak. it was from a place ive never been before, clearly i did'nt like it.

Went round to daves yeterday, he was ment to be comming out with us, but he text me later and said his bird did'nt want to go out. Ive decided i dont like her, she seams to have far to much power over him. There going to Stratford upon avon this week, cos she wants to, what the hells there? Theres no way Dave would want to go, he did'nt seam very excited at the prospect at all.

Went to see a house on friday. It had potential, but i think it needed to much work doing on it. Ducky liked it, until her mum said there was quite a few rats around there. Put me off as well. The guy who used to own it died. He looked like a righ phyco, he pulled the internal doors of and used them as work benchs and the back bedroom had holes in the celling where it looked like he'd hit it with a hammer. And there was an arrow (as in from a bow) on a shelf. Most odd indeed.

Been doing loads of stuff for the new accounts system this week. Was possably the most boaring couple of days ever. It was mainly reports, we got most of them pre-written and just had to addapt them to our site. The reports were in crystal and where the most complex reports ive ever seen. They are bloody awfull and now im ment to be looking after them. I get all the best jobs.

Finally got the copy of sql 2005, and its the 64bit version, so i could'nt install it. Waited 2 weeks for it and its wrong one. What a bloody suprise.

Random Musing: Why are the prices taxi drivers charge so inconsistent
Listening to: Blink182, dude ranch. At the mo anyway, been listening to lots this morning.

Monday, February 06, 2006

The age of Doctor Who

Just been reading some stuff about Dr Who, how come all the actors who play him seam to be over 30 when they start. I dont see what's wrong with having a 20 something Dr.

Talking of telly the new season of 24 starts on Sunday, i cant wait! I bloody love that show, even though its even further from reality than Star Trek is. Jack always kicks ass, and even though the best 'baddie' Nina is dead now im sure it'll be ace again this season. My girlfriend's not impressed though as it means she'll not get to see me on Sunday nights cos i always go up to my mates to watch it, then we tend to get over excited after and have to visit the pub to half a calming pint. Im getting excited even now just thinking about it.

Noticed in the news that people have started to die because of the the protests/violence happening because of those Muslim cartoons, surly even if you are very upset its not worth dying over?

Am having to write another app at work, even though were not allowed to program anymore. Its odd that since we have been told this more programming jobs have come our way. Im not complaining i enjoy it. Ordered Crystal 10 today, it'll probably come tomorrow. Why the hell cant my Sql 2005 come that quick, not expecting it till Wednesday.

Going to look at that house on Friday, my Dad might come as well witch is good cos he knows all about that stuff, where as i know nothing at all. If it was up to me id probably end up paying £80,000 for a shed with a net connection. Need to go banks now and convince them to lend me casharoony.

Random Musing: Why is the newdeodorantt by lynx called 'Click'. What an odd name
Listening to: NoFX. New albumcomingg out in April, kick ass! I need to mp3 my collection of 7" from last year inpreparationn. Hopefully they will be over here touring when the album launches, there an ace live band.

Sunday, February 05, 2006

Brrrrr, Chilly up these parts

Bit cold today, my fathers not put the bloody heating on again even though its minus 4. My mums in a bloody mood again about god knows what, think its cos i didn't come home for my tea one day last week. I really dont see what the hell her problem is. I've told her not to make me any tea an ill just make my own, but she doesn't seam to understand that for some reason.

Might of found a house now, looks ok gonna get an appitiotment to look at it this week and see Mr bank dude to try and get some money. Ducky still saying shes not sure if she wants to come onto mortgage with me, im gonna have to make her realise shes not gonna have a choice unless she wants to live in a shed or caravan.

Quite amusing that Newcasltle won yesterday, after mr souness got the boot, and Shearer broke the club record for number of goals scored as well. That dude is a legend, even if he did used to play for Rovers. Still not really scene Dave an he's been back for ages now. Next weekend my be good opportunity cos Duckys working.

I've been reading stuff about all the protests going on at the mo by the Muslims about those cartoons. I'm sorry but i dont think that a cartoon of someone wearing a bomb hat warrants them threatening more terrorist attacks. How many cartoons do we see with God floating on a cloud or Buddha eating pies or something. Christians and Buddhists dont threaten to blow shit up cos of that, why do Muslims think its any differnent. I think anyone with a banner threatening more attacks should have been arrested for inciting racial violence. Rant over now.

Random Musing: Why are house prices still so expensive, is everyone else earning tons more money than me?
Listening to: The Distillers, Coral Fang. Not many birds in punk bands ya' know.

Random Musing:

Thursday, February 02, 2006

How much is that house in the window

Been looking for some more houses this week, found a couple that might be ok, need to go and look at them though. I cant belive how much you have to pay for a crappy 2 bed terrace, especailly if its in a quite nice area (only one burbury cap nova drinking teenage mum per 10 people). Not much choice really tho, if thats whats on offer thats what ive got to pay.

Someone told me today that people were queuing up last night to get arctic monkeys tickets, they did'nt go on sale till 6 today. I want to see them but thats just nuts. Im sure they'll be at a festival over the summer so ill catch them there. That reminds me i need to check the leeds festival website.

Got our chip and pin hardware today, need to go round a few places and install it now. I cant belive that our software vendor for accouts and advertising system's still has'nt written a new windows based epos system to talk directly to the accounts systems. They've been doing it for 18 months at least now, epos systems are'nt that bloody complex. Plus we have told them what hardware it need to run on. They really are pants, we have found some many holes in there 'flagship' and 'stable' ad booking systems its untrue. Anyway, im going pub now for darting.

Random Musing: Why did Newcastle take so long to sack Souness. I bet Rovers could'nt belive there luck when he went. Newcastle manager, is it the hardest in english football?
Listening to: Arctic Monkeys. Shabba

Monday, January 30, 2006

Why dont you blog me up, buttercup

After what happened at the weekend, my girlfriend is getting really worried about living with her Grandma, so i think im gonna have to get serious about finding a house, been sort of looking for a while, but i think now im gonna have to find one. Bit old for livin with my parents now anyway.

Trouble is its bloody expensive, far to much so. Guess im just gonna have to bite the bullet and get into as much debt as the rest of the country. Bugger.

Still no sql 2005 disks at work, but i've used the Matrix control sucsessfully for the first time today in reporting services. Was easyer than i thought it would be. Reporting services still lacks quite a lot of good stuff that Crystal had, but some of its far betterso i think ill be sticking with it for a while yet. Plus its loads cheaper (i think, licence's have always been a bit of a mystary to me.

Ramdom Musing: Why do all microwave meals taste like cardboard?
Listening to: NoFX, So long and thanks for all the shoes - come on! Cant beat a bit of NoFX

Sunday, January 29, 2006

Oh what a day/night

Quite an interesting day yesterday. Meet my girlfriends Dad for the first time yesterday. Ok, i know we've been going out for ages but id never meet him. Was going ok until him and my girlfriend disappeared outside and started to argue. Then the rest of there family seamed to all appear from no where, she got dead upset and it wasn't nice.

Why the hell do things have to get dead complex, no wonder she's never let me meet him before, most unlikely that i will be doing ever again as well. Never mind least its out of the way now.

Footie again this aft, hopfully we can start winning again today, playing bottom of league so shouldn't be to hard, full team as well today i think.

Hope my sql 2005 disks come this week, been reading so stuff about the new reporting services and looks like it should solve quite a few of our probs, and bring some sexy new features to the party. But cant see anywhere if there is support for rendering rtf text yet. I wrote a little class to display only the text but being able to show it formated would be cool and the gang.

Random Musing:Why are most peoples personal problems caused by parents?
Listing to: Idelwild, the remote part. Classy

Wednesday, January 25, 2006

Oh to be a pie eater

Cant belive Wigan beat Arsnel last night in the cup, it was ace. They should have had 3 pennies, and that robberts who scored could'nt hit a barn door with a barrel all night, but then again theres not really a better time to score than with 2 mins left of extra time.

Rovers playing Man u tonight, i hate them both equally, but my girlfriend is a rovers fan so i supose id prefer them to go through than utd.

Been working in our Burnley office today, i used to work there before i move to Preston. I do miss working there somtime but the MD is a tit now, and most of the cool people have left or been made redundent. Still its nice to go there as its no where near as busy as preston, and you dont have to watch your back all the time while your there.

Ordered SQL2005 today, apartely its going to take 5 days to get here! Is mr Gates burning a copy personally? What the hells going on there. And i bet when it comes it will be the wrong version. Need to use it for the new reporting services stuff, its multivalue select box's and stuff will be a god send.

Ramdom Musing: Why when you eat MacDonalds are you still hungery, what the hell do they put in that stuff.
Listening to: Gollilaz, its ok but not brilliant

Tuesday, January 24, 2006

All Change (probably)

Seams that at work we are going to be stopped doing any more development work. Seams that even though we have to write apps to get certain software vendors programs working right, there is no need to develop.

It's very obvious what they are trying to do now, try and get all the centers onto standard software provided by our main vendors then sack all the skilled staff. They can then employ monkeys on one big group wide helpdesk, give them half an hours training and let them lose. And of course, pay them f*ck all so they dont care about what they're doing. But maybe ill be lucky and they keep me as a body on the floor to move desks, patch phones and networks and help Doris to replace her printer carterages. At reduced pay of course.

Sorry if i'm cynical, but i've been though this before, it benefits no one and make the business run about as efficiently as a slug towing a caravan. I like to develop, its interesting and means im always learning. I couldn't do it full time tho, cos im not good enough and when i get stuck i have to stop and walk away for a bit. I'll get another job ok if it comes down to it, but i like my job. Its always different and the people i work with are cool. Not much i can do though unfortunately.

Not much else happening at the mo, just been paid witch is good, think ill get a new accessory for my psp. Not sure what yet tho, probably a stand. Going to flog my old gameboy and GameCube games tomorrow, would have put them on eBay but packaging them up and posting them would be a pain in the ass. That reminds me, need to think of a killer item i can make easily and sell on eBay.

Off to pub now to watch the footie and play some darts.

random Musing: Why do people in charge of big company's always want to cut staff and things like that out, instead of selling more of there product by making it better.
Listening to: Arctic Monkeys, again

Monday, January 23, 2006

Only staying cos of the world cup

Well, looks like Sven is finally going to get the boot (no pun intended) from the england job, about time really. He's a proper wally for telling all that stuff to the reporter. Ok, so he was pretending to be some rich arab, but someone in his possition should really no when to keep there mouth shut. The only reason he was there in the first place was to get more money. He's just a greedy sod, thats his and most other people in footballs problem. I'm bloody sure there is curruption in football, but its probably so wide spread by now i doubt theres much that can be done about it.

Got the Arctic Monkeys album today. I've heard most of it already but had to own it. As i mentioned before its fantastic. Trouble is they are being hyped a lot, i even heard them called the new oasis today. I wish people would'nt do that, i know it'd put me off. Can you name a band formed in the last 3 or so years that are going to last for another decade? Im sure i cant.

Random Musing:Why do microsoft include a TopN filter in SQL reporting services, yet in there sample reports they use a sql top statment to get the top most records returned. Its twice as hard to do it that way if you want to use a parameter.
Listening to: Guess

Sunday, January 22, 2006

Cheesy Bread

Something odd just happened to my sexy new smoothwall box, for some reason it wouldn't conect properly. The line and everything was up but the ppp wouldn't connect. Checked the logs and noticed some crap about a ppp.tdb file corrupt. So delete that, rebooted and tis fine again now. Most odd. Think i might buy a proper adsl router instead of the crappy modem if i keep getting problems.

Saw new underworld film last night. Kind of what i expected Except there was some nookie(sex) in it witch was nice, as Kate Bekinsdale is rather foxy, and her ass is amazing in that pvc. Kind of explains why it was an 18 cos it wasn't that gory or violent.

Saw the film with Dave and his Bird. She seams ok but did'nt say very much, and Dave did'nt drink witch was most odd. Will have to go on the piss with both of them so i can sus her out. Daves brother in Law has his own firm now witch is good cos it means Dave will have some work and get cash. N0t sure how long there staying for yet as well.

Time for dinner i think now


random Musing:Why do Pizza hut give you some cheesy bread in there feed the family deal that will fill you up before the Pizza comes?
Listening to:Starsailor, On the Outside. Good sunday Music.

Friday, January 20, 2006

Just a Quikie

Felt a bit rough this morning, prob cos i stayed in the pub till about 2 playing darts. Im sh*t at it but its still fun.

Going see underworld 2 tomorow with Dave and new bird, should be amuzing. Glad its weekend.

Random Musing: Why in our modern age cant they a: Invent a beer that dosn'nt give you a hangover or, b: Invent a cure for a hangover
Listening to: Artic Monkey, cant say enough good things about them. Need to see them soon live

Thursday, January 19, 2006

Playing Politics

I was in a dead good mood this morning, had a nice night in with my girlfriend last night and was feeling good this morning when i got into work. That was until i sat at my desk and started to read my emails.

I'd sent a quick note to one of my colleagues last night to check i was ok to make a slight alt to our ad booking system, as i kept telling the user whose in charge of the system 'admin' she couldn't use non numeric chars in a certain field, as i was screwing the reports up. He proceeded to forward this email (god knows why) to the user in Question, who then sent me a very condescending email. I would have expected the type of email i got from the user, but im well pissed of at my 'mate' for sending it her. He sort of apologized for it, but i think i know the score with him now.

I think ill have to start relizing that most people at work are only bothered about what they can get out of everyone else, and if they get in the way or get shit on its tough. I shant be putting anything in writting to him anymore, nor will i be pulling him out of the crap like we have had to so many times in the past.

Anyway, moan over now. Im just about to go to the pub with my mates Chris and Gaz. Going the the White bull where they serve the best beer ever. We call it 'old man beer', or real ale to most people. They always have something new on everytime we go. I bit more exciting than the same old larger. And i can play on the Bandit and darts without anyone bugging me. I've never once sceen it kick of in the bull, and ive been going there for years.

Think im finally gonna see Dave and his new bird overweekend. I'm sure it was her who did'nt want me to see him last week. Need to get him on his own to find out.

Random Musings: Why do hang chocolate coins on the tree at christmas?
Listening to: Bouncing Souls, Anchors Aweigh. An ace album but i think they've split up now. Most of my fav bands seam to be.

Monday, January 16, 2006

Things to be mad about today

Not very happy today. I've had a really crap day at work, fed up of being sh*t on all the time and other people in the dept not pulling there weight, then having a moan when things dont get done. Then they're in bloody meetings all afternoon so me and Sandy have to deal with everything, just for a change.

But what im most pi**ed off with is my footie yesterday. Instead of a ref we had a jjb employee. We have had this before and they are pritty bad, but this one was terrable. He did'nt give a blatent penelty, kept stopping the game before just before people scored etc. Then when we had a go he told one of my team to f**k off! So we went to complain but he stood there while we did and started lying about what happened.

So, my mates sending a letter, but i've got the customer services number as well so i might ring them up tomorow if i can be assed

Just Managed to get my linux firewall working! Uses Smoothwall, took some messing about with to get it to see my crappy little usb modem, but at least its working now. Just need to setup my wireless access point and im done. When i turned the IDS software on it told me (after 30 mins or so) that slammer had tried to hit me, i cant belive there are still systems out there sending that out.

Ramdom Musing: Why cant Mr Gates and co make Windows as configurable as Linux?
Listening to. A, Teen Dance ordinal. Not sure why. Think they have split up as well

Sunday, January 15, 2006

Sunday Mornings...

..art'nt they crap and boaring, and why even if ive not been out the night before do i still feel shit (i did go out last night but thats not the point). Had to get up as well to take Ducky to work, who the hell wants to go and buy tracksuit pants on a sunday morning. Bloody chavs.

Was ment to see Dave yesterday but he was ill so did'nt go. Not sure how ill he is, think he's probably just skint, so still not met his canadian bird. Need to see him this weeek. Even if its just for new cds! He said the pub we go to in Blacko (the little place he lives) has been taken over by a newlandlord, so they probably wont do the best going out drinking food (sausage, chips, egg and beans) anymore, or show Burnley(football or socor for you yanks) matchs on dodgy cable channels anymore.

Talking of the footie, did you see city man u on match of day last night. How good was that! I love watching utd get beat, then Ferrgie went nuts at the ref, he's bound to get a bollocking for that now. HaHa. Burnley lost though, why the hell cant they play agasnt average teams?

Think ive found out why im having probs with my firewall at home, turns out Sandy (who helped me build the linux firewall) gets proper broadband (ie through his cable and gets presented with rj45) where as i've only got adsl. So ive found some stuff out about PPPoE witch adsl seams to use and ill have a go at setting it up this aft before i play footie. My teams second in the legue by the way. Armatage Shanks (yes, we are named after a toilet). Look at http://www.horizonsoftware.net/jjb/110251004105jbbl191l00017.htm. Sunday divison 1. TV Time now.

Random Musing: Some people must never leave there job, i posted some stuff on a microsoft newsgroup on friday night before i left work and people have responded already. Im sad but not that sad, dont work all the time!
Listening Too: The smiths, hatfull of Horrow. Good sunday music

Thursday, January 12, 2006

Bigger Brother

Why is everyone watching that big brother crap again, even my girlfreind(who normally likes stuff like that) is'nt bothering. Plus im not quite sure who the 'celebs' are. Just cos you shag an ulgy sweed who happens to be the england manager doe'nt make you famous, it makes you a tart.

My broadband went odd yesterday, it kept comming up saying remote computer did not respond. Not sure what caused it but seams ok now. Ill plug in my firewall and see if that breaks it.

Changed my working hours now, dont start till 10 witch is ace, i dont mind finishing later that much i prefer to spend time in bed in the morning.

Random Musing: Why the hell by default does iTunes fade the tracks into each other, and how do i turn it off!
Listening to: Dropkick Murphys, Blackout. See them live they kick ass

Tuesday, January 10, 2006

What is it about this time of year

Everywhere you look someone is ill or in a really bad mood, its not good at all. I think i read somewhere that this time of year most people get proper p**sed of and upset, prob cos weathers crappy and there in to much Debt.

Anyway, went to see the producers last night, quite good but the start was a bit odd when the accountent dude had is bit of blanket. Songs in it were ace though. I cant belive it was 3 hours, all bloody films at the mo are uber long.

Managed to get my Linux firewall working at work, just been playing about with it at home but dos'nt want to play ball, but i think its because the adsl router i got of my boss is giving out an address i dont want, i need the dhcp one from the isp but its giving me a static 192.168.x.x one. No good. I could quite get into this unix thing if i have time. Its bloody powerfull, just a bit tricky to get my little head round.

Ramdom Musing: Why do big boss's always have stupid sayings. Was sat in a meeting today and our md kept saying things like 'stakes in the ground' and 'marker in the pack'. Is that what they teach them on those managent seminar things? And i get told not to talk 'techie'!
Listening to: Smash by the offspring. Classy. Plus My mate Dave is back from canada today so he's bound to have some cool new cd's

Friday, January 06, 2006

Sausauge curry and chips for tea...

.. i do like chippy teas on a friday. not posted for a couple of days cos i could'nt be bothered but back again now. My best mate Dave is comming back to england on monday. He's been in Canada for ages with some bird he ment on t'internet. Gona be good seein him again and im curious to meet his bird, especialy after what he said about her when i talked to him yesterday.

So, had a really crappy first week back at work, been trying to build a linux firewall today for home, but could'nt get the forward dns lookup working from the clients, works fine from the linux box but everytime i try and resolve from any clients it times out. Think its the named service playing silly buggers but even Sandy (unix guru at work) did'nt know what it was, any ideas?

Our newspapers has also been picked out of everywhere in the group to trial a 'newsroom of the future' project. Editorial staff are going to start editing alsorts of digital content (vids, podcasts etc). Trouble is most of them (especially the editor who is in charge of the project) cant even log there bloodys pc's on. To be fair they are journalists and subs, so i cant belive they are asking them to do it. Im sure the union will kick up a stink as well. I dont really see why they are doing it, no one's intersted in local news anymore but i supose they have to do something or the newspaper industry will be in bigger trouble than it already is.

Mr Gates and crewe has released a patch for the wmf flaw today, instead of waiting till the normal release cycle next week. Bout time id say, hopefully they got an ass kicking of someone so they brought it out early. Got a normal ac power charger for duckys iPod mini today, cost me a tenner though, why the hell dont you get one in the box.

Random Musing: Why does curry always make me need a dump?
Listening To: Some arctic monkey, they are ace cant wait for the album

Tuesday, January 03, 2006

Free beer

Im drinking some beer at the moment that is ment to be Chinese, very strong indeed, Its called Shanghi beer and i got it free from work as its going out of date soon. Trouble is this is my last bottle. Bugger.

Had a really crap day back at work today, i always get sh*t on with things i dont know about but people seam to think im ment to be able to fix it, then people who should be able to do it tefflon desk it to me and then p*ss of home. Anyway enough moaning.

Have cleaned out alot of the crap from my room today to make way for new crimbo stuff, read some of my old birthday cards from when i was 21 and stuff and felt a bit sad, not sure why. I must miss the people i used to work with or something.

We have beening trying to sus out how to stop the wmf expolit affecting us at work, as normal the people in group IT give us no guidelines even though thats what there ment to do. And you can gaurentee what ever we do will be wrong if we get hit with anything. Plus Mr Gates and co art'nt releasing the patch till the 9th so lots of help there. Why dont microsoft get an ass kicking for this, if i had a car that the door fell of if prodded in a certain place i would sue the ass of the car maker, but what do i know. Ok moan over now

Random musing:Why does this Chinese beer im drinking say on the bottle exported from eurpoe?
Listening to: blink182, dude ranch. Forgot how good this album and blink where. Throw away punk put very catchy

Monday, January 02, 2006

Happy new year...

... i hope everyone had one. I was in bed at the time felling like sh** as a caught the cold/fluey thing that my girlfriend had. At least i saved some money i supose, and ive always prefered going out on xmas eve than new year.

Just seen the new kong movie, very good but very long, my girlfriend cried when kong died, bless! Back to work tomorrow, guy who used to be in charge of us is now in charge of all group IT, so im expecting some changes afoot, and probably not good ones.

Not been online for a couple of days so ive jus been reading more about the windows wmf exploit, seams like its a bit of a beast and the first proper worms are starting to apear. A windows programmer has released an patch until microsoft do, get it at http://handlers.sans.org/tliston/wmffix_hexblog13.exe, probably a good idea.

Random musing: Why cant Peter Jackson make a movie less than 3 hours long, the Kong DVD will probably be on 5 DVD's!
Listening to: Idelwild, the remote part