To much to do, not enough time to blog about it!

I’ve not posted any blog entries because I’ve been working on some things that I’m hoping will benefit a lot of people.

Right now I’m installing SQL Server 2008 CTP 5 (November 2007) in a virtual machine. Earlier today I downloaded the RTM of Visual Studio 2008 Team Suite and I’ll be installing that on my desktop PC shortly.

So, what have I been working on? Mainly something that is going to get announced at DDD6 if I can hold back my enthusiasm. It is going to be good and I’m really excited.

I’ve still got some preparation to do before DDD6 for my session on Recruitment. Although not as much as other speakers as most of my session will be impromptu and I’ll just be going with the flow (so long as it isn’t flowing over too many rapids).

Scottish Developers have also been active. Last week we had a double bill in conjunction with the Scottish SQL Server User Group with an Introduction to Reporting Services by Frank Kerrigan and SMO by Steve Phillips. One bit of feedback we will be taking into account is not having two main presentations back to back. Although everyone appreciated the content given many people also commented that there just wasn’t enough time for both subjects to be covered well. So, rather than trying to cram as much as possible in, we will be returning to one main speaker for future evening events.

Frank’s Introduction to Reporting Services slide deck is available on Scottish Developers, as is Steve’s SQL Server Managed Objects slide deck and source code. (Note: you will have to register, for FREE, in order to download the information)

We also managed to give away a lot of swag. Everyone got a SQL Server fleece, which was absolutely perfect for a cold November and one lucky person won a complete set of “Inside SQL Server 2005” books worth nearly £100.

So, what does Scottish Developers have lined up for next year. Well, I don’t really know – I’ve not got anything firmed up yet, but the feedback we’ve been getting from events consistently puts “Patterns and Practices” as the number one item people want to see talks about. So, in this regard, Gary Short has agreed to make the trek from Dundee again to talk about his favourite patterns (which he will be doing at DDD6) or the web client software factory (a repeat of the talk he did at the VBUG conference) or possibly even something else patterns and practices related. I’ll also be keeping a look out for any other talks in the area of patterns and practices.

We have some close ties to the Scottish SQL Server User Group so no doubt there will be a SQL Server talk on the agenda at some point – I’ll even be weighing in on this front as I am very keen on all the new spatial querying that is going to be available in SQL Server 2008.

DALs and the DAAB

I’ve been pondering something that was raised in passing earlier this week and that is the relationship between a DAL (Data Abstraction Layer) and the DAAB (Data Access Application Block).

It was briefly mentioned in a conversation that I had that the DAAB provides the functionality of a DAL because the developer doesn’t need to worry about the back end database that is being used. I suppose to some extent that is true. However, I don’t believe that it fully functions as a DAL.

To my mind a DAL abstracts the access of data away from the rest of the application. Most people seem to restrict this view to data being held in a database.  But databases are not the only repository of data. Data can be held in plain text files, CSV files, XML files and many other formats. It doesn’t need to arrive by file, it could be data from a service or other mechanism.

If you treat sources of data as being more than a database then the DAAB is not a suitable substitute for building a DAL.

Also the DAAB has some limitations in that it cannot translate the SQL itself. For example the flavour of SQL in Oracle has differences to the flavour of SQL in SQL Server. This means that any SQL code will have to be translated. One possible solution is to ensure that everything is done through stored procedures. Then all that the DAAB needs is the stored procedure’s name and the values for the parameters.

But what of passing stored procedure names and parameters to the DAAB? Wouldn’t they need to be known in the business layer? Surely the business layer should know absolutely nothing about the database? Absolutely, the business layer should not be concerning itself at all with the database. It shouldn’t know about stored procedure names, parameters or anything else, even if the DAAB takes care of figuring out the details under the hood from information picked up from the config file. The Business Layer should just need to know there is a DAL and a method on the DAL can be called and some results come back. How the DAL does anything is of no concern to the business layer.

A quick and dirty test, in my opinion, is to look out for any classes from the System.Data namespace in the business or presentation layer to determine if the DAL is well designed.

In my mind the DAAB is just a tool that can be used to make the creation and maintenance of a DAL easier when dealing with databases. It makes it easy to change the location of databases as the development process moves along from the developers’ machines, to continuous integration, test, pre-live and finally live (or what ever your process calls for). The argument that the DAAB makes it easy to swap out one type of database for another isn’t something that is actually going to be done all that often. From what I’ve seen, companies generally run two systems concurrently until the old one is discontinued. Rarely do they ever actually update the old system to use the new database and when they do it is usually via some form of orchestration system so the old system doesn’t need to be changed in any great way. If it isn’t broke don’t fix it.

Tags:

Web Client Software Factory

Yesterday evening myself and a colleague drove up to Dundee University to see a presentation by the North East Scotland .NET User Group on the Web Client Software Factory by Gary Short.

I have to admit that I wasn’t sure what to expect. The WCSF was one of those things that I’d vaguely heard of but hadn’t paid much attention to because I don’t do much web development. What I saw surprised and delighted me.

From xkcd.comGary has a slide deck for his presentation but we only saw one slide because he told us we weren’t really interested in the slides and he jumped straight into coding for the rest of the session.  Now, I have to say that watching someone code for 90 minutes is generally not my idea of fun, but Gary’s presentation skills are such that he keeps you entertained during the slow parts (such as when the code was compiling and so on) and his explanations are pitched at just the right level so that you understand what’s going on without over explaining anything and ensuring that everyone is keeping up.

However, there were parts where some improvement could be made. For example the first few minutes were spent watching Gary write some SQL Code. Since there was nothing new there for us it could easily have been a pre-existing file that was opened and executed with a cursory description about the table, data and stored procedures. (I hope you don’t mind me saying that, Gary, because it was other wise very interesting).

Now about the WCSF itself. It comes with some plug ins for Visual Studio which help you quite a bit by generating the project and organising, the code stubs and other bits and pieces. There is even the ability of creating complex workflow through your website by integrating with Windows Workflow.

I cannot do justice to the description and detail that Gary gave so I’ve invited him to present to Scottish Developers sometime early next year. We just have to get a date sorted out, so watch out for the event going up on the Scottish Developers website. In the meantime I’m going to be trying it out for myself.

Gary is also presenting at DDD6 (24-Nov-2007) on his favourite patterns.

Tags:

The Ashoka Karaoke

I wouldn’t normally review restaurants on my blog but a friend of mine has just received a lawyer’s letter about his review of a restaurant called “The Ashoka” which does karaoke and is located in Elderslie Street, Glasgow. He has currently pulled the blog post. I hope only temporarily. I have no truck with bullying letters from lawyers demanding people take down opinion pieces.

Anyway, while that review is pulled I’d like to give my opinion. I want to stress this is all my opinion and you can’t take that away from me you evil people you (See, that’s an opinion. You may or may not really be morally wrong or bad; immoral; wicked; harmful; injurious; characterized or accompanied by misfortune or suffering; unfortunate; or disastrous, but in my eyes you are. So there!)

We went to The Ashoka Karaoke as part of a work night out (FACT). We each paid £20 in advance for the karaoke menu(FACT).

Now, for £20, which did not including the drinks (FACT) – we had to pay extra for them and the money was taken immediately (FACT). Unlike any “normal”* restaurant (FACT). This didn’t engender a very good atmosphere (OPINION). I expect a certain quantity and quality of food for £20 (OPINION). Both were lacking (OPINION). The portions that were to be shared were quite small (OPINION). And I never saw any evidence of the pudding which I was told was part of the meal (FACT)

The illumination in the restaurant was quite dark (FACT). This meant it was difficult to determine what the dried in lumpy bits in the table cloth were (FACT). I reckon it was previous curries that had not washed out properly (OPINION).

Their website says they have won awards (FACT). It says on their home page “Ashoka restaurant was awarded the best restaurant in Scotland and awarded the best curry in Britain” (FACT). Personally, I can’t see how that could have happened (OPINION). I have been to a lot better restaurants in Scotland (OPINION) and I’ve had better curries in Britain (OPINION).

The meal was awful (OPINION) and I would NOT recommend anyone to go here unless they were almost paralytic (OPINION).

 

RATING: 0/10

 

* Normal in the sense that it would be a general expectation by all elements in that class.

Blog stats for October 2007

I’ve been running Google analytics on my blog for a while now and the results are quite interesting. So here are the top ten posts of October. (NOTE: These were not necessarily posted in October)

10. What’s new in Visual Source Safe 2005 (28/Oct-2005)

9. Chocolate Crunch Cake (4-Aug-2007)

8. A fantastic cartoon on SQL Injection Attacks (11-Oct-2007)

7. My Session is a GO for DDD6 (22-Oct-2007)

6. Visual Studio 2005 on Vista (17-June-2007)

5. SQL Exception because of a timeout (17-Oct-2005)

4. Internal Error 2755 caused by folder encryption (15-Oct-2006)

3. What is a DAL? (part 2) (5-Sept-2007)

2. What is a DAL? (28-Aug-2007)

1. Life imitating art (11-Oct-2007)

 

What I find interesting is the number of posts that are in there from one or two years ago.

My plans for DDD6

I’ve been looking through the agenda for DDD6 and there is a lot of fantastic sessions there and I’m going to have to make some hard choices on the day. So what appeals to me:

In the first session I’m interested in Oliver Sturm‘s “Business Applications with WPF – The Full Monty” and also Ian Cooper‘s N-Tier applications with LINQ.

In the second session I’ve also got two conflicting sessions that I want to see: Chris Hay‘s “Introduction to Silverlight 1.1 (no pesky javascript in this talk)” and Gary Short‘s “My Favourite Patterns”

The third session is my toughest choice as there are three things I’m quite interested in. The second part of Oliver Sturm’s “Business Applications with WPF – The Full Monty”, Mike Hadlow‘s “Why do I need an Inversion of Control Container?” and Ben Lamb‘s “Being Lazy with Microsoft PowerShell”

After lunch I’m up with my “Question Time on the subject of Recruitment“. The panel includes Barry Dorrans, Sarah Blow, Frank Kerrigan and Karl Lightfoot. I would like to see some of the other sessions at that time, but naturally I’d like you to come and see my session.

Finally, I’d like to see Barry Dorran’s session on “Web Services? We don’t need no web server”. Although, if I don’t feel I can take any more information in I’ll probably end up in “Swaggily Fortunes”

To round it all off I’m sure there will be a geek dinner somewhere – although that’s not been announced yet.

MVP Open Day

That was a great couple of days. Lots of good information was exchanged. Lots of interesting people were met.

What was most interesting was that the audience, being made up of highly skilled experts, were much more on the ball and asked much more in depth questions of the speakers. I think that if I’m going to present at an MVP open day I’d have to prepare a level 400 talk rather than the usual plethora of level 100 and 200 talks (with an occasional 300) that happens at more open conferences like Developer! Developer! Developer!

What was also interesting was that for the first time I was communicating with other people in the audience as well as those outside with Twitter.

The event kicked off with a round table discussion about upcoming stuff. It was then followed by a dinner in the Novotel. The dinner was extremely nice and some what esoteric. It started off with Gazpacho soup, which I wouldn’t recommend for late October as it is really a summer dish. Followed by fillet steak on a bed of cabbage and a scoop of ice cream (although the waiter was insistent it was sorbet). Then for dessert (yes, the ice cream was on the plate with the steak) was some sort of small cake thing. I don’t remember much about the pudding because it was so uninteresting compared with the rest of the meal.

The next morning we got up bright and early. Well, others did. As I never managed to get any sleep (insomnia) I just rolled out of bed when the alarm went off. We got a free bus from Reading station to TVP (Thames Valley Park) where the Microsoft Campus is located. FREE public transport! What a great idea!

The morning sessions were by Microsoft DPEs. Mike Taulty and Mike Ormond showed us Silverlight, the Daniel Moth showed us all the new goodness in VS2008. I have to say that I would have liked to have spent more time on Silverlight and got much more in depth with it, but there wasn’t the time.

After lunch it was the turn of the MVPs to present to their piers peers. First up I had agreed to be Dave and Rich‘s victim guinea pig for a session on podcasting. It was actually quite intimidating because they had set up a chair that I was to sit in then they both stood over me and fired questions at me. I felt that I was looking up at two overbearing teachers like a naughty schoolchild. Apart from that it was good fun. The funniest part was that Craig and I were running a bit late and arrived at Everest (the room where their session was being held) and we were the only two people there. Luckily the room filled up about 2 minutes later when the official escort (the room is in a restricted area) arrived with a stream of delegates.

Oliver Sturm was up next on dynamic languages. It was quite interesting and even featured emacs (I’ve not seen that in years). It reminded me of a dynamic language I used to use called Magik which was loosely based on Smalltalk. I was sitting next to Barry Dorrans for this session and jeez-o can he heckle ask energetic questions. I thought Oliver responded very well to the barrage of questioning. However, it did mean the session went over a little bit. And for Gary Short’s benefit: Oliver didn’t describe Smalltalk as a functional language.

Guy Smith-Ferrier was up next but he only had 2 minutes to set up as Oliver had over run so much. However, the audience had other ideas. Although we took a shortened break Guy didn’t start until 10 minutes after his session was due to start. Guy gave a condensed talk on Astoria which I had already seen before as he delivered it to Scottish Developers earlier in the month.

Finally there was a session about upcoming changes to the MVP programme. Then we went back to the Novotel for dinner.

Once again the Novotel gave us an interesting dinner. This time the soup was hot. It was cream of mushroom but they’d put a froth of milk in the middle of the dish and it looked like someone had spat in it. However, it tasted okay. The main course was pork on a bed of lightly fried potatoes but no ice cream this evening. The dessert was, once again, unremarkable compared to the rest of the meal.

During the night the Novotel sent a message to everyone’s television about the meeting later that morning. It was accompanied by a loud beeping alarm that woke everyone up. Naturally the next morning everyone was complaining about it. The hotel were very apologetic and everyone’s bar bill was erased in compensation.

The morning’s meetings consisted of two sessions. The first was hosted by Craig Murphy, Phil Winstanley and Richard Costall and it was all about community. One of the things I got out of this was the idea of recording short ~10 minute grok talks, nuggets or micro-presentations as a way of engaging more with the community. I think the ITPro community got the most out of it as they don’t have many user groups and it was suggested to them that they should.

In the second session Barry Dorrans got a bit riled up. He was arguing strenuously against the poor MVP leads who are not technical folk and kept falling into making statements that he ardently disagreed with on architecture grounds. They couldn’t respond to these comments. I’m wondering if Microsoft really know what they’ve let them selves in for with Barry. He knows his stuff and isn’t afraid to use it – that much is certain.

Afterwards a few of us (Craig Murphy, Dave Sussman, Phil Winstanley, Oliver Sturm, Barry Dorrans and myself) went off to Wagamamas for lunch. It was a very geeky lunch as I’m sure the conversation and the jokes would have been completely unintelligible to anyone without a thorough grounding in software development, tcp/ip, and various Microsoft products. Finally, a much appreciated thank you to Dave who was kind enough to give me a lift to Heathrow airport.

DDD6 Full… Already!!!

Registration opened yesterday for ~350 people + a wait list. It DDD has broken records again by being booked up in about 1 day!!!

I didn’t believe it so I went to the registration site and sure enough it says that it is accepting registrations to the wait list only.

Technorati Tags: ,

My session is a GO for DDD6

I’ve just had a confirmation email through that my session has been selected for DDD6.

A panel of experts will answer the audiences questions on the subject of recruitment chaired by Colin Mackay. This session is for you if you are looking for a job and want to find out what companies are looking for. You are trying to hire someone but don’t know what to look for. You have been burned in the past and don’t want to repeat the experience. You have a question about recruitment no one else seems to have an answer to.

There will be a question box on the day for you to post your questions, but if you want to email in advance, you can email your questions to colin@scottishdevelopers.com. Submissions by email close at 23:59 on the 23rd November.

The panel is:

Sarah Blow: Founder of Girl Geek Dinners and software Engineer.  She has grown up around technology and HR with parents in both industry sectors and works closely with Women & Technology and companies to create a better understanding about how women may be recruited in different ways to men.

Barry Dorrans: Senior consultant for a major consultancy and Microsoft MVP. When interviewing he takes the red pen and becomes intellisense for whiteboards.

Frank Kerrigan: Development team lead for an insurance company’s internal development team in Glasgow. His team writes enterprise applications for internal customers using C# and SQL Server. Frank has been in devolvement and support of enterprise systems for 15 years.

Karl Lightfoot: Recruitment Consultant that for the last 9 years day in day out has only been recruiting developers in the Midlands region for the largest IT Recruitment consultancy in the UK. He has successfully recruited for large and small corporations through different market states of the supply / demand of talented Developers from Visual Basic 3 to .Net 2005.