News Flash: Wally has been found

It’s been years, many books, and finally the day has come. Here is Wally

A Quick history of the internet

Anybody who thinks Microsoft haven’t gotten their mojo back only have to stop and grab IE8 and take a look at this video (IE8 not required)..

IE8 News

Straight from the horses mouth via twitter. “@NickHodge IE8 Final: you'll be able to download it from 3:00am AEST tomorrow. http://www.microsoft.com/ie8”

So, I guess tomorrow morning I’ll be updating my IE8 RC installs.. w00t!!

The Joy of Development

One of the most rewarding parts of my job is delivering new software that makes a difference for my clients. It’s part of the reason I’m still working in the industry, it makes me feel good.

The other thing I really enjoy, and something that has happened today, is the ability to make a program (or small part) run faster. It was just a simple query, with a few tables, a view and sub query or two. In one of our environments the query run blazingly fast, taking only 2-3 seconds. In all of our other environments (one of which is an exact replica from 2 days ago) took a long time too complete. By a long time, I mean it took more than 15 minutes before I lost patience and stopped the process.

So, what changes did I make? Simple, it was just a restructure of the query. As I mentioned before, there was a sub query. This sub query was used within the where clause. An example is:

WHERE Table1.Field1 In (SELECT Field2 FROM Table2.Field2 WHERE Enabled = ‘Y’)

became:

FROM Table1 INNER JOIN (SELECT Field2 FROM Table2 WHERE Enabled = ‘Y’) as Table3 On Table1.Field1 = Table3.Field2

By moving this into the From section and making it an Inner Join, I was able to help the optimiser make the decision to apply the filter earlier in the execution.

The result, ever environment now runs the query sub second.

You may ask yourself, how did I know where to look? The answer is all in the tools you use. Today, I was using Toad, and a simple “Explain” on the query quickly shows you where the execution cost is. SQL Management Studio and many other tools can all provide an execution plan that you can use. There are a few things that you should focus on when looking over an execution plan. The two I focus on the most are Cost and Full Table Scans.

Cost provides you with a figure relative to the whole query about how expensive that operation is. If an operation is excessively expensive then you should try and simplify it.

Full Table Scans generally occur when there are no suitable indexes in place. This means that a filter cannot occur on an index and instead “scans the whole table”. As you can imagine, on a large table this can be a very time consuming process.

There is plenty more information available over the web on this topic. This is just one of my favourite (and easy) fixes for a very common database performance issue.

* This is a very simplified example of the actual query

Pick a Search Engine

A few weeks ago, I woke up early in the morning and made a decision too do something different. For the life of me, I didn’t know what I wanted to do, but I had a need too change something. That day happened to be the same day that Google decided to join the EU bandwagon and complain about Microsoft bundling I.E. with Windows. This news rubbed me the wrong way, it’s not like Google has been massively effected by this, as they’ve only recently bought out Chrome.

Anyway, after reading that, I made my decision, I was going to try and live a life without Google.

So far, it’s proven a little more difficult than I’d like, not because I rely on them, but more because of habit.

The only habit I’ve successfully changed is my web searching (because I just changed the default search engine in IE8). I’ve tried to break other habits, such as using Live Maps, but alas, the coverage in Australia is just not as good as Google Maps. Just today as an example, I did a search for Moore Street in the ACT. For anybody who knows Canberra, you may know that this street is right in the Centre of the City. Unfortunately Live Maps still can’t find it.. Luckily, Where Is came too the recue.

I’m still trying to find my feet in this Google-Free world, and while I’m sure I may never be completely free, I am pleasantly surprised that the world hasn’t come tumbling down yet.

*Yes, I’m well aware my blog is hosted by Google, I’m still not sure if I’m going to relocate it or not.

Google and the Linux desktop… Oh please…

People have been jumping up and down in the vein hope that Google will move into the desktop space. I’ve heard this discussion before, yet here it is again.

It’s an interesting idea. Start by slowly working around vendor lock in, to position yourself with an end too end replacement for existing infrastructure then BAM, put out an OS too free the people.

Unfortunately, I think a lot of people seem too be forgetting a few simple facts. The most important of these is the business that Google is. Google runs a search engine. But, Google the company is in the business of Advertising. Yep, that’s right, providing the ability too search is just a way to bring people in too view advertisements.

Google docs, Gmail and Google Calendar are all the same. Provide a service too bring people in, then serve up some ads. That’s the business Google is in.

All of the articles/discussions I’ve read about Google on the Desktop have all talked about some sort of Linux Distribution. Great, it could be cool. But Google will still want their advertising cake. Are they going to modify their own Linux distribution too include built in advertising? Are they going too remove the popular email clients, calendaring applications and office applications in order too force users too continue using their online, advertising supported applications?

The answer too this is clearly no. Google will not give up their revenue stream.

I think a more likely scenario is a Web Based desktop. Something that keeps users away from the PC based desktop, and all PC based desktop apps, and keep the users working in the Advertising based world that Google is clearly the king.

There is no Right Join

From very early on in my career, I’ve coded SQL by hand. This is nothing particularly special, but it always astounds me how many people still get confused over the various types of joins.

Over at Code Project, I just stumbled across an article that does a pretty decent job of explaining the various join options, but it did remind me of something very interesting.. See, in my 11 years in the industry, I have never had a need for a right join. Why?? Simply put, Right Joins are just backwards left joins.. If you get your table ordering correct, then right joins don’t exist.

So, I hereby call for an end too useless right joins…

I used too just melt them..

Customised My Little Ponies..

A new phone, and an interesting system

Well, over the weekend I finally took the plunge. I said goodbye to my trusty old JasJam and got myself a HTC Touch Pro.

Along with this new phone, I also changed my telco. I had been with my previous telco for over 11 years, and in general hadn’t had any major issues. That was until I started looking at the Touch Pro. See, the Touch Pro was released exclusively to a single provider here in Oz for 3 months. That 3 month period started back in October last year. Fast forward 4 months, and the phone is still only available at one telco.

I contacted my previous telco, through several different methods, via phone, email and in person at their stores. Unfortunately, this is where things started too turn for me. I couldn’t get an answer about this phone. I got everything from “Would you like to just get another phone” to “What’s a Touch Pro”. This really struck me as strange. Nobody seemed to know anything, not their sales people, not their customer support, nobody. Any company that can’t answer a simple question about product availability has some serious problems.

Anyway, back too the new telco. So far I’m reasonable happy, but one thing did strike me as odd. See, as usual, the telco had to do a “credit check”. But the format of the credit check was by far the most interesting I’ve seen. It involved a few quick questions:

• Are you employed
• How long have you been employed
• What type of employment

From this, they managed to approve me for 3 services. So, I could pick up 3 phones on plans. Wow, that’s great.. The problem is, the system in no way took into account my income, the plans I was going to get, the monthly repayments or even my other commitments. I even confirmed this with the customer representative, I could get 3 brand new phones, all on $200 plans..

CodeCampOz 2009

That’s right folk, Code camp is back for another year, and anybody who’s been before knows it’s worth making the trip.

Mitch has announced the details and registration is now open.

Unfortunately, this year I won’t be there. See, it happens to be on my birthday..

Interesting Problem

I came into work this morning, to find my inbox full of errors from one of our production applications. This application has been running full time for a long time.  The exception that our app was throwing was:

The security timestamp is invalid because its creation time ('xx/xx/xxxx xx:xx:xx PM') is in the future. Current time is 'xx/xx/xxxx xx:xx:xx PM' and allowed clock skew is '00:05:00'

After a little searching (ok, it took 30 seconds), I stumbled across a great post about this.

A little further digging and my assumption was correct, this is actually tied to Kerberos.

Anyway, in this case, I didn’t follow the easy solution of changing the binding behaviour, instead I got out systems guys to ensure that all the machines in question have their clocks correctly syncronised.. It seemed like a better long term solution.

Test Data

I’ve always been a big proponent of using the best test data possible. As a developer, I find that it’s very easy to get lost in the details of implementation, and tend to leave the generation of test data till a later stage of a project.

The problem I find is that by leaving the generation of test data till the end, more often than not, I end up only testing edge cases (which is extremely important), but I tend to not spend enough time generating large quantities of normal data. A result of this is that it’s easy to miss performance problems.

So, as of today, I’m making sure I have sufficient amounts of test data up front. Best of all, I’m focusing on automated data population from various sources. One of my favourite sources for this is Wikipedia. For any large body of text, I find just grabbing a random article is perfect.

Annual Noise Cleanout

Well, it’s that time again, yep, I’m cleaning out my list of blogs, twitter friends and every other bit of noise that I find is just not providing any use.

Unfortunately, while examining what I’m currently subscribed too, I noticed something that was a little disturbing. Once, a long time ago, I had most of the MS Oz PDE team in my feed, as of today, I’m down too one.

I used too find the information coming out of this group extremely useful. In particular, Information about Dev tools, events and new technologies. I’ve found over time, these blogs have reduced to general noise about peoples lives, or have just plain gone quiet. They no longer serve the purpose I had subscribed to them for.

This isn’t the only group I’ve cleared out, but it’s certainly one of the most disappointing ones. On the bright side, over the last year, I have picked up a number of feeds from overseas that have replaced the ones I’m now removing.

Ed.

Is it really that simple

Working in the Apps dev space, you quiet often get issued with bugs and feature requests that users expect to be very easy to fix. As a general rule of thumb, I attempt to fix anything the user wants as long as it fits within the scope/budget for the project. As with everything though, quiet often a bug/request will be issued that is actually a lot bigger and more complicated than it initially appears.. And this brings me to something I've been sitting on, thinking about for a few weeks..

Over on CodingHorror is a post about a "bug/feature request" that seems to have been made into a big issue. It's a request to have the Windows Forms designer automatically default the forms font to Segoe... On the surface of this, its a pretty simple request...

The problem for me is that i use VS2008 and target Win XP AND Vista.. Unfortunately, I cannot guarantee that Segoe is actually present on the target machine, and I'm not too sure if I'm actually allowed to distribute the font (I'm guessing I can't..).. This raises an interesting problem.. Windows Forms doesn't deal very well with automatic resizing. It can be done, but requires a lot of extra work, and because of this, I don't want to use Sagoe and risk the target machine picking the next best font..


Sure, there are options available, like having project settings determine the font.. i.e. a "Vista Only" option, but personally I think that allowing the users to just select the font they want works best..

Anyways, back to the grind...

I'm excited

At times, working in the IT industry seems to be a little slow, dull and much the same as the previous day. this has been the case lately with the media continuing to blast Microsoft over Vista. Everywhere you turn, there are complaints, "10 reasons why x is better than Vista" and any other thing you can possibly imagine.

As for me, I've had no major issues with Vista, I use it to work, i use it to play, and for the most part, it works.. Sure, there are one or two little things that I may think need improving, but that's the same for any OS..

But, I guess back to the topic, and that its the reason for my excitement.. The last few days have reminded me exactly why I love this industry. Here's why:

Tuesday I started a new Job, and we also started to get information flowing in from PDC2008. The big news items, well, here they are:

• Details on Windows 7 have started flooding in, it's Vista but it's better..
• The Announcement of Windows Azure.. Yep, the cloud computing OS
• And Office on the Web

I'm not going to go into details of each and every feature here, but there are a lot. I guess what I'm more interested in is the fact that a company who, according to the press is "struggling" to provide such wide ranging announcements and to even get a lot of positive feedback from folk who have been very critical of late.

I can't wait to get my hand on some of this.

Silverlight 2.0 Released

The title says it all.. And here's the link to the announcement. For me, this is what I've been waiting for, Silverlight 1 was nice, but lacked a lot of features that I personally believe were required to make it useful beyond media streaming and basic flash type apps.. Silverlight 2.0 brings in everything I need as a developer to really start pushing it for internal business apps developement.. Yay!!!

Current Reading List

I thought I'd just put up a quick post of my current reading list. So, here it is:

Feel the Fear and Do It Anyway
The God Delusion
Fish!

I don't know why, but I quite often find myself reading a few books at the same time.. Maybe I need to learn to focus a little more ;)

w00t

I just read over on Mitch's blog about some new features that are going to be included into the next release of TFS Power Tools. Each of these new features looks awesome, but one caught my eye in particular that I personally can't wait too see. that feature is the new Team Members folder. Not only will this allow you too visually see who is in your project team, but it will also provide integration with your *IM client for presence, notification and vital communication functionality.

I'm all for collaboration, and any tools that help me communicate better with team members is a win in my books.

*If your IM client supports it..

VS2010 & .Net 4.0

W00t, just a quick post to link up the announcement of Visual Studio 2010 and the .Net Framework 4.0. Here's the link

Oh yeah, just a quick wish on the collaboration side.. I want to be able to have multiple people working on a diagram at the same time.. Think of it like collaborative "white boarding" but.. well.. not on a whiteboard.. I know that there are a million tools available for basic whiteboard sharing, but they all ultimately end up requiring one person to convert it into UML/DML etc.. I'd just like to take the middle man (or format) out of the picture..

Can't wait too see where this all goes..

IE8 Beta 2

Most people by now are probably aware the IE8 beta 2 has been released. In my last post, I quickly touched on Ubiquity, and it's interesting too see that other people also believe that Accelerators (the feature formally know as Activities) goes a way to providing the same functionality, seems some people do get it.

Besides this, there are many other features that IE has been needing for a while. The biggest as far as I'm concerned is InPrivate, closely followed by the work done on performance (speed increase, memory usage etc).

Unfortunately I won't get a good chance to get my hands dirty until later today, but I'm sure looking forward to getting IE8 beta 2 running on my machine at home.