2 hours FREE Microsoft Office Sharepoint Services Training (MOSS) from MS

Came across this on the MS e-learning site today as im looking to further my skills in this area.

Sign up while its free if you are interested as there is a 1 year subscription on it. They may start charging soon.

https://www.microsoftelearning.com/eLearning/courseDetail.aspx?courseId=61966

LearnVisualStudio.net - Fantastic learning site

Ive added some link banners to the top of my blog for LearnVisualStudio.net. I cant recommend this site enough. If you are a complete novice or an intermediate with plenty of .net under your belt you will always find something on there. Its how i learnt .NET and helped me become the developer I am today.

The videos date all the way back to 1.1 and then upto current day technologies such as AJAX. The current learning path is hooked into gaining microsoft certification for the new exams. This is something i am working towards and for the price they charge compared to a microsoft course it is pheomenal value. The best £100 i ever spent. Its the price of a couple of books and as im a better visual learner than learning from a book i find them invaluable.

They also have private forums for the lifetime members and these are great - especially for beginners. Anything you ask in here will be met with respect and you can guarantee you wont be shot down in flames!

ASP.NET AJAX Javscript call - Web Service is undefined Error

I tried to implement this using a script manager and script enabled WS but constantly kept getting the error 'service is undefined'. Talk about infuriating.

I ripped my web.config apart trying to find the problem, hacked my code, moved scripts - alsorts! Searched high and low on the net but could not find the solution to the problem anywhere. I had a sample project that it worked fine in and everything was exactly the same (well almost).

Then i started looking at references. When doing this i spotted the namespace in my project which lit a light bulb. The sample project was a Web Project and there is no namespace property like on the project. So i went back to my javascript and changed the following line as follows:

Webservicename.Webmethod(prams, callback);

to

Namespace.Webservicename.Webmethod(prams, callback);

Worked a treat!

Hopefully this will save someone a days worth of head scratching and wasted time like myself.

A nifty SQL query for searching for text references

I needed to find out where i was loading a file in a bulk insert today and found the following query:

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%search string goes here%'
AND ROUTINE_TYPE='PROCEDURE'

That will basically do a find for you and list the procedures your search string is present in.
Very handy.