I don’t blog as much as I should. I’ve just installed the latest Windows Live Writer Beta, which is why I’m blogging now.
The interesting thing is, I feel like I’m talking to myself. As I don’t feel people are reading my blog.
Live writer has a link icon to the status of your blog which I’ve just clicked. People are reading! Even thou it looks to me as if there trying to find info out, but that’s fine by me.
So maybe I will blog more in the future.
Cool! It updates the post rather than creating a new one. 🙂
I passed my first Microsoft Exam, on Friday. I’ve been working with computers since I was 13+ (I’m 30 now). As I worked in a single company for 9+ years, applying for a Microsoft exam never seem to happen. I think it was a combination of me not wanting to fail and the company I worked for not pushing me and others hard enough, no encouragement, no offers of paying for training courses or books.
The other underlying fact, which I still believe is the case today, is there are allot of people out there who can study then sit and exam pass and think they can do the job, I know this not to be the case. I really would like Microsoft to have some exams where you had to prove that you have been working in the IT world of at least 2 years, therefore it would show some real world experience.
The exam itself was 42 questions, which took me approx 50mins to do, I spent another 20 mins or so reviewing my questions, then I finished and I had pass, this wasn’t my first attempt, I tried last year and failed, the pass mark was the same then as it was on Friday, 700. Last year I scored 670 and on Friday I scored 752, both times I didn’t revise, so I’m quite happy with that.
This now means that my company (Total ICT Limited) is now a Microsoft Small Business Specialist, which proves to Small Businesses that we are selling to that we do know what we are doing. This was another major reason for taking the exam; I didn’t to enhance my companies reputation and credibility.
Lastly, sorry for not posting very often, I will try and get this nailed down.
I was trying to figure out how to get a T-SQL to allow a user to enter part of a name to query on, for example the user could enter ML, click a search button which would return all companies with the letters ML in.
I Googled this and looked on MSDN, to no avail, I knew I had achieve the desired result using access a while back, but I was pretty sure I didn’t have a company so I could check the syntax, then I recalled where a may have a copy which I did, I cracked it open and found the following:
WHERE IMPartNumber Like ‘*’+[?]+’*’ Or ManufacturersPartNumber Like ‘*’+[?]+’*’ Or VendorName Like ‘*’+[?]+’*’;
After entering this syntax into Visual Studio 2005 Express, thinking it work it didn’t, so after reading the required syntax for LIKE in the SQL Express 2005, I came up with this working solution.
SELECT CustomerID, LoginName, [Company Name], StreetAddress, townName, countyName, postcode, ContractType, StartDate, FinishDate, Notes, Active
WHERE([Company Name] LIKE ‘%’ + @SearchText + ‘%’)
Were as Access uses ‘*’ SQL Server uses ‘%’ instead…. Problem fixed. ?
I was reading PC PRO April 2007 Edition, which landed on the door mat at lunch time today. While reading Jon Honeyball’s column he mentions this utility which allows you to remove the advets from Windows Live Messenger (among lots of other things).
You can download it from here: http://apatch.ikhost.com/downloads.php
I’ve just read this post and I’m happy to report that in the Release version of Vista, you can select other removable media…. thank good.
I haven’t blogged in a while, but have thought a few times lately that it would be useful to blog that… I’ll try my best to blog at least once a day. I’m Blogging this from Word 2007 final release.
OK here come a loads of blogs in one hit…….
I was working down the street yesterday there was a poster on the side of a bus stop, which was using a image from Google Earth, the ad was advertising BA flight costs to new york, I didn’t have a camera with so did get a chance to take a picture, I’ll see if I can get one..
I was a bit slow on this one, but the Public Download of Vista RC1 is now available here.
It will be interesting to play about with after the great press/reviews this release has been receiving of late.
Sony is having to delay it’s release of the PS3 in Europe until March 2007 due to supply issues with the supply of blue ray drive technoolgy.
More information here