Another one, 70-315 passed this time

Just passed 70-315 Developing and Implementing Web Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET, the first of my c# exams towards my MCSD. Woohoo!

Amazed myself at a half decent pass mark too – they are still sticking back to giving pass marks and section scores and I was more than a hundred over the pass mark (just ;)).

The Que book and the transcenders were helpful, though I felt that the mix of questions was quite different to that of the transcenders in the exam that I took. And as I expected, the exam doesn’t test coding per se, rather the framework elements related to web development. So there was a good amount related to the handling of web forms and the new data handling bits that they head up as ADO.NET.

Now for a brief breather of an evening, then preparations for the windows app exam, 70-316.

Only two c# exams to get, and I’ll be an MCSD .NET to go with my MCSD for Visual Studio 6.0!

Long Way Round

Sky One showed the last episode of this six part series last week, which I have been watching on Monday nights when it is shown here in the UK on satellite television.

For those of you who don’t know the background to the show, it was the account of Ewan McGregor and Charley Boorman going round the world on BMW Motorcycles. The series went from the setup of the idea, picking bikes to getting the trip together and travelling across Europe, former Soviet Block countries and bordering countries, up and over to Alaska and then on to New York.

When I first heard that it was happening I checked out the airing schedule and found out that neither of the channels that they advertised it on were available on my Freeview / TopUp TV terrestrial digital television so I waited a little then got arranged to pay my money to the relevant part of the Murdoch empire and got digital satellite television. It was a couple of weeks before I realised that they were repeating it during the week on Sky Travel, which I got on my terrestrial package, but also that the Bravo listed on the longwayround website was in fact the American channel.

Being a bit new to this stuff I didn’t realise the global marketing going on behind the show and that of course it would be shown in the US too. I have subsequently realised that a number of channels have US and UK versions that are subtly different. Ignoring the big obvious ones, the likes of the Sci-Fi channel have equivalents which are slightly different, as does Discovery. In a fun crossover, they visited the stars of another favourite show of mine on Discovery, American Chopper’s Orange County Choppers.

Long way round was really interesting, but of course Ewan fell into the easy trap of comparing scenery everywhere to Scotland as he went along. It is an irony of the country that I have lived in all my life that we neglect to visit our own country as much as our fellow Europeans. I have only travelled to the area once in my life, but the far North West of Scotland with its sea lochs is simply stunning, and the far north from Durness to John O Groats is as far removed from Edinburgh and central Scotland to feel like another country.

I have ordered the DVD for the show from Amazon and it should be on its way now, I bought the book to the series but it really needs the pictures to get the full impact of what was happening to Ewan and Charley as they rode their GS bikes across a continent. For instance, some of the food dishes peculiar to the countries have to be seen to be believed. The book and show go really well together, the book expanding on the video diaries that the guys took, and the video diaries just showing how tired they were at most stages of their trip.

I can understand why it was edited down to six shows, which is probably pretty long for this kind of show, but there must be so much that they had to cut in order to fit a trip of weeks into about four and a half hours of programme. It ended really quickly with the last show, which tracked them crossing Canada and the US in one show. I guess the mileages they were covering each day on the bikes (500-600 miles) meant that the time went quickly.

In the end it was another opportunity to study people, yes it had bikes in it which was the hook that got me interested, but it was the two main characters, the cameraman that rode another similar bike with them (Claudio) and the other people that they met that were the cornerstone of the story. The trip looked fascinating, but not for me, I could never go that long from the people that are important to my life – my wife and kids. Quite fancy a BMW bike though, an old R1100RS, in black would suit me fine. Similar engine to Ewan and Charley’s, but with more of a sports touring bias. For shortish trips from the house and commuting to work. Nice. And I could grow my beard back again.

Alistair does .NET part 2

Now finished the book I have been working through, so I have covered all of the material relating to 70-315. Of course, that is not all of it so I am now working on practice exams to show up my weak areas.

And it is going pretty well too. I am beginning to get ready to book the exam, but it looks like all of the places have gone from the local test centres in December which is a disappointment.

As for the material, I am itching to get to know the other areas. I have three exams to sit to get MCSD.NET, this exam included. In terms of the learning experience I am really interested to see what the material says in the Web Services and Server Components exam. I will most likely do the windows exam before that, though, as the material shares more with 70-315.

Alistair does .NET part 1

Since passing my SQL Server exam at the end of October, I’ve been focussing on bringing myself up to speed on C# and .NET with a view to my first coding exam being 70-315 developing web stuff with C# and VS.NET.

It’s not as if I’ve completely ignored things over the years, just that I’ve only really had opportunity to skim the surface.

My recent efforts have also been an opportunity to try out for myself the materials that are used to maintain and enhance the technical skills of the people we employ at work.

First stage I went through was a consideration of computer based training from appdev which is a series of CDs featuring the dulcet tones of Mr Jesse Liberty going through the fundamentals of the C# language. I was really impressed at the quality of the training, even if it was a bit back to basics when looking at the basics of conditions, looping, and function calls.

Having completed that I’ve moved on to working through the QUE book for 70-315 which I think is really good as well. It is completely focussed on the exam, following the exam outline with material and exercises for each heading and subtopic. Having got to chapter 6 I’m beginning to reassess how many of the exercises that I carry out in detail as I think the pace is a bit slow. But that said, on what I’ve found so far I would still recommend the book. Each chapter ends with a number of example questions in the style of the exams – something I think is very helpful. The book also starts with a discussion of learning techniques and processes, a useful analysis of how information is retained and related to what is already known.

As for what I think, the bulk of the detail to date has been C# the language. I continue to get caught out a bit by the case sensitivity of the language, I tend to add too many capitals to keywords because of my long history with Basic and scripting derived languages. That said, I continue to be impressed by the support for object orientation and the support given through the framework classes. It all makes a lot of sense and has a kind of coherent ring in the design that all fits together really well.

What I would say though, is that you’re not going to learn this stuff without having a full copy of Visual Studio .NET, one of the versions of SQL Server and one of the Microsoft operating systems that supports IIS e.g. XP PRO or better. Not an insignificant collection of kit.

Of Rhana Consulting and Jonathan Blair

Ok, I’ll start by declaring that I have no vested interests in the above company and individual. I only know the guy exists because he is an MCP Hero and reads books on the train. The other interesting thing is that Rhana Consulting used to have their business address in the same street as Cedalion used to be in, Maritime Street in Leith.

I’m forging ahead with what I think is my fourth iteration of the Microsoft Developer premier certification title, MCSD.NET and diving in to the excellent technology that is C#. Having a recent look for Mr Blair and Rhana Consulting to add further motivation to my certification momentum drew a blank, in particular their website which used to be at http://www.rhana.co.uk/ has dropped off the internet.

So where have they gone? Have they gone on to bigger and better things? We need to know!

An exam pass, this time 70-228

I am pleased to report that I got my other SQL Server exam passed today. 70-228 Installing, Configuring, and Administering SQL Server 2000. I had been looking at the exam materials over the last few months in the absence of any other specific objectives. With my objectives set to .NET, I managed to get the exam in quickly this week to get a result for my studies before I get my head down for the next exam.

That means I have one core exam to sit if I want MCDBA, but my focus is now on the three c# .NET exams to take me to MCSD.NET.

The exam I passed ? As you would expect, lots of stuff on administration – backups, security, indexes and the like. And for some reason it wasn’t as scary as the developer exam, but that was probably down to timing.

Recently, My work has mostly been in Glasgow

I posted a long time ago about working on various versions of SQL Server in the space of one week. My work over the last few weeks has been a bit of a change and I have been working for customers at their locations in Edinburgh and Glasgow.

Different customers, I hasten to add. The first two weeks were an interesting time helping an Edinburgh company witht the performance of their SQL Server database. It was one of those good jobs where you get to really prove the techniques that you know about. That was interesting as well being a web architected application with Microsoft SQL Server at the backend of things, but with J2EE running on windows servers running everything else.

I have followed that up with some time spent in Glasgow helping to upgrade a business application. I’m not going to go into the technologies too much, but it is an application that has run in a similar form for a number of years. It goes to show that an application can run for years if the core business analysis is correct and comprehensive. Having just read over that I would probably add that it also needs a good bit of stability in the underlying business. Some areas of the Financial Sector have business processes that have remained pretty constant over the years, and applications serving these can live for a long time too. Do some good analysis, listen to your users and implement a stable solution and it will hang around! All we have to do now is figure out how to establish a regular revenue stream 😉

I’m heading off to another customer later on to do some maintenance on another “mature” application. Both prove to me that whatever you do you have to have a stable application that helps people to do their jobs. Then you can decide how “usable” or attractive it looks. Proper usability will help all different kinds of users to do their job in the most efficient way possible, but there is a threshold that can be passed where IT goes a bit far and bells and whistles take over. But deliver an application that doesn’t work, doesn’t do the job, or is unstable and you will have lots of upset.

Out and about in Edinburgh

Ouch , almost the weekend and I am posting about last weekend. Being as I hadn’t been to them before, took the family for a look around the Scottish National Gallery of Modern Art and the Dean Gallery. Spotted minor Scottish Celebrity Stephen Jardine while we were there too.

I obviously need a bit of work on my appreciation. I enjoyed the grounds more than the contents of the galleries themselves. It was interesting to see Warhol stuff in real life, and the comic book style stuff from Lichtenstein. We had enjoyed the portrait work by J.D.Ferguson when up in Perth a few months back, and there were a few examples of his work. A bit more accessible for a heathen like myself. On an academic level, it was good to see rooms of examples of the different artistic movements, even if they aren’t quite my thing.

I’m afraid I need to go a good distance on Paolozzi to even begin to like his stuff. Ho hum.

Chickened out of the walk down to the Water of Leith at the back of the Modern Art gallery, another time perhaps (looked a bit of a climb).